RE: [PHP] Generating populated variables from component/content pairs in a database

[Rick Emery]

$sql = "SELECT * FROM $table_name
        WHERE sec = '$sec' AND
        WHERE subsec = '$subsec' AND
        WHERE name = '$name'
        ORDER BY component
        ";

$result = mysql_query($sql) or die("Error: ".mysql_error()."$sql<BR>");
while ( link($component,$content) = mysql_fetch_array($result) )
{
        ...do stuff...
}

The filed values will be in the $component and $content.

-----Original Message-----
From: James Hallam [mailto:[EMAIL PROTECTED]]
Sent: Friday, February 01, 2002 3:07 PM
To: [EMAIL PROTECTED]
Subject: [PHP] Generating populated variables from component/content
pairs in a database


I've got a fairly basic website content management system I'm working on,
and I've got the data split up in MySQL by the following: a few columns for
identifiers like language, section and unique keyname, a column for a
component name and a column for the relevant content for that component.  As
follows:

====================================
|  component  |       content      |
------------------------------------
|     foo     |       123456       |
------------------------------------
|     bar     |       654321       |
------------------------------------

Assuming I've got the right sql statement here (it just looks for the rows
that match the section and subsection provided earlier in the script):

$sql = "SELECT FROM $table_name
        WHERE sec = '$sec' AND
        WHERE subsec = '$subsec' AND
        WHERE name = '$name'
        ORDER BY component
        ";

What can I do to end up with a variable for each component/content pair,
with the variable named with the value of the component, and assigned the
value of the content?:

$foo = 123456;
$bar = 654321;

Is there a simple way to do this?

Thanks,

James Hallam


-- 
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]