Oops.. my bad
$quarterbacks[$data['NAME']][$key] = $value;
Mike
Mike Eheler wrote:
> $result = mysql_query("select NAME,ATTEMPTS,COMPLETIONS,YARDS,TD,INT
> from players where pos = 'QB'");
> // or whatever it takes to get just qb's
> while ($data = mysql_fetch_array($result)) {
> foreach ($data as $key => $value) {
> // I've noticed that $data stores numeric and text keys, this
> filters the numeric ones
> if (!is_numeric($key)) {
> $quarterbacks[$name][$key] = $value;
> }
> }
> }
>
> That's how I'd do it.. a little extra work, but it keeps only the data
> you want on hand.
>
> It's also a good idea to store the name so you can reference later if
> you want to spew forth all the qbs..
>
> Mike
>
> J. Roberts wrote:
>
>> 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]
