View Single Post
  #14  
Old 07 Feb 2015, 14:01
kh99 kh99 is offline
 
Join Date: Aug 2009
Real name: Kevin
Originally Posted by giaguaro View Post
lol as i told you i am definitely a beginner and have a poor english.

Now:
UPDATE user SET usergroupid=eliminare WHERE usergroupid=3 AND email LIKE %sina.com%

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 '%sina.com%' at line 1

what happened?
Sorry, that's my fault. You need that in quotes, like:

Block Disabled:      (Update License Status)  
Suspended or Unlicensed Members Cannot View Code.

But also, you can't have 'eliminare' there, because the usergroupid must be a number.
Reply With Quote