Auto increment feild

[dcjones]

Hi All

I have a table which has an auto increment feild along with other feilds. The auto increment feild has the following structure:

FEILD = booking_id
TYPE = INT
NULL = NO
EXTRA = AUTO_INCREMENT

This feild is also the PRIMARY INDEX.

I have a form with my table feild on it including the auto increment feild 2booking_id"

What I want to happen is when the form is loaded I want the "booking_id" feild to show the next booking id number. At the moment it shows the last booking id in the table and not the next one.

Can soneone advise please.

[bogu]

Try this mysql query: SHOW TABLE STATUS LIKE table ...