Creating an RSS feed using MySQLi? Converting from ASP/MSSQL.

I've recently converted a site from Classic ASP to PHP and one of the features they had was an RSS feed from the news table in their MSSQL database table. I attach the script we were previously using.

We're now using a MySQL table and MySQLi on the site. How easy is it to create a PHP/MySQLi version of this?

Thank you.
NJ

It looks like a recordset loop creating tags... you should be able to do that with the recordset and repeated region server behaviors.

It looks like it also strips the html out of the content, which php can do with strip_tags() and encodes special characters after that which you could use htmlentities() for.

Then you can use the php date() function to get the pieces of the date that it uses in the xml.

We could do this in a premier support ticket if you need more help.

Please see the attached which works lovely in Firefox but looks like a nightmare in IE. Why is that?

Please post a url where I can view it.

It's Microsoft Edge that's not reading it properly:
http://www.gallowayfisheriestrust.org/rss-fisheries-trust-news.php

Sorry, forgot to post a link.
NJ

Microsoft Edge doesn't have an RSS feed reading feature. It isn't a problem with your page.