[PHP-DB] MySQL UPDATE problem From: Malcolm White (mwhite <email protected>)
Date: 08/30/01

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: 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>