Re: Last/highest ID?

[Wesley notrelevant]

David Garstang Wrote:
-------------------------------------------------------
> OK, here's an example PHP fragment from my own
> code. I did a quick clean-up of irrelevant stuff,
> so I hope I didn't break anything, but I don't
> have time to test it now, sorry!
>
> Just above this PHP snipped, I had inserted a new
> row into the "person" table, which has an
> auto-increment ID colum. Here's how I retrieve
> the ID into a PHP variable named $idnum:
>
> ---------------
> $result=mysql_query("SELECT LAST_INSERT_ID();",
> $db_conn);
> if (!$result)
> {
> die ("ID retrieval failed: ".mysql_error());
> }
> $row = mysql_fetch_row($result);
> $idnum = $row[0];
> -----------------------------
>
> The mysql_query function returns an integer value
> that identifies the result set that was generated
> by the query. This goes into $result in the above
> example.
>
> Then mysql_fetch_row fetches a single row from
> this result set into an array, putting it into a
> variable named $row.
>
> "$idnum = $row[0]" returns the first (and in this
> case ONLY) value in that row, which is the desired
> ID. (In case you weren't aware, in PHP arrays,
> the first element is always item ZERO, not one)


Cheers, it worked! Thanks! ;-)