使用分页输出数组

Question

this is my code

//select all the members id
$result = mysql_query("select id from member");

//create array of ids
$id = array();

// page is the number of my pagination numbering and its from 1 to 10
$dis = $page;// for example $page = 1

// $page get its value every time a user click my pagination numbering i.e $page = $_GET[page]; 
// guess you understand

while($u_id = mysql_fetch_assoc($result)){
    //id is my field name
    $id[] = $u_id[id];
}

echo $id[$dis];

my problem is that this above code works for only 4 records out of 10records. my question is, why is it not working outputin other ids when the array index is 4,5... and howw do i amke it work

secondly the echo part is just the test of my idea but what i wanted to do is to pass the return id to a function for query. please any help

Answer 1

Well not sure if this is your problem but you might want to correct this if its not just a type in your post:

while($u_id = mysql_fetch_assoc($result)){
$id[] = $u_id['id']; // this should be 'id' not $id
}