Originally Posted by rb290

I get this:

Invalid SQL:

SELECT user.usergroupid as usergroupid, userfield.userid, userfield. as pageron
FROM userfield LEFT JOIN user ON (user.userid = userfield.userid)
WHERE userfield.userid = 1 AND user.usergroupid NOT IN (1,3,8);

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 'as pageron
FROM userfield LEFT JOIN user ON (user.userid = u
Error Number : 1064
Date : Monday, November 21st 2005 @ 06:02:34 PM
Script : http://thugonline.net/sms.php?do=sms&userid=1
Referrer : http://thugonline.net/showthread.php?p=3387
IP Address : 69.156.38.253
Username : KILLA
Classname : vb_database

Originally Posted by mini2

You shouldn't replace the field_no variables. If you have any $field10 then change that BACK to $field_no. You only need to put the new variable in the sms.php at the top (field90 replace with field10). ONLY replace 90's with 10's, not the $field_no text itself.

Hope that makes sense.