saving into array

[sanu]

can i save database data into array this way ...actually this is not working so is there anyway please suggest me

function list_user(){
$myDB = db_connect();
$query_user=mysql_query("Select * FROM user_list ");
    while($rowuser=mysql_fetch_array($query_user)){
	$userlist=array('uid'=>$rowuser[0],'username'=>$rowuser[1]);
		}
return $userlist;

and called it this way
its only return one value

$ulist=list_user();
//while(list($username)=each($ulist)){
for($i=0;$i<=count($ulist);$i++){
print($ulist['username']);
}

[ednark]

you are writing overtop of the same variable $userlist again and again

to append the item to an array you say $var_name[] <--- the empty brackets do the trick

while($rowuser=mysql_fetch_array($query_user)){

$userlist=array('uid'=>$rowuser[0],'username'=>$rowuser[1]);

}

i think you want more like:

$userlist = array()
while($rowuser=mysql_fetch_array($query_user)){

$userlist[]=array('uid'=>$rowuser[0],'username'=>$rowuser[1]);

}

[sanu]

THANKS ednark

function list_user(){
$myDB = db_connect();
$userlist = array();
$query_user=mysql_query("Select * FROM user_list ");
    while($rowuser=mysql_fetch_array($query_user)){
    $userlist[]=array('uid'=>$rowuser[0],'username'=>$rowuser[1]);
        }
return ($userlist);
}
?>

AND I CALLED IT THIS WAY

$ulist=list_user();
while(list(,$uname)=each($ulist)){
print("".$uname['uid']."<BR>");
}