HELP ME PLEASEE!!!!
Code:
Database error in vBulletin 3.8.0:
Invalid SQL:
SELECT user.*, COUNT(video.videoid) AS videocount
FROM video AS video
LEFT JOIN user AS user ON(user.userid = video.userid)
WHERE NOT ISNULL(user.userid)
GROUP BY video.userid
ORDER BY videocount DESC
LIMIT a;
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 'a' at line 7
Error Number : 1064
Request Date : Friday, January 23rd 2009 @ 11:07:26 PM
Error Date : Friday, January 23rd 2009 @ 11:07:26 PM
Script : http://www.xxxx.com/forum/video.php
Referrer : http://www.xxxx.com/forum/index.php
IP Address : 88.xxx.xxx.134
Username : kapwanero
Classname : vB_Database
MySQL Version : 5.0.58