The Arcive of Official vBulletin Modifications Site.It is not a VB3 engine, just a parsed copy! |
|
#1
|
||||
|
||||
Easy Database Query Question
Hey all,
This is self explanatory I guess. Can someone please fix this for me?? I know I am messing up with the Where clause... HTML Code:
SELECT * FROM userfield AS userfield LEFT JOIN user AS user ON (user.userid = userfield.userid) WHERE user.usergroupid = 15 AND user.userfield = 19, 20, 7, 12, 13, 18, 14, 15, 16, 17, webdevoman --------------- Added 07 Sep 2009 at 23:12 --------------- I think I have it-- Is this it?? PHP Code:
Error SELECT * FROM userfield AS userfield LEFT JOIN user AS user ON ( user.userid = userfield.userid ) WHERE user.usergroupid =15 AND user.userfield = '19' AND '20' AND '7' AND '12' AND '13' AND '14' AND '15' AND '16' AND '17' AND '18', LIMIT 0 , 30 MySQL said: #1064 - 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 ' LIMIT 0, 30' at line 4 |
|
|
X vBulletin 3.8.12 by vBS Debug Information | |
---|---|
|
|
More Information | |
Template Usage:
Phrase Groups Available:
|
Included Files:
Hooks Called:
|