On Thursday 14 March 2002 16:20, John Hughes wrote: > $sql = "UPDATE parent_log > SET > classroom = \"$classroom\", > homework = \"$homework\", > library = \"$library\", > fieldtrip = \"$fieldtrip\", > pta = \"$pta\", > mast = \"$mast\", > meetings = \"$meetings\", > other = \"$other\" > WHERE parent_id = \"$parent_id\" > AND student_id = \"$student_id\" > AND week_no = \"$week_no\" > "; # end create sql query
You can use: classroom = '$classroom', homework = '$homework', to make the code more readable. -- Jason Wong -> Gremlins Associates -> www.gremlins.com.hk /* All the passions make us commit faults; love makes us commit the most ridiculous ones. -- La Rochefoucauld */ -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php