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

A

Anonymous

Guest
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!
 
You must log in or register to reply here.
Back
Top