$result = mysql_query( "SELECT pkgid FROM plans"); while($row = mysql_fetch_assoc($result)) { $package = mysql_fetch_assoc(mysql_query( "SELECT * FROM plans WHERE pkgid='$row[pkgid]'")); } obviously this will have
$package = array("key" => "value", ...); are you wanting to have the above be referanced by the pkgid ? Jim Lucas bend.com ----- Original Message ----- From: <[EMAIL PROTECTED]> To: <[EMAIL PROTECTED]> Sent: Monday, January 21, 2002 2:51 PM Subject: [PHP] 2d array help > arg- trying to get the data that I pull outta my db into a 2d assoc array... > > any help? > > ~kurth > > $result = mysql_query( "SELECT pkgid FROM plans"); > while($row = mysql_fetch_assoc($result)){ > $resultpkg = mysql_query( "SELECT * FROM plans WHERE > pkgid='$row[pkgid]'"); > $package = mysql_fetch_assoc($resultpkg); > } > > print_r($plan); > > > -- > 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]