mysql update

[Anon]

i do an update to the Guests by IP but it updates all the Guests and not individual IPs... Why ?

$query = "UPDATE mundo_online SET time='".$time."' WHERE user='guest' AND ip_address='".$ip."'";

$online->query($query);

Why is it workin well ?

[lawnmowerman]

The first you should take is to print out your SQL statement to verify that it is constructed properly:

print $query . "\n";

The next thing that everyone should do is make use of the mysql_error() function:

print mysql_error() . "\n";

anytime that a query returns an error.

-Rich