[d1canobe]

hello. I have a user registration script that tells me the details have been registered succesfully but there's nothing in my db. i'm new to this so can't see the problem. here's the script if anybody can help.

PHP Code:

<?php
include 'mysql-connect.php';
$username = mysql_real_escape_string($_POST['username']);
$password = mysql_real_escape_string($_POST['password']);
$fullname = mysql_real_escape_string($_POST['fullname']);
$email = mysql_real_escape_string($_POST['email']);
$ip = $_SERVER['REMOTE_ADDR'];

$result = mysql_num_rows(mysql_query("SELECT * FROM users WHERE username='$username'"));
if($result == 1)
        {
        echo '<p>ERROR! The username you have chosen already exists<p>';
        }
else
        {
        mysql_query("INSERT INTO users (username, password, fullname, email) 
VALUES ('$username', '$password', '$fullname', '$email')");


        echo '<p>Congratulations! You have successfully registered!</p>
                <p>Click <a href="login.php">here</a> to login.</p>';
        }
?>

Thanks

[nafirici]

are you getting an error?

[Nico]

Replace:

PHP Code:

mysql_query("INSERT INTO users (username, password, fullname, email) 
VALUES ('$username', '$password', '$fullname', '$email')"); 

... with:

PHP Code:

mysql_query("INSERT INTO users (username, password, fullname, email) 
VALUES ('$username', '$password', '$fullname', '$email')") OR die(mysql_error()); 

And post the error you get here.

[d1canobe]

Contacted my host provider. Seems there was an error with the server stopping the db from working. Thanks for your help

[LondonTown]

i had a similar issue, cheers for the help.