Re: mysql/php query problem really bugging me

David Robley <robleyd@paradise.net.nz> wrote on 08/06/2002 05:28:43 PM: > Well, you could try echoing $orderby, to see if the value is being passed > as you expect; odds are that you are being bitten by the register_globals > setting that has been mentioned here a bit lately. That was it. I discovered in php_info.php that it is looking for the php.ini in /usr/local/apache/conf, but it doesn't exist there, it is actually in /usr/local/lib. So I copied it to /usr/local/apache/conf, verified that register_globals is On, and now all is fine. Funny that this effected only one database access web page, and not the other four. Thanks for the reminder, -- Chip > Also, using mysql_error to see if there is a problem with the query > actually passed to mysql is a valuable debugging tool. > -- > David Robley