Hi,
You can use the function mysql_insert_id(MYSQL *mysql) and add 1 to the
result.
If you want an SQL approach, you might want to use SELECT MAX(your_auto_inc)
FROM your_table
Regards
Jorge
MySQL Development Team
__ ___ __ __
/ |/ /_ __/ __/ __ \/ / Jorge del Conde <[EM
> > is there a function for this? or do I have to get all IDs and parse out
>the
> > last one?
Try this function:
SELECT DISTINCT last_insert_id() from "table_name"
Regards,
David
-
Before posting, please c
something like this I was hoping
SELECT MAX([database.[ID]) AS [LAST-DEFECT] FROM [database]
> Hi.
>
> I have a database where information is submitted to.
> On the submit page I want to show the ID number of next 'thing' to be
> submitted.
> I use auto increment for the ID.
> There must be som
