How to run SQL Queries using phpMyAdmin

[Verso]

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'

[Ryan Loos]

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?

[Verso]

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'

[Verso]

I have now managed to sort this. Thank you all whoever has helped......