|
|
Posted by paul814 on 01/02/08 17:23
On Jan 2, 12:18 pm, The Natural Philosopher <a...@b.c> wrote:
> paul...@excite.com wrote:
> > OK I think I am getting closer, thanks for the help.
> > I am getting this error:
> > Warning: mysql_num_rows(): supplied argument is not a valid MySQL
> > result resource in C:\xampp\htdocs\production\date2.php on line 26
>
> Thats because you never made a query at all.
>
>
>
> > this is my code as of now:
> > Generating and emailing report for:
> > <?php
> > $today = date("M j, Y,");
> > echo $today;
>
> > $host="localhost";
> > $user="root";
> > $pass="";
> > $db="productiondb";
> > $con = mysql_connect($host, $user, $pass);
>
> > if (!$con)
> > {
> > die('Unable to connect: ' . mysql_error());
> > }
> > mysql_select_db($db, $con) or die('Unable to connect: ' .
> > mysql_error());
>
> > // Get results from first table
> > $sql = "SELECT * FROM editorial WHERE editorialdate LIKE '$today%'
> > ";
> > $sql2 = "SELECT * FROM prepress WHERE prepressdate LIKE '$today%' ";
>
> > // Begin our email body
> > $messageBody = "Production Report follows for all departments: /r/
> > n";
>
> //You need a
> $result=mysql_query($sql); // in here
>
>
>
> > if (mysql_num_rows($result)) { // if there are results
> > // Add results from first query to email
> > while($row = mysql_fetch_array(mysql_query($sql))){
> > $messageBody .= "Editorial Date: " . $row['editorialdate'];
> > $messageBody .= "/r/n";
> > $messageBody .= "Editorial Name: " . $row['editorialname'];
> > $messageBody .= "/r/n";
> > $messageBody .= "Editorial Comments: " . $row['editorialcomments'];
> > $messageBody .= "/r/n";
> > }
>
> > // Add results from second query to email
> > while($row = mysql_fetch_array(mysql_query($sql2))) {
> > $messageBody .= "PrePress Date: " . $row['prepressdate'];
> > $messageBody .= "/r/n";
> > $messageBody .= "Prepress Name: " . $row['prepressname'];
> > $messageBody .= "/r/n";
> > $messageBody .= "Prepress Comments: " . $row['prepresscomments'];
> > $messageBody .= "/r/n";
> > }
> > }
>
> > mysql_close($con); //closes the connection to the DB
>
> > // Send email
> > ini_set("SMTP", "texchange.company.com");
> > ini_set("smtp_port", "25");
> > $headers = "From: Prod.Report_PREPR...@company.com";
> > mail("p...@company.com","Production Report",$messageBody,$headers);
> > ?>
>
> > And I do get an email, all that is in the email though is:
> > Production Report follows for all departments: /r/n
so will I need one of these IF statements before each one of my:
while($row = mysql_fetch_array(mysql_query($sql))){
and then do I also need multiple:
$result=mysql_query($sql);
only use $sql2 etc?
[Back to original message]
|