[RESOLVED] array

[vang]

hi,
i run an sql and get this result in array format:

Array ( [0] => Array ( [field] => item_code ) [1] => Array ( [field] => item_name ))

i need to use these array values for use in another sql statement, how can i do this?

eg.

 "SELECT item_code, item_name FROM table";

[niroshan]

Hi Vang,
Hope this will help,

$aa[0]['field'] = 'item_code';
$aa[1]['field'] = 'item_name';

while(list($key, $val) = each($aa))
{
	$fields[] = $val['field'];
}

$query = "SELECT ".implode(', ', $fields)." FROM TABLE";

echo $query;

Thanks,
Regards,
Niroshan

[Weedpacket]

Although, if you're getting data out of the database just to use it in another database query, then chances are you're doing something that could be done entirely in a single database command.

[vang]

Dear Niroshan,
thank you so much 🙂