Re: Creating an array of mySQL results with PHP
| From: | Jason Wong | Date: | Thu, 14 Mar 2002 08:49:44 +0000 |
| Subject: | Re: Creating an array of mySQL results with PHP | ||
| References: | 1 2 | Groups: | php.db |
| Request: | Send a blank email to php-db+get-17673@lists.php.net to get a copy of this message | ||
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
*/