If statement on Search results

[NZ_Kiwis]

I want to do a search to see if there is a row with the title = to title ie:

$result = mysql_query ("SELECT * FROM RLNZ_NEWS where Title = '$title'");
$row = mysql_fetch_array($result);

THis works fine but I want to do an if statement if there is a row or not....

How can I do this? or is there a better way?

[dagon]

$num_rows = mysql_num_rows($result);

if ($num_rows == 1){

}else{

}

[laserlight]

If your intention is to find out how many rows match $totle, I suggest doing a SELECT COUNT() instead of a SELECT .

$result = mysql_query ("SELECT COUNT(*) FROM RLNZ_NEWS where Title = '$title'");
if (mysql_result($result, 0) > 0) {
    // There is at least one row that matches $title.
}

[bradgrafelman]

Or if you're simply trying to check if there is 1 row or not:

$result = mysql_query("SELECT 1 FROM RLNZ_NEWS where Title = '$title' LIMIT 1");
if (mysql_num_rows($result) == 1) {
    // Found an article matching $title
}