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]
