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?