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]