Results 1 to 3 of 3
Thread: marticle help.
Jun 17, 2001, 23:09 #1
i'm no php wiz so can't figure this out.
for my front page i want to list the three newest articles for each category. for example, i review section. on the my front page i want to have the the 3 newest reviews added to my database and another list of the three newest interviews and so on.
anyone got any solutions for me? throw your ideas at me.
thanks in advance
Jun 18, 2001, 05:23 #2
- Join Date
- Apr 2000
- Melbourne, Australia
- 1 Post(s)
- 0 Thread(s)
You'll need a DateCreated column in your tables with MySQL type DATETIME which you assign a value of NOW() whenever you insert a new entry in your tables. This will track their creation date. You can then select the three most recent very simply:
SELECT * FROM tbl_name ORDER BY DateCreated DESC LIMIT 3
Jun 18, 2001, 05:44 #3
my first born child will be named "kyank"