The query that gets done is:
Code: Select all
UPDATE Member SET LastActivity='2009-07-19 21:09:19' WHERE MemberId='cb40659e-cd4c-1a74-059f-23f22c2928b2' LIMIT 1The script that formulates the query is:
Code: Select all
$userid = $_REQUEST['s27userid'];
$date = date("Y-m-d H:i:s");
$qry="UPDATE Member SET LastActivity='" . $date . "' WHERE MemberId='" . $userid . "' LIMIT 1";
mysql_query($qry);Raptor354