Re: MySQL UPDATE problem
| From: | Paul Burney | Date: | Fri, 31 Aug 2001 01:28:28 +0000 |
| Subject: | Re: MySQL UPDATE problem | ||
| References: | 1 | Groups: | php.db |
| Request: | Send a blank email to php-db+get-12013@lists.php.net to get a copy of this message | ||
on 8/30/01 4:06 PM, Malcolm White at mwhite@whcomp.com wrote:
> $query = "UPDATE Groups SET GName=$new_name WHERE GID=$gid";
If the Gname field is a string type, there should probably be quotes around
it.
$query = 'UPDATE Groups SET GName="' . $new_name . '" WHERE GID=' .
$gid;
HTH.
Sincerely,
Paul Burney
++++++++++++++++++++++++++++++++++++++++++++++++++++++++++
Paul Burney
Webmaster && Open Source Developer
UCLA -> GSE&IS -> ETU
(310) 825-8365
<webmaster@gseis.ucla.edu>
<http://www.gseis.ucla.edu/>
++++++++++++++++++++++++++++++++++++++++++++++++++++++++++