I have several blogs, and I am trying to create a table with all recent posts from all my blogs at the bottom of each page.
I am quering the db directly for post names and urls, and found that both entries are in the table wp_posts, under post_title (for title) and guid (for url).
My problem is that an original post title which was:
Win $1000 Dollars!
Appears in in post_title as:
win-1000-dollars
And when I remove dashes (-) and capitalize the first letter I only get:
Win 1000 dollars
Is there a way to convert it appear as the original?