Re[2]: [PHP] UPDATE mysql
| From: | Julie Meloni | Date: | Sat, 22 Jun 2002 19:49:50 +0000 |
| Subject: | Re[2]: [PHP] UPDATE mysql | ||
| References: | 1 2 3 | Groups: | php.general |
| Request: | Send a blank email to php-general+get-103424@lists.php.net to get a copy of this message | ||
CS> Actually, it looks to me like you're missing a semicolon terminating
CS> your SQL statement. Try this:
CS> $query="update $table set field1='$var1' where id='$id';";
Actually, that semicolon is not required (and I think it might even break it).
The user should echo the query as suggested previously, so as to
ensure that values for the variables are all actually there, and being
passed to MySQL.
- Julie
--> Julie Meloni
--> julie@thickbook.com
--> www.thickbook.com
Find "Sams Teach Yourself MySQL in 24 Hours" at
http://www.amazon.com/exec/obidos/ASIN/0672323494/thickbookcom-20