Users

I started working on creating from scratch a user login script. I think I have the login working, however I ran into trouble on the register page. I copied the sql query from the login, where it checks to see if the user has access, basicly it checks for a specific user name and then checks the password. I copied that and got rid of the password part so it was only checking to see if the user was in the database in hopes to eliminate duplicate users, however it do sent seem to be working, basically there is an IF statement and if they query returns a result its suppose to say that the user is registered but its not returning a result at all so it always says that it can create the user (I ha vent made the actual sql INSERT statement so its really not doing anything but checking for now).

Since this was a copy and paste from what I already had working I am not sure whats wrong exactly. I hope to work more on it tonight and hopefully I will have a brainstorm. But as it stands now, with the user I entered manually into the database it seems to be working. Not that anything is secured or running off a loged in user but its a start.