RE: [PHP] Generating populated variables from component/content pairs in a database
| From: | James Hallam | Date: | Fri, 01 Feb 2002 21:36:03 +0000 |
| Subject: | RE: [PHP] Generating populated variables from component/content pairs in a database | ||
| References: | 1 | Groups: | php.general |
| Request: | Send a blank email to php-general+get-83180@lists.php.net to get a copy of this message | ||
Thanks for your reply.. I guess I should have mentioned my platform:
iPlanet/NT.. The manual says that link() isn't available for Windows
users.. Is there another function I could use?
My second question concerns the .. do stuff here .. portion.. I'm not sure
what I'd actually put there. My goal is to have a variable for each
component/content pair, regardless of how many pairs there are returned by
the SQL statement, and then to have those variables available for display
later on in the page. Do you have any suggestions?
James
-----Original Message-----
From: Rick Emery [mailto:remery@excel.com]
Sent: Friday, February 01, 2002 2:18 PM
To: 'James Hallam'; php-general@lists.php.net
Subject: RE: [PHP] Generating populated variables from component/content
pairs in a database
$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:jhallam@dwl.net]
Sent: Friday, February 01, 2002 3:07 PM
To: php-general@lists.php.net
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: php-general-unsubscribe@lists.php.net
For additional commands, e-mail: php-general-help@lists.php.net
To contact the list administrators, e-mail: php-list-admin@lists.php.net
--
PHP General Mailing List (http://www.php.net/)
To unsubscribe, e-mail: php-general-unsubscribe@lists.php.net
For additional commands, e-mail: php-general-help@lists.php.net
To contact the list administrators, e-mail: php-list-admin@lists.php.net