Adding an error message if no data is returned in table

[michaelkirby]

Hi all,

 

I have a table which is populated upon a query. What I need to do is to be able to display a message saying 'No records returned' when the query doesn't return any rows.

 

Can any one help me out how to do this?

[laPistola]

if (mysql_num_rows($query) < 1) {
echo "No records returned";
}