Why on earth does this not work?

[-Felix-]

Hey its me again and stupid questions volume 3....

 

I dont get any errors, the following code just does not write anything to MySQL.

 

mysql_connect ("localhost", "login", "password") or die ('I cannot connect to the database because: ' . mysql_error());
mysql_select_db ("database"); 


$serialnumber=$_SESSION['Serialnumber'];
$Quality=$_SESSION['Quality'].'; '.$_SESSION['Quality2'];

mysql_query("INSERT INTO Tablename (Serialnumber,ID, Date, Details,Quality,Time,Status,Address) VALUES ($serialnumber,'1',$date,$Details,$Quality,$Time,'Waiting','Address')");


mysql_close();

[effigy]

you should also use or die on your query statement. you are using a reserved keyword (date) as a column name. change it or surround them with backticks: ``.