Re: news site, recent entries retrieval

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 entry was made and you wanted the 10 most recent items of type 2, most recent first: select * from mynews where type = 2 limit 10 order by timestamp desc; Untested, but I think the syntax for MySQL is correct. Check in the MySQL manual if its not. Really a mysql list question. HTH Chris