I am getting this error :

You have an error in your SQL syntax. Check the manual that corresponds to your MySQL server version for the right syntax to use near '@nanothree.net, 08/08/2004)' at line 1

the sql query is

PHP Code:

$sql = "INSERT INTO mailinglist (name, email, date) VALUES ($name, $email, $date)"; 


Which, when all teh varibles are are repalced with their values looks like this:

INSERT INTO mailinglist (name, email, date) VALUES (liam, liam@nanothree.net, 08/08/2004)

can anyone see why this has happened?

I should have used:
$sql = "INSERT INTO mailinglist (name,email,date) VALUES ('$name','$email','$date')";

thanks that sorted it