Finding out current auto_increment number?

[Mutley]

I have a form that uploads an image, that I want to rename the image to the next auto_increment number that is in a field (id) of a row. How do I do this?

 

I was trying to SELECT the last "id" and add 1 but obviously if I deleted a row, then went to add another picture, it would be 1 behind/incorrect.

[per1os]

The best bet is to use the mysql_insert_id(); function. See below for reading on that.

 

http://us3.php.net/manual/en/function.mysql-insert-id.php

 

--FrosT

[mattd8752]

I believe you would select all records, and loop through them, making PHP set a variable to the number if that is higher than the currently open variable.  What I mean is:

 

$curr = SQL_QUERY;

if($curr > $x){

$x = $curr;

}

 

I'm not sure if there is another method.

[per1os]

<?php

$sql = "SELECT id FROM tableName ORDER BY id ASC LIMIT 1";
$qu = mysql_query($qu);
$id = mysql_fetch_array($qu);
$id = $id[0];
?>

 

--FrosT

[Mutley]

The best bet is to use the mysql_insert_id(); function. See below for reading on that.

 

http://us3.php.net/manual/en/function.mysql-insert-id.php

 

--FrosT

 

Woah, easiest PHP yet, thanks. Worked straight away.