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?

[Captain Nemo]

Panic over!

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

[Virgil Green]

"Captain Nemo" <Captain@NoSpam.com> wrote in message
news:CaU7d.1716$xb.1032@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);
>

eval (as you mentioned in your followup) is not needed either. Simply use:

$arr[$code]=$price;

by using eval, you appear to be attempting to force the subscript to be a
literal value and that isn't necessary.

- Virgil