How to select an enum type

[FusionTech]

I know, its probably a really basic question for most of you out there, but I can't seem to find an answer. This is what I've tried:

 

if(SELECT * FROM users WHERE usertype='a';) {

                print "You are a regular user!";

            } else {

                print "You are an administrative user!"; 

            }

 

It always says You are an administrative user! when I log in, even though I am user type a in the database.

 

Also, if anyone could tell me how to generate a user profile page (http://domain.com/profile.php?fusiontech) after a user registers, that would be great also.

[requinix]

How about posting your actual code. And the whole thing - especially the part that logs you in.

[FusionTech]

Ok, this is everything in the file that that code came from. 

 

EDIT: Sorry, that last link was bad. http://pastebin.com/Y1CFrsr2

Edited April 14, 2013 by FusionTech

[requinix]

That code will not run at all, let alone give you the wrong output.

 

Whatever. You already have the usertype in $row['usertype']. Look at that instead.

[FusionTech]

Actually, the code does run, It worked, I have my user in the database from when I made my account.

[requinix]

No, it doesn't.

if(SELECT * FROM tbl_name WHERE usertype='a';) {

That is a syntax error. It will prevent your script from running.