Inserting record into mysql

[Jon12345]

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

Each record has id, ipaddress, date,status.

Something like this maybe?

[code]$query="INSERT INTO log (status) VALUES 'Yes' (WHERE ipaddress='".$ipaddress."'";[/code]

Thanks,

Jon

[hitman6003]

Use an UPDATE query...

[code]UPDATE tablename SET field1 = 'newvalue', field2 = 'newvalue' WHERE idfield = 'a value'[/code]

[Jon12345]

Ahh update huh? Would it look like this?

[code]$query="UPDATE visitor_log SET status = '1' WHERE ipaddress ='".$ipaddress."'";
$result=mysql_query($query);[/code]

What happens if there is no value for $ipaddress? Does the code break?

[hitman6003]

it will update all reacords in the database that have no value for ip address.

[Jon12345]

Ok, so I presume I would do this:

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

Would that ensure it only gets updated if there is a value in $ipaddress?

[hitman6003]

don't use the !...

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

You're saying "If $ipaddress is not set" by using the !.

[Jon12345]

Oh yes, sorry. Stupid mistake. So if I remove the !, it will work as I stated? I'm a beginner if the question sounds lame.