[SOLVED] Inserting new record +1

[liquinas]

Hi, this is pretty simple, I have

 

$query = "INSERT INTO Cars (ID) VALUES ($ese)";
$result = mysql_query($query)
or die ("Problem with Query. Contact liquinas@yahoo.com");

 

On the table the field ID is primary key. There are 6 record on the table with IDs 1-6.

I need $ese to equal the highest ID +1 so that if I hit the button and run the query, record #7 would be inserted, and so on.

 

Thanks in advance.

[Yesideez]

When inserting a new record MySQL will automatically increase the primary key by one every time you add another record.

[liquinas]

I totally knew that >.>

 

<.<