[RESOLVED] SQL Query Line

[NZ_Kiwis]

I have this query line

$result3 = mysql_query ("SELECT * From table where id > $id order by id desc limit 1");
$row3 = mysql_fetch_array($result3);

I want to do a if statment. If there is no row to do one thing if there is echo the row id number

[rheinen]

Have a look at the mysql_num_rows function in the PHP Manual.

This might get you started:

[FONT=Courier New]if (0 == mysql_num_rows($result3)) {
// do something if there are no rows returned.
}
else {
// do something with the data we've retrieved.
}[/FONT]

Regards,

Ryan