Mail() Problem - 'Errors parsing file.php'

[Robbo]

I have set up a php script to send a notification email to customers one week after initially placing their order. Here's the code:

<?
# First, open a database connection
#
mysql_connect('127.0.0.1:3306', 'user', 'pass') or
die('Could not connect: ' . mysql_error());
mysql_select_db('database');

#
# Query the database for orders placed seven days prior to the current date
#

$result = mysql_query("SELECT title, lastname, email FROM table WHERE DATE_SUB(CURDATE(),INTERVAL 7 DAY) = DATE(FROM_UNIXTIME(date))");

#
# Now use PHP's built-in 'mail()' function to send the message
#

while($row = mysql_fetch_array($result)) {

$subject = "Order in Progress";

$title = $row['title'];

$lastname = $row['lastname'];

$message = "Dear $title $lastname,\r\n\r\n We are currently processing your order.\r\n\r\n Our despatch team will contact you (if not already) using the telephone number supplied with your initial order when your products are ready for despatch.\r\n\r\n Thank you again for your order, should you have any queries please call our sales team\r\n\r\n Thank you.\r\n";

mail($row['email'],$subject,$message,"From:[e-mail]\r\n");
}

#
# Finally, close the database connection as it is no longer required
#

mysql_close($link);

?>

I don't think it's the SQL query as running it inside MySQL returns the correct data.

[Robbo]

I should have mentioned, running ->php -a -e -l -f file.php gives this error:

Errors parsing \path\file.php

[rkagrawal]

I should have mentioned, running ->php -a -e -l -f file.php gives this error:

Errors parsing \path\file.php

Does the code you quoted belongs to file.php ?
If not , let me have the file.php because i cant see any error in the above code.


Rahul Agrawal
Developer
Web2003 Corporation
www.web2003corp.com