Re: [PHP] 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. >> >> >> > > > -- 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]
Re: [PHP] Creating multidimensional array dynamically
$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]
RE: [PHP] Creating multidimensional array dynamically
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]
Re: [PHP] Creating multidimensional array dynamically
Not sure what you are trying to do, but try using mysql_fetch_row () you can use SQL to limit your results. /dkm - Original Message - From: "J. Roberts" <[EMAIL PROTECTED]> To: <[EMAIL PROTECTED]> Sent: Thursday, December 06, 2001 4:08 PM 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]
RE: [PHP] Creating multidimensional array dynamically
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]