<?php
include('config.inc');

$sql="INSERT INTO user (attendance1, colour1, shade1, attendance2, colour2, shade2)
VALUES
('$_POST[attendance1]','$_POST[colour1]','$_POST[shade1]','$_POST[attendance2]','$_POST[colour2]','$_POST[shade2]')";

if (!mysql_query($sql,$con))
  {
  die('Error: Not Submitted' . mysql_error());
  }
echo "1 record added";

mysql_close($con)
?>

your form has been submitted