key value array

nikko50

Hello all.
How can I place the below SELECT statement in a key/value array. I need the key to start at 1 and continue to count so it shows..
1->200032
2->343432
3->3232131

$get="select c.orderid from orders where charged IS NULL ORDER BY orders.enterdate";
$getresult=mysql_query($get, $link);
$getline=mysql_fetch_array($getresult, MYSQL_ASSOC) ;

bodzan

...like:

while(list($key,$value)=each($arrayName)){
//do something with $key and $value of each element of an array
}

laserlight

You could try something along the lines of:

$query = "SELECT c.orderid
	FROM orders
	WHERE charged IS NULL
	ORDER BY orders.enterdate";
$result = mysql_query($query, $link);
$array = array();
for ($i = 1; $row = mysql_fetch_array($result); $i++) {
	$array[$i] = $row['c.orderid'];
}