I have my site up with EE and a major part of it is a running display of Recent Posts on the Forum. (Thanks to the help of many here) I am using a SQL query to pull in the responses and display them on my EE template.
I have a problem I need to solve with this Recent Posts display. The SQL query returns raw unformatted data in the field “body” that includes html. So the display is filled with stuff like [Quote Author =“Jane Doe” Date = “12345678”] and [url=http_etc.]
Is there a way to parse “body” using pHp to read those tags and display exactly how the forum does? It seems I ought to be able to put some php from the forums module code in a template in order to do the same parsing that the forum form does of these tags. It would be a great help cause I am getting complaints from this daily from testers.
Any ideas how to approach this problem?