I am getting a weird error on one of my servers that says something about "query requires full tablescan". I was not getting this error until today that I noticed. I Googled for a minute and saw where a ton of other sites had the same problem but no "reason" why. I did find one board that said to turn off "mysql.trace_mode" in the php.ini file. I did this and it fixed the problem. Is there something different that I should be doing when I write code? Have I just "band aided" the problem or solved the problem? thanks, Doug -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php