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

2007. 11. 5, hétfő keltezéssel 06.10-kor Ronald Wiplinger ezt írta: > 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 try something like this sql: SELECT param_name, IF ((param_value1 <> '') AND NOT ISNULL(param_value1), param_value1, param_value2) AS param_value FROM yourTable greets Zoltán Németh > > How can I add this? > > Thank you again. > > bye > > Ronald >