function profilevisitor($userid,$profile){
$sql_profilevisitor="select * from friend_profilevisitor where userid='$userid' and profile='$profile'";
$result_profilevisitor=executeQuery($sql_profilevisitor);
if($line_profilevisitor=mysql_fetch_array($result_profilevisitor)){
$sql_update_profilevisitor="update friend_profilevisitor set date=NOW() and alert='1' where userid='$userid' and profile='$profile'";
executeQuery($sql_update_profilevisitor);
} else {
$sql_insert_online="insert into friend_profilevisitor (userid,profile,date,alert) values ('$userid','$profile',NOW(),'1')";
executeQuery($sql_insert_online);
}
}
This is my code I am working on, it inserts new entries fine into DB but when it comes to updating I get trouble.
$sql_update_profilevisitor="update friend_profilevisitor set date=NOW() and alert='1' where userid='$userid' and profile='$profile'";
It will update the value date to 0000-00-00 00:00:00 instead of the date and the alert row does not get set to 1
and ideas?
