two dimensional arrays from mysql query

Anon

I was wondering if there was a simple way to create a two dimensional array from a mysql query.

I building an event calendar and thought the best way was to create a two dimensional array of all the events for each month and then as I build the calendar table check to see if the each day's date exists in the array then pull out the rest of the info on that date from the array.

At present I'm using:

while ($row = mysql_fetch_array($result)) {
$event_date = $row[event_date];
$events_array[$event_date][event_artist] = $row[artist];
$events_array[$event_date][event_venue] = $row[venue];
$events_array[$event_date][event_price] = $row[ticket_price];
}

to create the array

and

$cont = true;
if ($events_array) {
while ((list($date, $event_array) = each($events_array)) && ($cont)) {
if ($date == $link_date) {
$event_artist = $events_array[$date][event_artist];
$event_venue = $events_array[$date][event_venue];
$event_price = $events_array[$date][event_price];

echo " $event_artist\n\t";
echo " $event_venue\n\t";
echo " <a href=\"#\">£ $event_price</a>\n\t";
$cont = false;
}

}
reset($events_array);
}

to add the info to each table cell.

Thanx

Tony

Anon

hello anthony,

found this on php.net:

"The optional second argument result_type in mysql_fetch_array() is a constant and can take the following
values: MYSQL_ASSOC, MYSQL_NUM, and MYSQL_BOTH. This feature was added in PHP 3.0.7.
MYSQL_BOTH is the default for this argument.

                            By using MYSQL_BOTH, you'll get an array with both associative and number indices. Using
                            MYSQL_ASSOC, you only get associative indices (as mysql_fetch_assoc() works), using MYSQL_NUM,
                            you only get number indices (as mysql_fetch_row() works). 

                            For further details, see also mysql_fetch_row() and mysql_fetch_assoc(). "

hth
chris

Anon

but the query still only returns one dimensional arrays. All you effect with the second value is the indices.

Best

Tony