Simple MySQL w/PHP IF Statement

[Kaitosoto]

This should be simple. After using PHP to connect to a MySQL database, how do I make an IF statement with a query?

 

like, I know that when you do something like

$sql = "UPDATE fdatabase SET blah blah blah";

$query = mysql_query($sql,$connect);

 

It connects to the thing. How do I make it so that it is conditional like this:

 

if(-MYSQL QUERY THAT SELECTS A VALUE FROM one of THE fdatabase tables- = 0) {

$sql = "UPDATE fdatabase SET blah blah blah";

$query = mysql_query($sql,$connect);

}

else

{

-do nothing

}

 

[ToonMariner]

If you want to check if the update has happened then check mysql_affected_rows($query) == 0

[Kaitosoto]

No, I want to check to see that the value that was found with the SELECT in the first query was greater than 0. If so, then execute the second query.

[fert]

http://us2.php.net/manual/en/function.mysql-num-rows.php