[Resolved] Counting values in Query

I have a search function where I want to know if any values have been returned or not.

$result = mysql_query("SELECT * FROM products WHERE SubProduct='".$searchtext."' ORDER BY SubProduct");

What can I use to determine if $result has any values or not?

Also, how can I modify that query so that it has wildcards either side of searchtext?

Or...

if (mysql_num_rows($result))... <= I think this is it...

And...

'%search_wildcard%'

I've modified my query to this:

$result = mysql_query("SELECT * FROM products WHERE SubProduct='%".$searchtext."%' ORDER BY SubProduct");

But it doesn't work. 😕

Billions of threads over in the mysql forum...

Didn't even notice these forums had MySQL section. Thanks, answer sorted now.