View Single Post
Old 2010-03-04, 11:04 PM   #21
mark6188
I'm going to the backseat of my car with the woman I love, and I won't be back for TEN MINUTES
 
mark6188's Avatar
 
Join Date: Sep 2009
Posts: 88
Send a message via ICQ to mark6188
Okay, fixed the database error and was able to add a new user.

You had several syntax errors - particularly quotes and double quotes- just too many to mention. (note: when you copy code from a website - watch the single and double quotes - you often have to replace them with the correct quote - difficult to explain but look at the quotes around this variable - `username` -need to change the quotes to 'username'.

You also selected the wrong table - dbUser instead of dbuser.

The table itself had errors in how you named the fields. You put a single quote around each one like 'username' when you should just put in username.

The php server was not on the same host as your database, so you have to point to the correct host and not "localhost" in the dbConfig.php file.

Another not so obvious fix was the password itself - I had to run a simple password query to make the password work. SETPASSWORD = OLD_PASSWORD('OLIVIAlynn616');

There are still some problems with the "Input vaildation" section of code as it doesn't detect when I leave a field blank.

I added some code and rewrote some of the other stuff to be clearer on what's going on and what's passing around. I also added the mysql_error() function to help diagnose some of the problems. you should use this everywhere - it's helps a lot.

That's about all I can do tonight, really tired. But you are up and running more or less. If you still have trouble, I'll try and help you out tomorrow.
__________________
My Blog: Working The Business

Last edited by mark6188; 2010-03-04 at 11:10 PM..
mark6188 is offline   Reply With Quote