I have a number of external SQL tables that have data in exactly the way I want and I would like to use them to populate various wordpress posts with shortcodes.
The problem is that I don't understand how wordpress 'filters' text in get_content() so that the proper
IOW: I have a proper WP Post and I display the contents on a page it auto-magically includes
tags. If I copy that text to my external table and then pull that field into the same WP post using
$result = $wpdb->get_col( "SELECT my_text FROM my_songs WHERE id = '" . $song_id . "'" );
...the results has none of the
<p>s unless I explicitly add them to the text.
How can I take $result above and 'format' it so that it matches the same text from a WP Post using