PHP, MySQL and RSS
Posted: Thu Apr 16, 2009 3:40 am
Hey everyone!
I have a problem, I am creating an RSS feed to my site however, I have 2 tables...lets call them table_one and table_two. Each has there own primary key.
table_two has multiple records relating to table_one (one to many). I want to create a feed where I loop though table_one and pull out all the records but group all related records that are in table_two.
Can this be done for RSS? I know RSS is suppose to be a summary type system with a link but I want to be able to read all items related to another...if any of that makes sense.
Any suggestions or help or sample code would be great!
Thanks
I have a problem, I am creating an RSS feed to my site however, I have 2 tables...lets call them table_one and table_two. Each has there own primary key.
table_two has multiple records relating to table_one (one to many). I want to create a feed where I loop though table_one and pull out all the records but group all related records that are in table_two.
Can this be done for RSS? I know RSS is suppose to be a summary type system with a link but I want to be able to read all items related to another...if any of that makes sense.
Any suggestions or help or sample code would be great!
Thanks