PHP Login Script Help

[trichampions]

Sorry I know you guys say dont double post but I was only clicked on client side developement so I didnt know a PHP board existed. I wanted to delete my old post but I didnt have the option to do so. Anyways Im not getting help from the HTML board lol so Im gonna post this here, just delete the HTML post if you see it(to whoever runs the forums).

Ok I got a PHP login script from http://www.evolt.org/article/PHP_Lo...ature/17/60265/
I put in all the information just basically copy and pasted it. I made a database.php, login.php, logout.php, register.php, and main.php files just like it says to in the script. Every page shows CREATE TABLE users ( username varchar(30), password varchar(32)); at the top where it would be <?
session_start();
include("database.php"); in the file. Also every time I try and register to see if it works I get this error: CREATE TABLE users ( username varchar(30), password varchar(32));
Registration Failed
We're sorry, but an error has occurred and your registration for the username trichampions, could not be completed.
Please try again at a later time.

I have deleted all spaces I have seen in the file, it still is doing it, Im guessing its something to do with the database.php but I dont know anything about php except that you cant have any empty lines in the coding. Can someone please help me?

[Sheldon]

Well that script is trying to make a sql table in your database, once you have done that once you need to just add the info to the databse and not try recreating it every time.

try


$addsql="INSERT INTO users(username,password)
VALUES('$username','$password')";
mysql_query($addsql);

Use thei article for Defensive Coding (http://www.charles-reace.com/article.html) be NogDog.