This should be easy, but...

[Captain Nemo]

Hi

I'm trying to build a simple, one-dimensional array of prices, where the key
to each element is the product code.

So I start by executing a select query "SELECT Code, Price FROM Products",
and the results are returned in a two-dimensional array, $data, which I can
loop through like this:

while (list(, $value) = each($data))
{
$code = $value[0];
$price = $value[1];

I would have thought I could build my array here by writing something like:

$command = "\$arr['$code'] = $price;";
exec($command);

But this doesn't work.

Can anyone explain?

[iuz]

Captain Nemo wrote:

Hi

I'm trying to build a simple, one-dimensional array of prices, where the
key to each element is the product code.

So I start by executing a select query "SELECT Code, Price FROM Products",
and the results are returned in a two-dimensional array, $data, which I
can loop through like this:

while (list(, $value) = each($data))
{
$code = $value[0];
$price = $value[1];

I would have thought I could build my array here by writing something
like:

$command = "\$arr['$code'] = $price;";
exec($command);

But this doesn't work.

Can anyone explain?

there are some errors in your code..
if you want an array like this
array(
'code' => 'price'
)
you can do something like this..

while(list($cod e, $value) = mysql_fetch_arr ay($data))
$product[$code] = $value;

--
www.iuz-lab.info

[Captain Nemo]

Panic over!

I was confusing the exec() function with the eval() function.

[Brad Kent]

while (list(, $value) = each($data))
{
$code = $value[0];
$price = $value[1];
/*
$command = "\$arr['$code'] = $price;"; // I belive you
// need \ before all $s
exec($command); // you want eval() here
*/
// wouldn't this be a bit more concise:
$arr[$code] = $price; // why all the command and eval hubbaabaloo?
}

or how about this:
foreach ( $data as $values )
{
$arr[$values[0]] = $values[1];
// or if you used mysql_fetch_ass oc or mysql_fetch_arr ay:
// $arr[$values['Code']] = $values['Price'];
}


"Captain Nemo" <Ca*****@NoSpam .com> wrote in message news:<Hj******* *********@text. news.blueyonder .co.uk>...

Hi

I'm trying to build a simple, one-dimensional array of prices, where the key
to each element is the product code.

So I start by executing a select query "SELECT Code, Price FROM Products",
and the results are returned in a two-dimensional array, $data, which I can
loop through like this:

while (list(, $value) = each($data))
{
$code = $value[0];
$price = $value[1];

I would have thought I could build my array here by writing something like:

$command = "\$arr['$code'] = $price;";
exec($command);

But this doesn't work.

Can anyone explain?