I have tried to enter a query yet all I get is:-
You have to choose at least one column to display
How to I combat this?
The quewry I am trying to run is:- UPDATE mybb_users SET usergroup=4 WHERE uid='Verso'
Verso Wrote:The quewry I am trying to run is:- UPDATE mybb_users SET usergroup=4 WHERE uid='Verso'
uid= your user ID. So, on your forums, when you go to your profile, what is the number that appears at the end of the URL?
For example, if we were to use these forums your uid would be 14209 because:
http://community.mybboard.net/member.php...&uid=14209
See?
rh1n0 Wrote:Verso Wrote:The quewry I am trying to run is:- UPDATE mybb_users SET usergroup=4 WHERE uid='Verso'
uid= your user ID. So, on your forums, when you go to your profile, what is the number that appears at the end of the URL?
For example, if we were to use these forums your uid would be 14209 because:
http://community.mybboard.net/member.php...&uid=14209
See?
My userID is 85 and I entered that in the uid bit yet I'm still getting:- You have to choose at least one column to display
UPDATE mybb_users SET usergroup=4 WHERE uid='85'
I have now managed to sort this. Thank you all whoever has helped......
When i run
UPDATE`mybb_threads`SET`icon` ='X' WHERE`icon` ='';
I get this error..
MySQL returned an empty result set (i.e. zero rows). (Query took 0.0004 sec)
.
.
Can you help me.?
^ you can change that query to below and try (X should be replaced with actual number of the icon)
UPDATE `mybb_threads` SET `icon` = 'X' WHERE `icon` = '0';