Check records in table-empty?

[james_cwy]

I am using this to get a record from table and display:

while (list($N, $P,$S1,$S2,$S3,$IP ) = mysql_fetch_row($getmembers))
{
//display data.
}

If there are records, it will display but if there are no records, it will just show that page.
I do not want that.
I want it to check whether the table is empty first, If yes, it will just display a msg and if not then it will only display whatever records.
I am unsure how to check using this way.

Hope someone can just help. What should I type?
I am really new at this.
Thanks

[lig]

why not do a mysql_num_rows first and as long as it's greater then 0 show the page.

So your code would be inside of an:

if ((mysql_num_rows($result)) > 0)
{
while (list($N, $P,$S1,$S2,$S3,$IP ) = mysql_fetch_row($getmembers))
{
//display data.
}
}
else
{
//display your alternate page
}