auto incriment

[curley]

hi i have a prob.

i have a database table with 2 fields and i want them to auto increment.

right the problem is i am using this query

// here we are trying to add a name
if ($action=="addcomment") {




$comment_insert = $DB_site->query("INSERT INTO `name` (`nameid`, `comment`) VALUES (null, '$comment')");

it just updates all the comments to the same one so i end up with loads of the same name???

the thing is if i use it in phpmyadmin and do the same query but change (null, '$comment')"); to this (null, 'trevor')");

it puts a new line in with the id no and trevor

what am i doing wrong ??