note 14091 rejected and deleted from function.mysql-fetch-array.php by zak

array mysql_fetch_array (resource result [, int result_type]) Say I am using this below. mysql_connect ($host, $user, $password); $result = mysql_db_query ("database","select user_id, fullname from table"); while ($row = mysql_fetch_array ($result)) { echo "user_id: ".$row["user_id"]."<br>n"; } If $results is and array and it has 100 records I sould be able to pull out record 52 $z= 52 and then get the next 10 records after that using $z as a key starting point in the array right. I am looking to have a database display 10 records at a time without using an "IF Statement" to check if the record is between 52 and 62. That would take forever if I had 100,000 records. Any ideas..?