Speech-mark turns to " in result of a query

[sparklywater]

Thanks for your reply, I've just tried that but it still shows &quo... in the results.

--------------- Added [DATE]1220440916[/DATE] at [TIME]1220440916[/TIME] ---------------

This is the query which fetches the latest posts:

PHP Code:

// query to get the last posts
    $query = $vbulletin->db->query_read_slave("
        SELECT
            post.postid, post.pagetext as pagetext, post.userid, post.username, post.dateline AS date,
            thread.forumid, thread.title as thread_title, thread.threadid,
            forum.forumid, forum.title as forum_title, thread.replycount as replies, thread.views as views
        FROM " . TABLE_PREFIX . "thread AS thread
        INNER JOIN " . TABLE_PREFIX . "post AS post on (post.postid = thread.lastpostid)
        INNER JOIN " . TABLE_PREFIX . "forum AS forum on (thread.forumid = forum.forumid)
        WHERE post.visible = '1' AND thread.visible = '1' AND open = '1' AND $platest_and AND $platest_and_1
        ORDER BY postid DESC
        LIMIT $plimit"
    );