Dynamically create associative array.

Hi,

Can anyone help with this code ?

$sql = "SELECT max(DrinkOrder) AS DrinkOrder, DrinkType FROM DrinkTable "
. "GROUP BY DrinkType";

$result = mysql_query($sql);

while ($myrow = mysql_fetch_array($result)) {
$highest[$myrow["DrinkType"]] = $myrow["DrinkOrder"];
}

I'm trying to create the associative array $highest dynamically using the results from the sql query.

This code gives me an error relating to the single line inside the while loop:

Parse error: parse error, unexpected T_VARIABLE

You have nested your square brackets:

while ($myrow = mysql_fetch_array($result)) {
$highest[$myrow["DrinkType"]] = $myrow["DrinkOrder"];
}

try (also, I always use ' instead of " for no particular reason):

$highest[$myrow]['DrinkType'] = $myrow['DrinkOrder'];

HTH

rinjani

No that's definetly not right Rinjani, tried it anyways just in case but no go.

It's not a 2D array I'm trying to create as you are suggesting.

Any other takers??

Hi,
why don't try to split in two instruction?

$appo=$myrow["DrinkType"];
$highest[$appo] = $myrow["DrinkOrder"];

or use mysql_fetch_row() instead of mysql_fetch_array().

See you.

Try to get
a look at this thread

may be helpfull.

Else try to post more info.