Re: [PHP-DB] MySQL UPDATE problem

[Paul Burney]

on 8/30/01 4:06 PM, Malcolm White at [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
<[EMAIL PROTECTED]>

++



-- 
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
To contact the list administrators, e-mail: [EMAIL PROTECTED]

[PHP-DB] MySQL UPDATE problem

[Malcolm White]

I am having a problem with UPDATE queries with MySQL. Insert, Delete, etc
work fine. I have checked the query statement and it works fine directly
with MySQL just not in a PHP script. An example function is;

function update_gname($gid, $new_name){
  $query = "UPDATE Groups SET GName=$new_name WHERE GID=$gid";
  $result = mysql_query($query)
  or die("error: update_gname()");
  return $result;
}

I am using MySQL version 3.22.32 and PHP4.0.3pl1 as a module in Apache1.3.14
with Linux2..2.13.

Thanks,

Malcolm


-- 
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
To contact the list administrators, e-mail: [EMAIL PROTECTED]