Not updating db??

[deep]

Hello,

My code will not update the values in the db when the page is called!!?

$sql = "UPDATE mix_users SET user_online='$online', user_online_text='$timestamp' WHERE user_id=$id";
$result = mysql_query($sql);
$row = mysql_fetch_array($result);

Whats wrong??

Thanks!

[laserlight]

There probably isnt anything wrong.

Just that your mysql_fetch_array() doesnt makes sense since the resource returned shouldnt contain a result set, as it merely confirms if the query was executed ok.

[deep]

i put the fetch array there just to test. Its not working ither way 😕

[deep]

im i seposed to place the $sql update on a special place on the page or something??

[deep]

ok i fixed it... 🙂