how do I say if variable is empty?

[futrose]

I have this line in my code

 

$result2 = mysqli_query($link, 'Select * from categories where cat_loc ='.$nav['id']);

 

how do I say "if $result2 is empty or false"? (basically if it didn't find any cat_loc = to $nav['id'])

 

to echo '</li>';

[Pikachu2000]

Check how many rows are returned with mysqli_num_rows()

[PFMaBiSmAd]

$result2 will be a result resource if the query executed or it will be a false value if the query failed due to an error. A query that matches zero rows is a successful query.

 

You need to use mysqli_num_rows($result2) to check how many rows are in the result set.

[futrose]

thanks guys, worked like a charm.