you could also do this ...
$data = mysql_fetch_assoc($res); //this is a nice function because it
returns an associative array. so
// if you change your SQL db, you
wouldn't need to change your php code
// as much.
$quarterbacks[$name]= $data;
jim
>Something like this?
>
>while( list( $name, $attempts, $completions, $yards, $td, $int ) =
>mysql_fetch_row($res) )
>{
> $quarterbacks[$name] = array( "ATTEMPTS" => $attempts,
> "COMPLETIONS" =>
>$completions,
> "YARDS" => $yards,
> "TD" => $td,
> "INT" => $int );
>}
>
>echo $quarterbacks["GARCIA"]["YARDS"];
>
>Jason Lotito
>[EMAIL PROTECTED]
>www.NewbieNetwork.net
>
>> -----Original Message-----
>> From: J. Roberts [mailto:[EMAIL PROTECTED]]
>> Sent: Thursday, December 06, 2001 4:08 PM
>> To: [EMAIL PROTECTED]
>> Subject: [PHP] Creating multidimensional array dynamically
>>
>>
>> I can't seem to figure out how to create a multidimensional
>> array from a database query. Here is an example of what I
>> was looking for, using NFL quarterbacks as a statistical
>> foundation... A record contains the following fields:
>>
>> NAME, ATTEMPTS, COMPLETIONS, YARDS, TD, INT
>>
>> Now I would like to be able to create an array with NAME as a
>> key containing the array(ATTEMPTS, COMPLETIONS, YARDS, TD, INT).
>>
>> That way I would be able to do the following:
>>
>> echo $quarterbacks["GARCIA"]["YARDS"];
>>
>> and get the output of 3,100 or whatever the case may be.
>>
>> Thanks,
>> -Jamison.
>>
>>
>>
>> --
>> PHP General Mailing List (http://www.php.net/)
>> To unsubscribe, e-mail: [EMAIL PROTECTED]
>> For additional commands, e-mail:
>> [EMAIL PROTECTED] To contact the list
>> administrators, e-mail: [EMAIL PROTECTED]
>>
>
>
>--
>PHP General Mailing List (http://www.php.net/)
>To unsubscribe, e-mail: [EMAIL PROTECTED]
>For additional commands, e-mail: [EMAIL PROTECTED]
>To contact the list administrators, e-mail: [EMAIL PROTECTED]
--
Jim Musil
---------
Multimedia Programmer
Nettmedia
-------------
212-629-0004
[EMAIL PROTECTED]
--
PHP General Mailing List (http://www.php.net/)
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
To contact the list administrators, e-mail: [EMAIL PROTECTED]
