| | ||||||||
| |||||||||
 |
03-20-2010, 04:11 AM
| #1 |
| Advanced Warrior Join Date: Nov 2008
Posts: 609
Thanks: 31
Thanked 1 Time in 1 Post
|  Can Someone Help Me This Mysql Query Please??
Alright guys I dont know if you can help but I thought I ask  I am trying to set up a mysql query so that I can only display the latest category that has been added to my site... On the table that I am trying to create it under it has got the following infomration.. id (numeric number) cat_name (name of category The id increses by one each time I add new category to the site... For example if I add one now called it Master it will have the id 1 allocated to it.. Then tomorrow I add another category call it Private will have the id 2 to it, and so.. At the moment I can get all categories to be displayed.. I just want it to the latest one.. Can anyone help please?? |
|  |
|
03-20-2010, 08:08 AM
| #2 |
| HyperActive Warrior War Room Member Join Date: Dec 2009 Location: Costa Rica
Posts: 172
Thanks: 74
Thanked 44 Times in 42 Posts
| Re: Can Someone Help Me This Mysql Query Please??
good morning  Code: select id,cat_name from table_name order by id DESC limit 1 |
| | |
|
| |
|
03-20-2010, 11:19 AM
| #3 |
| HyperActive Warrior War Room Member Join Date: Dec 2009 Location: Costa Rica
Posts: 172
Thanks: 74
Thanked 44 Times in 42 Posts
| Re: Can Someone Help Me This Mysql Query Please??
or.. Code: select max(id),cat_name from table_name |
| | |
|
| |
|
03-21-2010, 11:01 PM
| #4 |
| PHP Programmer  Join Date: Nov 2009 Location: /dev/null
Posts: 136
Thanks: 5
Thanked 12 Times in 12 Posts
| Re: Can Someone Help Me This Mysql Query Please??
Of course, make it super simple to read :] --m4rx |
| We are what we repeatedly do. Excellence, then, is not an act, but a HABIT. ~Aristotle Bored. Check out my blog. | |
|
| |
 |
|
| Tags |
| mysql, query |
| Thread Tools | |
| |
 |
