RE: [PHP-DB] MySQL error...

No... That is just some strange error generated by the cut and paste. The "IS NOT NU LL" that is... The other issue with 'tablename'... I simply typed 'tablename' in the e-mail because I didn't remember the exact tablename when I was typing the e-mail. It does actually provide the name of the table that the script is working with. Thanks for the feedback. Scott Nipp Phone: (214) 858-1289 E-mail: sn4265@sbc.com Web: http:\\ldsa.sbcld.sbc.com -----Original Message----- From: Norland, Martin [mailto:Martin.Norland@STJUDE.ORG] Sent: Friday, December 10, 2004 2:34 PM To: php-db@lists.php.net Subject: RE: [PHP-DB] MySQL error... > -----Original Message----- > From: NIPP, SCOTT V (SBCSI) [mailto:sn4265@sbc.com] > I have been using a PHP page to update a database table for a long time now. > Unfortunately, I have noticed that frequently when I perform an update I get back an error > saying "Table 'tablename' doesn't exist". This is becoming more and more annoying. [snip] > $query = "SELECT id_sys, atime, gid, shell FROM accounts > WHERE atime IS NOT NU LL AND ctime > IS NULL ORDER BY rtime ASC"; $result = mysql_query($query, $Prod) or die(mysql_error()); ?> <snip> Strange behavior, can't say I've ever heard of/seen it - however... "IS NOT NU LL" is not, strictly speaking, valid sql. If that's not just a weird line wrapping issue - that may point to part of your problem. If the error you're getting back is literally "Table 'tablename' doesn't exist" - then you're looking in the wrong code, and somewhere you have code that says "tablename" instead of "$tablename". You may want to grep for "tablename" to try to track that down. Cheers, - Martin Norland, Database / Web Developer, International Outreach x3257 The opinion(s) contained within this email do not necessarily represent those of St. Jude Children's Research Hospital. -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php