Posted on: 11/11/02 11:48pm
By: ScottMcW
I'm getting this error when I try to look at submitted stories:
1064: You have an error in your SQL syntax near 'where ID=1036780369' at line 1
This is happening on moderation.php. The error log shows this message:
Tue Nov 12 01:40:39 2002 - 1064: You have an error in your SQL syntax near 'where ID=1036780369' at line 1 SQL in question: SELECT Category FROM where ID=1036780369
which looks to ME like it's missing the "FROM" info.
Looking through moderation.php I think that this is the pertinent code:
$sql = "SELECT sid AS id,title,UNIX_TIMESTAMP(date) AS day,tid FROM {$_TABLES['storysubmission']} ORDER BY date ASC";
Which looks like it has the "FROM" info {$_TABLES['storysubmission']}.
Any ideas?
Thanks!
Scott