Im making a registration script and having problems

[JamesThePanda]

hey guy

Im making a registration script for my login script

Im just wondering as Im realy new with php and mysql

 

what can I do to check that the query was executed properly.

 

I wanted to use some form of "if else" function

 

<?php
$host = "localhost";
$username = "root";
$password = "";
$db_name = "members";
$tbl_name = "memtable";

mysql_connect($host,$username,$password) or die (mysql_error());
mysql_select_db($db_name) or die (mysql_error());

$username1 = $_POST['username1'];
$password1 = $_POST['password1'];

mysql_query("INSERT INTO 'memtable'('name','password') VALUES('$username1','$password1')");

echo 'done';

?>

 

 

Any Suggestions

 

Thanks

 

James

[Alex]

mysql_query returns false on failure. You're also using a lot of unnecessary single quotes.

 

$result = mysql_query("INSERT INTO memtable (name, password) VALUES('$username1','$password1')");
if(!$result)
{
     echo "There was an error!: " . mysql_error();
}