Using the select calc_found rows code (i.e select sql_calc_found_rows * from table where ... limit 0, 10) to get the found fesult irrespective of the limit clause...then using $count = mysql_query("select found_rows()"); with the hope of getting the returened result but got this instead: Resource id #7. what could be wrong? -- http://ngBot.com Nigeria's #1 website directory.