I concur
Probably this will work
$result = mysql_query("UPDATE table SET value1='$value1',value2='$value2'
WHERE id=$id");
remember integers id=1 are not strings id='1'; not the same!
-----Original Message-----
From: Martin Towell [mailto:[EMAIL PROTECTED]]
Sent: December 5, 2001 11:37 AM
To: 'Tyler Longren'; Greg Sidelinger; [EMAIL PROTECTED]
Subject: RE: [PHP] mysql update query
are any of the fields of type number/integer/etc? if so, try removing the
quotes for that field.
-----Original Message-----
From: Tyler Longren [mailto:[EMAIL PROTECTED]]
Sent: Wednesday, December 05, 2001 2:36 PM
To: Greg Sidelinger; [EMAIL PROTECTED]
Subject: Re: [PHP] mysql update query
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" <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
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
>
--
PHP General 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 General 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]
