shortyr19

Alright, I got it figured out. It seems the ? thing had something to do with an older version of the K2 Theme. The new one works fine.

For reference, this is the code that I am using:


<?php
require_once("blog/wp-config.php"); // Change this for your path to wp-config.php file

$sql = 'SELECT wp_posts.ID, wp_posts.post_title, wp_posts.post_content, wp_posts.post_date'
. ' FROM wp_post2cat INNER JOIN wp_posts ON wp_post2cat.post_id = wp_posts.ID'
. ' WHERE (((wp_post2cat.category_id)=3)) AND wp_posts.post_status= "publish"'
. ' ORDER BY wp_posts.post_date DESC LIMIT 10';

$result = mysql_query ($sql);

while ($news = mysql_fetch_array
($result, MYSQL_ASSOC)) {
echo "<h3>{$news['post_title']}</h3>
<p><i>{$news['post_date']}</i></p><p>";
echo apply_filters('the_content',$news['post_content']);
echo "</p></br>n";
}
?>

Very good. That got it to work. Thanks for the helpful replies.

Final piece of the puzzle then: All of my double spaces between sentences (made using the rich text editor) have a  and a single space rather than two spaces.

Any ideas?

To clarify: I want to apply the same formatting that the_content() gets in the regular WordPress Loop.

This is essentially what I had before. I am able to extract the data fine but it doesn’t format it correctly.