T variable error php

PHP Mysql insert

[truckone1]

I keep gettng an T_variable error when trying to inster data into my db.

I have change the code several times. I am getting error in mysql version 4 an 5 .

$connection = mysql_connect($host, $usr, $pwd);
or die(mysql_error());
echo "Connected to MySQL<br/>";
$database=mysql_select_db("mysurf") or die(mysql_error());
echo "Connect to Database";

$username=$_POST["username"];
$password=$_POST["password"];
$email=$_POST["email"];

$insert = mysql_query ("INSERT INTO `users`(`user_n`, `pass`, `email`)VALUES($username, '$password', '$email')");
or die(mysql_error());

$result=mysql_query($database, "$insert", $connection);
if (!$result))
{
die('Error: " .mysql_error());
}
echo "1 record added";
mysql_close($conection)

?>

[barns101]

It looks like you need to enclose your username within single quotes:

$insert = mysql_query ("INSERT INTO `users`(`user_n`, `pass`, `email`)VALUES([b]'[/b]$username[b]'[/b], '$password', '$email')");

[RonPK]

Yes, use quotes, and mysql_real_escape_string() [php.net].

Welcome to WebmasterWorld, truckone1.