How To Get The Next Auto-Increment Value In MySQL

[JustinK101]

I see: mysql_insert_id -- Get the ID generated from the previous INSERT operation

But that requires that you have already done an insert operation. I need to just reference the next autoincrement value of the table. Thanks for the help.

[doni49]

Justin,

Maybe if you tell us a little about what it is you're trying to accomplish, someone can help figure a way around that.

[JustinK101]

Ok so here is what I have:

$sql = "SELECT MAX(ID) AS max_id FROM employees";
$result = mysql_query($sql) or die(fatal_error_alert(mysql_error(), $sql));
$row = mysql_fetch_assoc($result);

Which works, ($row['max_id'] + 1) holds the next autoincrement.

Now, I need to way to manually increment the table employees without doing an insert. I just need to increment the auto-index.