[SOLVED] Efficent way of grabbing SQL entries

[Cross89]

Hello,

 

I'm building a blog software for giggles, and I have a table in my database that stores configuration information in a manner such as this:

 

id    option_name    option_value

1      site_title          My Blog Site

2      site_slogan      Its a blog site; didn't you know?

3      admin_email    admin@email.com

 

etc.

 

What I want to do is have a SQL query run when a page is loaded that takes this information and implements it on the page - so the header is populated with the title and slogan, etc.

 

What I am having trouble with is trying to do this with one query. It'd be very taxing to have to run 20 queries before the page is even rendered. So does anyone know how I can easily access the information so it can be deployed easily across pages?

 

I hope this is enough information.

 

Thanks,

Matt

[Alex]

Something like this should do (Just make sure you replace the table name with your own):

 

$result = mysql_query("SELECT option_name, option_value FROM table");
while($row = mysql_fetch_assoc($result))
{
     $config[$row['option_name']] = $row['option_value'];
}

 

You can then access your configuration details in the associative array $config like such: $config['site_title'], $config['site_slogan'], etc..

[Cross89]

Oh I feel so stupid now, haha. I guess I had a coder's block or something!

 

Thanks a lot for the help.