Results 1 to 5 of 5
Thread: Help with some basic MySQL...
Jan 20, 2001, 16:38 #1
- Join Date
- Dec 2000
- Idaho, USA
- 0 Post(s)
- 0 Thread(s)
I'm really having a hard time trying to do this... so I've decided to see if you guys here can help me out.
I have a database of tips, and I want to only display the last five tips entered into the database. I want these first five to be displayed with their text. But I want the rest of the tips to be "archived" at the bottom of the page, and only their title's showing.
I have a table named tips, and these colums:
The ID is an auto-incrament. The I have a online form to add tips. Each tip requires an input of a title, content, and an author. The data is auto.
So there you have it. I have played with the mysql_insert_id() taking away five etc. But I have had no luck. I have been trying to use the while statement, with no luck so far. Could anyone please shed some light?
AlexBlamestorming: Sitting around in a group discussing why a deadline was missed or a project failed and who was responsible.
Exbabylon- Professional Internet Services