PHP Code:

$query = " SELECT *
FROM `member`
ORDER BY `id` DESC";
$recs_per_page = 6; //2 records will be shown per page
              
              $no_recs = mysql_num_rows($query) or die(mysql_error()); 


Does anyone see anything wrong with that code?

$result = mysql_query($query);

$no_recs = mysql_num_rows($result);

XD oooops, durr. Thank you.

select count(*) from table to get the total number of records. selecting * just to get the number of records will work slower and slower as the records are added and one day you will fail with out of memory error