Creating an array from a database

[gevensen]

I have a array for example:

$item = array(
"Great <em>Bittern</em>"=>"Botaurus stellaris",
"Little <em>Grebe</em>"=>"Tachybaptus ruficollis",
"Black-necked Grebe"=>"Podiceps nigricollis");

 

which will output

 Array ( [Great Bittern] => Botaurus stellaris [Little Grebe] => Tachybaptus ruficollis [black-necked Grebe] => Podiceps nigricollis ) 

 

how can I input data from a database so it comes out as the array assuming I have $row[3] and $row[0] as the data?

 

for example

 

while($row=mysql_fetch_array($result)){
//$item.=array($row[3],$row[0]); 
//array_push($item,array($row[3]=>$row[0]));
//$item.=array($row[3]=>$row[0]);
$item.="[".$row[3]."]=>".$row[0];
}

 

which of course doesnt work??

 

[gevensen]

found my own answer

 

$lista=array();
$listb=array();
while($row=mysql_fetch_array($result)){
array_push($lista,$row[3]);
array_push($listb,$row[0]);

}

$c = array_combine($lista, $listb);