Figuring out an auto incremented #

[blitzwing]

I'm putting together a little polling thing for work. I've got two tables:

Poll

poll_id
poll_name

and

poll_choices

poll_choices_id
poll_choices_text
poll_id

When I add another poll, I'm adding the choices as well. The poll_choices table is the many side of the relationship, with poll_id matching the poll_id in the Poll table. I do my insert into the Poll table first. How can I find out what number was just used to in the auto increment for poll_id within the same script? I figured counting the rows would work, but if a row is removed, the autoincrement doesn't take that into account and starts counting up as if those rows still exists.

Any ideas?

[weekender]

sneakily, there is a function [man]mysql_insert_id()[/man] which gives the autoid of the last INSERT statement

adam

[blitzwing]

That looks useful. Though, it's for a CVS build of php5, and not 4. 🙁

[weekender]

php5 is not being bundled with mysql libraries as standard at the moment because of a licensing issue (read http://jeremy.zawodny.com/blog/archives/000812.html, especially the comments for more info)

[LordShryku]

You were sent to the mysqli functions. This you really want this one

[blitzwing]

Excellent. Thanks guys.