Msyql Efficiency Help

[section31]

ok...this is is just an example of what I need...don't ask why i would need such a thing b/c its for some script i'm writing for fun...
a very simple mysql table...
TABLE urls
->FIELD1 INT "id" this is set to primary and autoincrement
->FIELD2 VARCHAR "urls"

what would be the most efficient way to find the next (id) integer in line to be pushed onto the database. Is there an easy way around this w/o doing a major query to the database.

Remember: the ID is set to autoincrement so it would just be a query to find the max id on that table and just increment. Basically just trying to find the next Cardinality of that key. w/o inserting anything.

thanks,
Dave

[Kudose]

$num = mysql_query("SELECT LAST_INSERT_ID() FROM table") or die(mysql_error());
$num += 1;
echo "The next user to be entered will have ID number: ".$num;

Is that what you are looking to do? If not, then I think I am confused about the question.

[section31]

hm..this didn't work too well since i didn't add anything into the table so it gave an incorrect number...OH well...for now i'm just going to use a select MAX(id)