help get error when....

i get this error when i try to change a users post count


Database error in vBulletin Control Panel 2.2.6:

Invalid SQL: SELECT userid
FROM user
WHERE username='Wolf Claw'
AND userid <>
mysql error: You have an error in your SQL syntax near '' at line 4

mysql error number: 1064

Date: Saturday 13th of July 2002 10:29:02 AM
Script: http://www.straightgaming.com/vbulle...admin/user.php
Referer: http://www.straightgaming.com/vbulle...edit&userid=10

[FWC]

See if you have the following line in your admin/user.php file:

PHP Code:

  $user=$DB_site->query_first("SELECT *,FROM_UNIXTIME(joindate) AS 

If you do, change it to:

PHP Code:

  $user=$DB_site->query_first("SELECT user.*,FROM_UNIXTIME(joindate) AS 

That might help.

[Troy J.]

thx that worked

[FWC]

You're welcome.

[Boofo]

Boy, does that code ever look familiar! I might be easier to do a prepared message for this one, FWC.

Originally posted by FWC
See if you have the following line in your admin/user.php file:

PHP Code:

  $user=$DB_site->query_first("SELECT *,FROM_UNIXTIME(joindate) AS 

If you do, change it to:

PHP Code:

  $user=$DB_site->query_first("SELECT user.*,FROM_UNIXTIME(joindate) AS 

That might help.

[FWC]

Originally posted by Boofo
Boy, does that code ever look familiar! I might be easier to do a prepared message for this one, FWC.

Yeah, there a few errors that keep popping up a lot since PHP 4.2.1 came out.