UBB.Dev
Posted By: BWilliams_dup1 MYSQL Error - 05/12/2004 8:44 PM
SCRIPT: /ubbthreads/admin/showusers.php

Unable to do_query: SELECT U_Username,U_Number,U_Registered,U_Totalposts,U_Laston,U_Email,U_RegEmail,U_Status,U_Title,U_LoginName FROM w3t_Users WHERE U_Number <> 1 AND U_Number <> 2 AND U_Approved = 'yes' U_Status = 'User' ORDER BY U_Username - 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 'U_Status = 'User' ORDER BY U_Username' at line 6
Posted By: scroungr Re: MYSQL Error - 05/12/2004 8:46 PM
[]Approved = 'yes' U_Status = 'User' [/] missing the word AND

Approved = 'yes' AND U_Status = 'User'
Posted By: BWilliams_dup1 Re: MYSQL Error - 05/12/2004 10:59 PM
[]scroungr said:
[]Approved = 'yes' U_Status = 'User' [/] missing the word AND

Approved = 'yes' AND U_Status = 'User' [/]
Next question.

What would have cause this error?
Posted By: scroungr Re: MYSQL Error - 05/12/2004 11:59 PM
did you do a mod to showuser.php? cause as far as I can see with mine it really can't be caused. is it a stock or a modded showuer.php?
© UBB.Developers