Re: [PHP-DB] MySQL UPDATE problem From: Paul Burney (burney <email protected>)
Date: 08/30/01

on 8/30/01 4:06 PM, Malcolm White at mwhite <email protected> 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 <email protected>>
<http://www.gseis.ucla.edu/>
++++++++++++++++++++++++++++++++++++++++++++++++++++++++++ 

-- 
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, e-mail: php-db-unsubscribe <email protected>
For additional commands, e-mail: php-db-help <email protected>
To contact the list administrators, e-mail: php-list-admin <email protected>