2 SQL Problems

[Renkia]

Need some help on these 1 SQLS. & Another problem. Sorry about the Title

[mysql]QUERY ERROR: Unknown column 'admin' in 'field list'

Query was UPDATE users SET admin=1 WHERE userid=2[/mysql]

[mysql]QUERY 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 '' at line 1

Query was UPDATE users SET admin=1 WHERE userid=[/mysql]

CODE LINE:

$db->query("DELETE FROM admin WHERE admin_userid={$_POST['userID']}");

 

If you could post these that would be great. 8o

Cheers, Rasheed :thumbsup:

[Zeggy]

Add a column to your users table called 'admin'?

[Magictallguy]

I presume you're using MC Codes. If so, then you want to change `admin` to `user_level`.

The second error I can't help with until I see the rest of that form code

[Djkanna]

[mysql]Query was UPDATE users SET admin=1 WHERE userid=[/mysql]

I'm going to assume $userid isn't there or isn't defined.

[AlabamaHit]

The first one is 'admin' not being in the table.

The second is the 'post['userID']' is not getting sent.

You need to check your form there is a problem there.