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]

Reply via email to