Am I able to select the last item in my database?

ShaunBurden · 19-04-2007, 16:57

What I need to know is am I able to ask my query to select always the last item in my database, so that my php will display what is in the last one.

Also, I would like to know if I could query the database to select the second last, the thrid last and the fourth last item in my database, so that I can write my php code to select what ever has been queried.

I have four tables, and in each table is a piece of code that connects to the database and brings in what is queried, so thats why I would like to know if this is possible and what the SQL & PHP would be.

Thanks!

**monaghan** · 19-04-2007, 19:27

I'm not going to write your code for you (unless you pay me

), however, look at the limit clause on your select, this will allow you to filter what you select.

19-04-2007, 16:57	#1 (permalink)
ShaunBurden Newbie Join Date: Mar 2007 Posts: 12 iTrader: 0 / 0%	Am I able to select the last item in my database? What I need to know is am I able to ask my query to select always the last item in my database, so that my php will display what is in the last one. Also, I would like to know if I could query the database to select the second last, the thrid last and the fourth last item in my database, so that I can write my php code to select what ever has been queried. I have four tables, and in each table is a piece of code that connects to the database and brings in what is queried, so thats why I would like to know if this is possible and what the SQL & PHP would be. Thanks!

19-04-2007, 19:27	#2 (permalink)
monaghan Super Moderator Join Date: Mar 2005 Location: Herts, UK Posts: 1,030 iTrader: 1 / 100%	I'm not going to write your code for you (unless you pay me ), however, look at the limit clause on your select, this will allow you to filter what you select. __________________ Alex Monaghan - Monaghan Consultants Ltd Web hosting, ADSL, IT & Database consultancy Custom Web hosting on UK or USA servers using Linux (cPanel) or Windows (DotNetPanel) Mobile Phone Ringtones, Logos, Java Games & more

Thread Tools
Show Printable Version Email this Page
Display Modes
Linear Mode Switch to Hybrid Mode Switch to Threaded Mode

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
A text input and select box?	ShaunBurden	Programming / Scripting / Coding	0	02-03-2007 11:46
Good Database Software	Daniel S	Website Development Forum	1	19-12-2005 20:48
New Store Item - Domain Name	Wistow	Forum Announcements	44	14-05-2005 15:21
New Store Item - Hosting	Wistow	Forum Announcements	11	16-04-2005 00:18
a music database	thecsp	Website Development Forum	9	12-04-2005 23:49

Am I able to select the last item in my database?

Am I able to select the last item in my database?

Similar Threads