Re: How to replace define in a require file with mysql?

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