How can we display "NO RECORDS" if there are no re



Guys, how can we display a text that says "NO RECORDS", if there are no records to be retreived or do not satisfy the query in the database.

For example

Select * from users where name ='d'

ID Name
No Records

Thanks guys.
mysql_num_rows($result) == 0

php has a bunch of mysql functions. Also, could do a count() in the sql to return back a count. I think the mysql_num_rows() function is what you might want to use.
I just realized that this was bad advice, so I've deleted the post. Erp.
hey guys, thanks. It worked i have to check wheter my select statement retrieved records. If not, it will display no recs, using if else statement.

thanks again, i'm really learning here!