[RESOLVED] Select rows from MySQL where colum != value

[rsmith]

Here's my problem. I need to select all managers from my Managers table where the username is NOT admin. My query is as follows:

$query = "SELECT * FROM Managers WHERE username != 'admin' ORDER BY username";

When I go to run my script I get an invalid resource. How do I tell it to query my table for what I'm wanting to do?

TIA!

[laserlight]

It look okay to me. What do you get as the SQL error?

[rsmith]

Actually it works now, i had the column in the table typo'd