Auto_increment

[slevytam]

Hello,

I was just wondering if there was a way to find out the next auto_increment number before the actual insert record was performed.

Thanks,

--SL

[warozzo]

$count = "SELECT COUNT(*) FROM table";
$result = mysql_query($count);
$auto_number = $result + 1;

is this what you want?

[slevytam]

Thanks for your reply.

I believe this is what I want. The next record I insert into table will have an auto_number of $auto_number, right?

Basically, I have an ID field which is primary key and auto_number. I just needed to find the next id to be generated.

--SL

[kevinsequeira]

if u are inserting into a table which has an autonumber value, u dont have to specify the id in the insert statement

table : names
id
last_name
first_name

INSERT into names (last_name,first_name) values("john","doe");

even though warozzo 's code is right it may not be ideal in your case if you want to insert into the table with a id, cause another id may be generated in between the time u execute the code and the INSERT statement

reg
kevin

[slevytam]

Thanks for your reply,

The reason I need to get the id before insert is because I would like to use it in the table.

ie
table grades
id auto_increment
title text,
location text

I would like to insert
INSERT into grades (title,location) values("thetitle",id."pdf");

Does this make any sense. Sorry for the annoyances.

--SL