[darkcarnival]

hi,

a different php forum gave mee a code to show a no item found error that gave me a parse error heres the line of code they gave me:

PHP Code:

if (mysql_numrows(mysql_query($results "without LIMIT"))>0) {} else {echo "Nothing found";} 

if this is right, then what am i doing wrong.thx

[YourPHPPro]

Originally Posted by darkcarnival

PHP Code:

if (mysql_numrows(mysql_query($results "without LIMIT"))>0) {} else {echo "Nothing found";} 

What is $results ??

[darkcarnival]

$results is the results of $query

[YourPHPPro]

PHP Code:

mysql_query($results "without LIMIT") 

That wont work unless there is a typo as mysql_query needs a comma between its query and resource link.

resource mysql_query ( string query [, resource link_identifier])

The better way to find out how many results there are is by using a query like:

Code:

Select count(*) as Count from table where .....

[darkcarnival]

ok i got told to try that as well but what do i add to WHERE? if you could tel me how to do where i could do this.thx.