the following assumes you've opened database. $query = "SELECT TextVal,Val1,Val2,Val3 FROM mytable WHERE some_condition"; $result = mysql_query($query) or die(mysql_error()); $mycmd = "\$data_array = array ("; while( $row = mysql_fetch_array($result) ) { $mycmd .= "array(\"".$row['TextVal']."\",".$row['Val1'].",".$row['Val2'].",".$row['Val 3']."),"; } $mycmd = substr($mycmd,0,-1).");"; print $mycmd; \\ sanity check...display $mycmd eval($mycmd); \\ execute the command. $data_array is created mysql_free_result($result);
-----Original Message----- From: Sommai Fongnamthip [mailto:[EMAIL PROTECTED]] Sent: Thursday, September 27, 2001 2:14 AM To: [EMAIL PROTECTED] Subject: [PHP-DB] create data array Hi, If I need to use data array like this $data_array = array ( array("text",1,2,3), array("text",4,5,6), array("text",7,8,9) ); all array element are contain in my database. How could I write PHP code to make this command on the fly? SF -- PHP Database 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 Database 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]