[PHP] Can someone check this mysql code

[PhilipNZ Staff]

My code below don't want to insert the code into the database what am I doing wrong?

<?php

 $answers="$band, $middlename, $pot";
 $date=date ("l dS of F Y h:i:s A");
 
 $sql = "INSERT INTO `prizeline` (`id`, `email`, `name`, `address`, `answers`, `date`) 
VALUES ('', 'email', 'name', 'address', 'answers', 'date');";
    
$result = mysql_query($sql);

?>