Inserting incremental value

[Tim_Silva]

Hi,

How do I insert an id number into the 'id' row so that it will be the last id in the table + 1.

My current INSERT is:

mysql_connect($hostname,$username,$password) or die(mysql_error());
mysql_select_db("$dbname") or die(mysql_error());
mysql_query("INSERT INTO `$usertable` VALUES ('$id', '$subjectId', '$title', '$source', '$url', NOW(), '$content')");

Thanks for your help.

Tim

[laserlight]

Assuming that id is an autoincremented primary key, then I suggest letting the database engine handle this for you. Whether it is exactly the last id + 1 or not does not really matter.