Es daru tā.
function settings()
{
$sql = 'SELECT `name`, `value` FROM `settings`';
$query = mysql_query($sql);
while($row = mysql_fetch_array($query)) {
$settings[$row['name']] = $row['value'];
}
return $settings;
}
settings();
$settings = settings();
echo $settings['site_name'];
CREATE TABLE IF NOT EXISTS settings (
`id` int(8) NOT NULL auto_increment,
`name` varchar(255) default NULL,
`value` varchar(255) default NULL,
PRIMARY KEY (`id`)
);
INSERT INTO settings VALUES
(1, 'site_name', 'dG\'s Bliss'),
(2, 'site_style', 'standard');
Nezinu vai pareizākais variants. Palabojiet mani, ja nepieciešams. :D