Here is an added point from some more use :)
The above method does work for a feed if needed. The only issue i found with the above script is that the date is not getting added correctly or changed to the correct pubDate rss format from the sql table. A big deal for mailchimps rss to email feature.
However after hours of trying to impplement a custom solution, i regressed back to seeing if i could fix the issue i was having with the k2 rss feature. In firefox i would get a subscription option but the page was empty. in chrome, thankfully it atleast parsed the text and i could see that items were indeed getting put into the xml, so what was going on. Mailchimp said that the feed was invalid.
so i went to see if Google feedburner could generate a feed from the blog's url. It of course found the k2 rss feed url path in the header. However, it did pass me an error "The entity name must immediately follow the '&' in the entity reference." on line ten of my xml which the feed validator from feedvalidator.org showed was the description; which in k2 is taken from a metatag field. From an internet search it seems that this error is due to the '&' not being parsed correctly in my metatag description used to generate the rss' description. I found the metatag from whence the description came, changed '&' to 'and' and walla! The error went away, the feed validated, and mailchimp took it and it has the date correctly formatted which should trigger the auto email!
I sure the problems with xml and k2 that some have experienced might be due to various issues. But in my case with the latest k2 and joomla (2.5) the feed itself was good, just a bad character not getting dealt with well by the xml. Once this was fixed in the description, all was well. Which i am glad for. I learned much about rss, php, and xml when toying with all the tutorials, but there are just soooo many different ways of doing it and sadly, most of them just plain don't work :) at least without a lot of customization, trial and error.
Hopefully this helps some :)