[PHP] news site, recent entries retrieval

2002-11-13 Thread Pag
Hi, I am writing a back end to be used by general news and journal sites and i am running into some problems. I already did all the background work, created the tables, programmed a php news manager to add, edit, remove entries/comments, etc. The problem is displaying all the info on the

Re: [PHP] news site, recent entries retrieval

2002-11-13 Thread Chris Hewitt
Pag wrote: One of the fields in my tables is type (values 0, 1, 2 etc), which divides the news into categories, how can i display like the 10 most recent entries of type = 2, for example? If your table is called mynews and it has a field called timestamp which contains the date/time the