Get maximum ID from a table
Posted on August 30, 2008, Filled under PHP, 
Bookmark it
Thanks for visiting our website! We regularly publish posts like this one. If you are interested in receiving the latest updates as soon as they are posted, please consider subscribing to the RSS feed or to our e-mail newsletter.
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
Sponsors
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
-
An Advanced Lightweight JavaScript Table Sorter: TinyTable V3at November 19, 2009
- Hey Vedrin, did you find your answer about getting all matches on the pages? You
on March 13th, 2010 by nonecantest
- a simple array will generate 1-1000
on March 12th, 2010 by whitehatninja
- Yeap. Its cool. Its very nice script
on March 12th, 2010 by Shailesh Mane
- O also extend the code so that more languages are available for highlighting... which it
on March 12th, 2010 by One More
-
Multi-touch Vector Gestural Icons: Scalable and Alterableby Gabriel C. on March 13, 2010
-
Facebook-style Lightbox/Modalbox powered by jQuery and MooToolsby Gabriel C. on March 12, 2010
-
Slideshow with Smooth Animated Transition: jQuery Blindsby Gabriel C. on March 11, 2010
-
Flabell Birthday Bundle - 26 Flash Components - Happy Birthday!by Gabriel C. on March 6, 2010
Categories
- AJAX (17)
- Design (8)
- Flash (19)
- Freebies (2)
- General (3)
- Graphics (11)
- HTML & CSS (26)
- Frameworks (6)
- JavaScript (111)
- Frameworks (4)
- JQuery (47)
- MooTools (13)
- Photoshop (2)
- PHP (102)
- Reviews (3)
- Statistics (2)
- Web Tools (6)
- Wordpress (13)
Advertisements
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