array problem

[chieh]

I used session to pass array value as follow

$query="select uid, sid from usertable";
$result=mysql_query($query,$db_link);
$data=mysql_fetch_array($result);

$_SESSION['DATA']=$data;

in next page I call this value
but it only show first record.

code as following

session_start();
$data=$_SESSION['DATA'];

I want to show 10 records.

for ($i=0;$i<10;$i++)

{ echo $data[0].$data[1];}

but it always show first record

pls tell me where is wrong?

[bubblenut]

You have only pulled the first record out of the database. [man]mysql_fetch_array[/man] should explain where you're going wrong with it.
If you cannot figure out the problem from there, post back and I'll help out.
Bubble

[chieh]

From reading the function(mysql_fetch_array) I wrote code as following,

while($row=mysql_fetch_array($result)){
$data[$row[""]]=$row;
}

other was the same,

but I didn't get anything.

pls adv.