how to fill this array?

[supersub]

Hi,

I am working with phplib and i am creating a form

$f = new form;

i added an element of type select. and for the choices i use an array like this

$c = array(array("label"=>"Markets","value"=>1),
array("label"=>"Highlights","value"=>2),
array("label"=>"Our Services","value"=>3),
array("label"=>"Careers","value"=>4),
array("label"=>"about us","value"=>5),
array("label"=>"contact","value"=>6)) ;

$f->add_element(array("name"=>"wichChild",
"type"=>"select",
"options"=>$c,
"value"=>$navMenber->getChildrenID()
));

thing is , i want fill the array from a recordset

$query = sprintf("SELECT * FROM CRS_Children");

$q->query($query);

while($q->next_record()) {

and here i do not know how to fill that array??
}

Can somebody help me out here?

[dirkson]

Something like this should do the trick

$query = "SELECT label, value FROM CRS_Children"; 

$q = mysql_query($query); 
while(list($label, $value) = mysql_fetch_array($q))
{ 
$c[$label] = $value;
}