The Arcive of vBulletin Modifications Site.

SQL syntax error- HELP. · **Released**: 06-08-2002

Database error in vBulletin 2.2.6:

Invalid SQL: SELECT COUNT(threadid) AS total FROM thread WHERE postuserid=
mysql error: You have an error in your SQL syntax near '' at line 1

mysql error number: 1064

Date: Saturday 08th of June 2002 10:01:52 AM
Script: http://www.******.com/showthread.php?s=&threadid=1671
Referer:

scsa20 · #2 06-09-2002, 05:08 AM

hmm...that doesn't give much information

Scott MacVicar · #3 06-09-2002, 05:24 AM

change code to

Code:

SELECT COUNT(threadid) AS total FROM thread WHERE postuserid='$variable'

change $variable of course and its the quotes around it you need to add.