[RESOLVED] Fetch Troubles

[nawrik]

All,

I'm getting struggling with this one, as usual any help appreciated!

The Problem:

I'm building a basic CMS.

There is a table called 'options' - this simply contains the basic site settings such as site_name, site_strapline, foote_text etc...

It is set up like this:

id | option_name | option_value

1 | site_name | Amazon

2 | site_strapline | Electronics Shop

I'm trying to pull all of the data from the 'option_value' column and store into a variable called $loadoptions.

Ultimately I want to be able to call the variable:

$loadoptions['site_name'] 

using the 'option_name' to select the correct value.

Any ideas?

I've tried all sorts of fetch_rows/array combo's and just keep going wrong.

Thank you in advance!

[niroshan]

Hi nawrik,

$sql = "SELECT option_name, option_value FROM options";
$row = mysql_query($sql);
while($data = mysql_fetch_array($row))
{
	$loadoptions[$data['option_name']] = $data['option_value'];
}

Regards,
niroshan

[nawrik]

Niroshan,

thank you for your swift response.

Works a treat.

It's amazing how simple it is when you know how it's done! 😉