Retrieving settings from mysql

ganeshcp

Hi,
I'm making a script for which I've made a settings or configuration table with two fields: setting_name and setting_value.

These will contain fields like site name, email, flood control value, rules and respective values

I've made the table and inserted some default values in the installer.

Now I'm writing a admin script where one can change these default settings. How do I retrieve the values from the db? How do I change them?
Something tells me foreach will be used 😐
G

paulnaj

Have a look at the manual under mysql functions ... its very straghtforward.

ganeshcp

I'm afraid that didn't help!! 😐

the problem is i don't want to just output the tables but put them in form field so that that one can change them and update them in the mysql db.
G

paulnaj

I don't think you're going to have much luck getting help if you don't help yourself.

Ask specific questions and you'll get specific answers.

If you just want someone to do it for you, probably best to pay someone!

ganeshcp

Ok here is the problem in detail:

This is my table

setting_name | setting_value

moderation | on

flood control | 10

notification | 1

bgcolor1 | #000000

bgcolor2 | #000000

Now what I want to do is put the values of this table in respective text fields in a form so that someone can change them and then update them into the SQL db.

I don't know how to get the settingnames and their respective values in an array or something like that so that I can use it and modify it.

rheroux

Read the following:

mysql_connect

mysql_query

mysql_fetch_array