www.webdeveloper.com
Results 1 to 3 of 3

Thread: weird SQL error

  1. #1
    Join Date
    Jul 2005
    Posts
    49

    weird SQL error

    Code:
    select count(postuserid) as thre from thread join `pppuninstall` as UT where dateline >= UT.install AND dateline <= UT.uninstall AND visible=1 and dateline<=222147483647 and firstpostid<>0 and postuserid=1 and dateline>=(select prev_dateline from user where userid=1);;
    
    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 'select prev_dateline from user where userid=1)' at line 1
    Error Number : 1064
    i get this error when query is done on the website, but the sql runs without error on phpmyadmin
    userid is primary key

    am counting postuserid between install and uninstall times!

  2. #2
    Join Date
    Aug 2005
    Location
    The Garden State
    Posts
    5,634
    you have 2 semi-colons?
    Acceptable Use | SQL Forum FAQ | celery is tasteless | twitter

    celery is tasteless - currently needing some UI time

  3. #3
    Join Date
    Jul 2005
    Posts
    49
    i dun think semi colon is the error creator

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  
HTML5 Development Center



Recent Articles