Next Auto Increment value Retrieval

LucidParody

Hi, I have a mysql table that has a column that's autoincremented. Over time, I've deleted various records from the table so the auto increment field looks something like this:

3
4
5
7
8
10
etc.

If my php script has the value of one of the ids, for example 5, to find out what the next increment in the database is?

I can't just go 5++ as that'll return me 6, which is not the id of the next increment?

T.I.A. 🙂

parawizard

this function will retrieve the last enter auto incretment ID

$last_id = mysql_insert_id();

hope that helps if not search auto incretment on www.php.net

LucidParody

That's not quite what I was looking for. I was looking for how to get the next id, not the last id. But thanks anyway.

After some more searching, I did manage to find my answer. If anyone else has a similar problem, here is the solution:

SELECT * FROM table WHERE id > current_id ORDER BY ID LIMIT 1;

LucidParody

Originally posted by LucidParody
That's not quite what I was looking for. I was looking for how to get the next id, not the last id. But thanks anyway.

After some more searching, I did manage to find my answer. If anyone else has a similar problem, here is the solution:
SELECT * FROM table WHERE id > current_id ORDER BY ID LIMIT 1;
[/B]

I do have another question, perhaps I can just tack it on to here and someone will see -- how many querys per page is too much? On average? How many querys would a bulletin board like phpBB or vB do on an average page? TIA. 🙂

parawizard

im coding my own forum from scratch and basically depending on how the database looks i would say theres a query for every post and initial query for threads and post ids

then u display posts by ids that u got from the thread table in a loop 🙂

im going to recode my whole forum soon with customizeable graphics and some better code :S