[SOLVED] Properly Evaluating mysql_num_rows()

[hellonoko]

I have below simple query that compares a URL to a list of URLS in a DB.

 

If the imput is found... $rows = 1; Then the code evaluates correctly.

However if the imput is not found mysql_num_rows(); returns nothing. Not 0 rows. Not NULL and my 'else' statement fails.

 

So I can only seem to evaluate to TRUE not to FALSE but I need both.

 

How do I do this properly so I can evaluate both ways?

 

$query = mysql_query("SELECT * FROM `secondarylinks` WHERE `link` = '$last_url' && `scraped` = '0' LIMIT 1") or die(mysql_error());
$rows = mysql_num_rows($query) or die(mysql_error());

if ( $rows === 1 )
	{

	echo 'found row';
}
else
{
	echo 'not found';

}

[JonnoTheDev]

$rows = mysql_num_rows($query); 
$rows = ($rows) ? 1 : 0;

[hellonoko]

That... Is awesome what does it all mean?

[hellonoko]

Alright I see how that works but it doesn't.

 

Because its not going to evaluate period because mysql_num_rows(); isn't returning. Period.

[Mark Baker]

Try

if ( $rows == 1 )

[hellonoko]

Works with:

if (mysql_num_rows(mysql_query("SELECT * FROM `secondarylinks` WHERE link = '$last_url' && `scraped` = '0' LIMIT 1")) == 1)
	{