$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]
