Insert Query???+php

[obrienkev]

Hi all,

I have created a web interface to allow the user to input a person's details into a database.

My database contains the following fields...
candidateID int(10) UNSIGNED Not Null auto-increment Primary Key

name varchar(40) Not Null

email varchar(100) Not Null

party varchar(5) Not Null

My web interface contains the following fields...
name, email, party.

My problem is how do I insert these fields into the db properly.I want the candidateID field to increment automatically with each entry.
I currently have...

$query = "insert into candidate values
("NULL", '".$name."', '".$email."', '".$party."')";

Please could you help me. I am very grateful for your time and help.

Thanks again.
Kevin.

[laserlight]

$query = "INSERT INTO candidate VALUES
	(NULL, '".$name."', '".$email."', '".$party."')";

btw, if I remember correctly, shouldnt it be AUTO_INCREMENT, not auto-increment?