This is a discussion on Am I able to select the last item in my database? within the Php and MySQL forums, part of the Programming / Scripting / Coding category; What I need to know is am I able to ask my query to select always the last item in ...
| |||||||
| Register | FAQ | Members List | Calendar | Search | Today's Posts | Mark Forums Read |
| | #1 (permalink) |
| Newbie | 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! |
| | |
| | #2 (permalink) |
| Super Moderator | I'm not going to write your code for you (unless you pay me
__________________ 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 |
| | |
| Tags |
| database, item, select |
| Thread Tools | |
| Display Modes | |
| |
| ||||
| 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 |