[RESOLVED] Inserting record into mysql

[Jon12345]

If someone goes to mypage1.php and their ip address is already in my mysql database, how can I find that record and update the "status" field so it says "Yes"?

Thanks,

Jon

[Piranha]

You have 225 posts and still post without giving enough information. Please take a look at this thread to know how you should post and then update the question.

[Jon12345]

Each record has id, ipaddress, date,status.

Something like this maybe?

$query="INSERT INTO log (status) VALUES 'Yes' (WHERE ipaddress='".$ipaddress."'";
$result=mysql_query($query);

[Jon12345]

Got my answer:

if (!isset($ipaddress)) {
$query="UPDATE visitor_log SET status = '1' WHERE ipaddress ='".$ipaddress."'";
$result=mysql_query($query);
}