I have a dynamic PHP/MySQL database-driven web site. The RSS feeds are also dynamically updated using PHP/MySQL. Right now, I have four seperate RSS feeds for four different sections on my web site. The content for these four different sections are contained in four different MySQL tables.
Here's my question: What's the best/easiest way to create an RSS feed that includes all of the content from these four tables and is sorted by date? Basically, I want to create an RSS feed that has all of my web site's content in it. And also, is it possible to do an if statment so that the formatting differs depending on which table the content comes from? And if so, what would it look like?
Thanks in advance for your help.
Jeff