[SOLVED] If in database do this...

[loony383]

Is it possible (and if so how) to check if a file in an database has a value set to 1 (value called reported) then if it isnt it sets it to 1 and if it is then it comes up with an error?

[jonsjava]

yes.

$sql = "SELECT * FROM `table` WHERE `value`='1' AND `some_other_thing`='something else';";
$result = mysql_query($sql);
if ($result){
print "error";
}
else{
mysql_query("UPDATE `table` SET `value`='1' WHERE `some_other_thing`='something else';");
}

I would help more if I knew more about what you are doing. Could you give us something to work with?

[loony383]

Ok ill try it.