SQL syntax error- HELP.

[Jadelit]

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]

hmm...that doesn't give much information :rolleyes:

[Scott MacVicar]

change code to

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

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