Re: mysql update query
| From: | Tyler Longren | Date: | Wed, 05 Dec 2001 03:36:03 +0000 |
| Subject: | Re: mysql update query | ||
| References: | 1 | Groups: | php.general |
| Request: | Send a blank email to php-general+get-76639@lists.php.net to get a copy of this message | ||
Everything looks good to me...try this:
$result = mysql_query("UPDATE table SET value1='$value1',value2='$value2'
WHERE id='$id'");
Although I doubt MySQL cares if certain words are capitalized.
Good luck though,
Tyler Longren
----- Original Message -----
From: "Greg Sidelinger" <gate@psu.edu>
To: <php-general@lists.php.net>
Sent: Tuesday, December 04, 2001 9:27 PM
Subject: [PHP] mysql update query
> I'm having trouble getting an update query to work
>
> Here is what I'm doing
>
> $result = mysql_query("update table set value1='$value1',
> value2='$value2' where id='$id'");
>
> It is not updating the database. All the $vars have values and I'm
> using the correct columns names. Could someone please point me in the
> correct direction because I have been trying different things for a
> while but can't seem to get it to work.
>
> Greg
>