Hi James, Please bear with my limited knowledge of PHP...
Does anyone know if it is possible to code a sql query within the message part of the mail function, e.g.: mail( "$to_mail","$sumject"," $sql = mysql_query("select * from table") or die("error with query\n"); while ($row = mysql_fetch_array($sql)) { $db_name=$row["name"]; $db_email=$row["email"]; $db_age=$row["age"]; echo"$name - $email - $age"; } " ); This obviously is wrong, does anyone know if its possible, if so, what is the right way of writing it?? =What's wrong with: $sql = mysql_query("select * from table") or die("error with query\n"); while ($row = mysql_fetch_array($sql)) { $db_name=$row["name"]; $db_email=$row["email"]; $db_age=$row["age"]; } etc... mail( "$to_mail","$sumject","$name - $email - $age" ); Regards, =dn -- PHP Windows Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php