Problem!

[Chris]

Hi

Can someone please give me the SQL Query to the Resgister and Login script.

I have tried looking at the picture and taking out the query but it never seems to work when i try to create the table!

Any help would be great.

Chris!

[Flash-db]

What login and registration script?


An simple example of a registration SQL statement would involve the "INSERT" function such as:

//Connect to DB
$connect = mysql_connect($DBhost, $DBuser, $DBpass);
mysql_select_db($DBName, $connect);

// example Register SQL
$result = mysql_query("INSERT INTO yourtableName (UserName, Password, Email) VALUES ('$username' , '$password', '$email')", $connect);

// example Login SQL
$result = mysql_query("SELECT * FROM yourtableName WHERE UserName = '$userame' AND Password='$password'", $connect);