Get maximum ID from a table
Posted on August 30, 2008, Filled under PHP, 
Bookmark it
To get the maximum id from a table you can use the MAX() function.
Here’s an example:
SELECT MAX(id_field_here) as max_id FROM `table`;
Do you wish to receive the latest updates as soon as they are posted? Get our RSS Feed or Subscribe to the Newsletter!
- August 30, 2008
- article by Gabriel C.
- 1 comment
Related Posts
Create, Customize and Send Newsletters: MeeNewsat August 3, 2009 with 1 comment
Update table field by replacing a string value with a new oneat August 28, 2008
Table Sorting, Filtering etc. from JavaScript Toolboxat December 24, 2008
Catch404: Modal Plugin for Handling Broken Links: jQuery | CSSby Gabriel C. on July 31, 2010
Discover How to Make a Website: 50 Mistakes You Should Avoidby Gabriel C. on July 13, 2010
Simple Lightboxing | The Programmer's Lightbox Tool | Lightbox_meby Gabriel C. on June 4, 2010
Grab a copy of Six Figure Affiliate Blogging: Free eBookby Gabriel C. on May 18, 2010
- High resolution zoom with image tiles: http://www.ajax-zoom.com
on August 26th, 2010 by SF
- Hi,I have implement this. When successfully logged in then not redirect to private.php... It just
on August 25th, 2010 by rashidul
- Hi, here in italian we have problem with "è, ì, à, ò" when my customer
on August 25th, 2010 by arcibald
- Hey, I wanted to know how to make this into SMTP method, cuz my server filters
on August 25th, 2010 by Anks
Categories
- AJAX (18)
- Design (9)
- Flash (19)
- Freebies (5)
- General (3)
- Graphics (13)
- HTML & CSS (28)
- Frameworks (7)
- JavaScript (122)
- Frameworks (4)
- jQuery (58)
- MooTools (13)
- Photoshop (2)
- PHP (102)
- Reviews (4)
- Statistics (2)
- Web Tools (6)
- Wordpress (14)
Poll
Loading ...Tag Cloud
- ajax login
- alphabetical
- array
- auto grow
- base
- calculate
- captcha
- chart
- charts
- countdown
- css framework
- delimiters
- documents
- dropdown
- extension
- extract
- filename
- fonts
- form
- gd library
- icon set
- iphone
- lightbox
- mod_rewrite
- percent
- Photo Gallery
- picker
- random
- remove
- script.aculo.us
- search
- shopping cart
- skin form elements
- slider
- syntax highlighter
- tableless
- to-do
- validate
- web analytics
- web fetch
- WYSIWYG
- zoom
One Reply to "Get maximum ID from a table"
March 3, 2009 at 9:25 AM
Mixing of GROUP columns (MIN(),MAX(),COUNT(),…) with no GROUP columns is illegal if there is no GROUP BY clause