php mysql trying to send data to data base but getting Error, insert query failed?

Question

am trying to pass $simon into myaql database but am getting the insert query failed it is connecting to data base but when i try to pass a value into the database get the error insert query failed am i use the wrong code for insert the data into my database

session_start();
$_SESSION['username']==$myusername;
if (($_SESSION['auth'] == false)||(!isset($_SESSION['auth'])))
{
header("location:login.html");
}
$host="localhost"; // Host name
$username="20203800"; // Mysql username
$password="ralph"; // Mysql password
$db_name="two0203800"; // Database name
$tbl_name="link"; // Table name


mysql_connect("$host", "$username", "$password")or die("cannot connect");

$query = "INSERT INTO $tbl_name (username)
VALUES ( '$simon' )";

mysql_query($query)
or die('Error, insert query failed'.mysql_error());


mysql_close($con);
// header( 'Location:http://2020.sost.blackburn.ac.uk/members.html ' ) ;

?>

Answer 1

You didn't select the database, and you are also trying to close a connection that isn't open.



Change your connect statement to



$con=@mysql_connect("$host", "$username", "$password")or die("cannot connect");



Then you can select the database with



$db=@mysql_select_db($db_name, $con);

Answer 2

After connecting to the server, you should select the database. You can do this by,

$dbs=mysql_select_db('two0203800')or die('cannot use db');

Answer 3

Well first of all, the setcookie is invalid. You need to close the parenthesis and all that. I have modified the code for it to work.