I have a database of news/articles/pictures/videos/mp3
I have made a template design and need to display entries from mysql.
there will be three type of pages:
1. Home page which lists latest 25 entries from News category (title, image if any, and 200 words of text with read more link)
1. Category/Subcategory pages which list all entries (title, image if any, and 200 words of text with read more link) from that category. On the menu, it should list subcategories related to that category.
2. Content page which lists FULL CONTENT
URLs should be search engine friendly.