Thompson, Jimi wrote:

I'm trying to figure out how to write a MySQL query that will return the
highest primary key a table.

1) Why?

2) SELECT MAX(id) FROM table

3) If you're trying to find the key of the last row inserted to an auto_increment column, use mysql_insert_id() or LAST_INSERT_ID() in PHP and MySQL, respectively.

---John Holmes...

Amazon Wishlist:

php|architect: The Magazine for PHP Professionals –

PHP Database Mailing List (
To unsubscribe, visit:

Reply via email to