Cannot insert data into MySql table

[drumdogg]

Im having problem when i go to insert data from a table into MySql table.

Here is my php code:

<?php

$Date = $_POST['Date'];
$StartTime = $_POST['StartTime'];
$TestTime = $_POST['TestTime'];
$t1 = $_POST['t1'];
$t2 = $_POST['t2'];
$t3 = $_POST['t3'];
$t4 = $_POST['t4'];
$t5 = $_POST['t5'];
$t6 = $_POST['t6'];
$t7 = $_POST['t7'];
$t8 = $_POST['t8'];
$Initials = $_POST['Initials'];
$PassFail = $_POST['PassFail'];

mysql_connect("localhost","***","******");
mysql_select_db("*******");

$query="INSERT INTO testing (Date, StartTime, TestTime, t1, t2, t3, t4, t5, t6, t7, t8, Initials,PassFail)
VALUES
('NULL','".$Date."','".$StartTime."','".$TestTime."','".$t1."','".$t2."','".$t3."','".$t4."','".$t5."','".$t6."','".$t7."','".$t8."','".$Initials."','".$PassFail."')";

$result=mysql_query($query)or die('Error updating database');
?>

Im getting the 'error update database' message when i run that code and the data doesnt insert into mt table.

Any suggestions please??

 

[drumdogg]

I have removed the 'NULL' and its still the same.
SQL Injection?? Could you explain please.

 

[drumdogg]

Ok guys thanks for the explanation.

But i still cant get this code to work Any other ideas??

 

[drumdogg]

Ok thanks that helped me find some errors

If i run the php file on its own it inserts a blank row into the database as it should.

But if i enter the data into the form and hit submit nothing inserts into the database.

Must be something wrong with my submit button!

I have the form action pointing to the php file and the method=post.

Is that correct??

 

[drumdogg]

Right guys got it sorted

Thanks for the help Cheers