View Single Post
  #43  
Old 01-23-2007, 06:46 AM
mac27's Avatar
mac27 mac27 is offline
Member
 
Join Date: Aug 2006
Posts: 84
GeekMart License Holder 
Default

I tried this and it threw up a dB error on me. Any ideas from anyone?


Invalid SQL:
SELECT t.title, t.views, t.replycount, t.threadid FROM thread t WHERE t.visible=1 AND t.forumid in (-146,47,48,) AND t.postuserid = 1 ORDER BY t.dateline DESC LIMIT 5;

MySQL Error : You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near ') AND t.postuserid = 1 ORDER BY t.dateline DESC LIMIT 5' at line 1
Error Number : 1064

Last edited by mac27; 01-23-2007 at 06:50 AM..
Reply With Quote