Re: Creating multidimensional array dynamically

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.