[RESOLVED] mysql table with configuration

[AsianGuyJTran]

Hi all

I have a script that I'm developing and I would like to have the configuration data [site name, ranking limit, etc ...] stored in a mysql table

How does one go about recalling values when needed?

I feel that having to do this over and over again is too much

$config_result = mysql_query("SELECT * FROM `phpTitanMS_config`");
$phpTitanMS_config = mysql_fetch_array($config_result);

Any ideas?

[NogDog]

In what respect do you consider that it "is too much"?

[AsianGuyJTran]

using the above code, i cannot get the value from the row

let's say i want to pull the value in the row whose config_name is site_name, i can't use $phpTitanMS_config['site_name']
how do i get the value of the row without having to include " WHERE config_name = 'foo' "

having to do that for every needed value seems to be overdoing it

[NogDog]

You could write the results into an array, something like:

$config_result = mysql_query("SELECT * FROM `phpTitanMS_config`");
$config = array();
while($row = mysql_fetch_assoc($config_result))
{
   $config[$row['config_name']] = $row;
}

// sample data access from config name "foo":
$site_name = $config['foo']['site_name'];

[Sxooter]

AsianGuyJTran wrote:

using the above code, i cannot get the value from the row

let's say i want to pull the value in the row whose config_name is site_name, i can't use $phpTitanMS_config['site_name']
how do i get the value of the row without having to include " WHERE config_name = 'foo' "

having to do that for every needed value seems to be overdoing it

How about something like:

select * from table where config_name in ('foo','bar','abc','xyz')

[AsianGuyJTran]

NogDog wrote:

You could write the results into an array, something like:

$config_result = mysql_query("SELECT * FROM `phpTitanMS_config`");
$config = array();
while($row = mysql_fetch_assoc($config_result))
{
   $config[$row['config_name']] = $row;
}

// sample data access from config name "foo":
$site_name = $config['foo']['site_name'];

this worked out

i had to modify

$config[$row['config_name']] = $row;

to

$phpTitanMS_config[$row['config_name']] = $row['config_value'];

so that the array would be

Array ( [site_name] => YOUR NAME HERE [ranking_limit] => 5 [ranking_sort] => exp [TitanMS_host] => 127.0.0.1 [TitanMS_port] => 8484 )

thanks!