[SOLVED] Simple MySQL Query error

[me1000]

Howdy,

 

Working on developing a simple login script

but Im getting an error...

after about a half an hour of debugging this very simple script

I have narrowed it down the the query

 

here is the code...

Maybe fresh eyes can find it.

 

// Connect to server and select databse.
mysql_connect("$host", "$username", "$password")or die("cannot connect"); 
mysql_select_db("$db_name")or die("cannot select DB");




// username and password sent from form 
$myusername=$_POST['myusername2']; 
$mypassword=$_POST['mypassword2']; 



// encrypt password
$encrypted_mypassword=md5($mypassword);

$sql= "INSERT INTO $tbl_name (username, password) VALUES ('$myusername','$encrypted_mypassword'";
$result=mysql_query($sql);

$response = ($result) ? "Record Added" : "Error adding record!";

echo $response ;

 

 

Thank You,

Me1000

[suzzane2020]

$sql= "INSERT INTO $tbl_name (username, password) VALUES ('$myusername','$encrypted_mypassword'";

 

not sure if its a printin mistake but i think u missed a closin bracket there

[me1000]

That was it...

 

Thank you, I knew it was something trivial like that.

 

 

Thanks Again