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: [EMAIL PROTECTED]
Web: http:\\ldsa.sbcld.sbc.com
-----Original Message-----
From: Norland, Martin [mailto:[EMAIL PROTECTED]
Sent: Friday, December 10, 2004 2:34 PM
To: [EMAIL PROTECTED]
Subject: RE: [PHP-DB] MySQL error...
> -----Original Message-----
> From: NIPP, SCOTT V (SBCSI) [mailto:[EMAIL PROTECTED]
> 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
--
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php
