|
|
Posted by paul814 on 01/02/08 14:30
On Jan 2, 9:26 am, paul...@excite.com wrote:
> On Jan 2, 9:16 am, paul...@excite.com wrote:
>
>
>
> > I am having a bit of a problem with some code....can someone give me
> > some suggestions?
>
> > Parse error: syntax error, unexpected '{' in C:\xampp\htdocs\production
> > \date2.php on line 28
>
> > line 28 is this line:
> > while($row = mysql_fetch_array(mysql_query($sql)) {
>
> > It is the first while..
> > HERE IS THE CODE:
> > 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";
>
> > //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";
> > }
>
> > // Send email
> > ini_set("SMTP", "texchange.company.com");
> > ini_set("smtp_port", "25");
> > mail("p...@company.com","Production Report",$messageBody);
>
> > mysql_close($con); //closes the connection to the DB
> > ?>
>
> > thanks for any help
>
> I changed my code a bit because I did not have a couple ) and also
> added if (mysql_num_rows($result)) { // if there are results
>
> Now I get this error on the last line of my code the last line is my: ?
>
> the error is:
> Parse error: syntax error, unexpected $end in C:\xampp\htdocs
> \production\date2.php on line 54
Sorry, forgot to include the updated code:
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";
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");
mail("paul@company.com","Production Report",$messageBody);
?>
Navigation:
[Reply to this message]
|