Re: UPDATE table problem
| From: | Thomas \"omega\" Henning | Date: | Tue, 16 Oct 2001 18:42:22 +0000 |
| Subject: | Re: UPDATE table problem | ||
| References: | 1 | Groups: | php.db |
| Request: | Send a blank email to php-db+get-13378@lists.php.net to get a copy of this message | ||
affected rows() sed nothing 0 my create table was this CREATE TABLE(name
varchar(128), passwd varchar(128));
and i need 2 update name and passwd at the same time! and my mysql shel it
went perfectly!!!
Thomas
"George Lioumis" <glioumis@adacom.com> wrote in message
news:009a01c1557d$ad29b830$05041fac@adacom.com...
Hi, everyone, again,
Consider the following piece of code:
-------------------------
$update_query =3D "update guestbook set last_access=3Dnow() where =
guest_id=3D'$result'";
$update_query =3D stripslashes($update_query);
echo $update_query;
echo "<BR><BR>";
$updated =3D mysql_query($update_query) or die(mysql_error());
if ($updated)
{
.............etc etc
}
--------------------------
When ran, it returns:
update guestbook set last_access=3Dnow() where guest_id=3D'Resource =
id#2'
The problem is that if($updated) returns TRUE, but the last_access field =
is not updated at all !!! :(((
Any ideas as far as the $update_query is concerned???
George