Mark Hensler — Thu, 21 Nov 2002 06:01:46 +0000

Why do you want the next auto_increment number?
What do you plan on doing with it?

FinalMjolnir666 — Thu, 21 Nov 2002 01:27:23 +0000

Ah okay, thanks.

I heard that that might not be a very safe way to do things on something user intensive like a forum, because if two people request things right after another, they might get the same things, and then post things with the same thing... and... well... it's tough to explain.

Is this a safe way of doing things that you know of?

Mark Hensler — Thu, 21 Nov 2002 00:52:51 +0000

try this:

SHOW TABLE STATUS FROM `message_board` LIKE 'threads';

this will return a list of fields including Auto_increment, which contains the value of the next auto_increment value.

mySQL Docs:
4.5.6.2 SHOW TABLE STATUS