Jim Lucas wrote:
> Ronald Wiplinger wrote:
>> I have a file linked with require into my program with statements like:
>>
>> define("_ADDRESS","Address");
>> define("_CITY","City");
>>
>> I would like to replace this with a mysql table with these two fields
>> (out of many other fields).
>>
>> How can I do that?
>>
>> bye
>>
>> Ronald
>>
> Well, if you have all the settings in a DB already, then what I would
> do is this.
>
> SELECT param_name, param_value FROM yourTable;
>
> then
>
> while ( list($name, $value) = mysql_fetch_row($results_handler) ) {
> define($name, $value);
> }
>
> put this in place of your existing defines and you should be good.
>
Thanks! Works fine!
I need now a modification for that.
Two values:
SELECT param_name, param_value1, param_value2 FROM yourTable;
IF param_value1 is empty, than it should use param_value2
How can I add this?
Thank you again.
bye
Ronald
--
PHP General Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php
