Posts not Pages

[Kewne]

Hi,

Does anyone here kbow how to get the post not the pages in a wordpress dashboar?
This line of code:
$ArrResult = $wpdb->get_results("SELECT * FROM {$wpdb->posts} WHERE post_type = 'page' ");
and for the table I have something like this:
<td><?php echo $sampleResult->post_title ?></td
I thought this would get the posts, but it returns pages content, author, date. What I want to have is the posts not the pages...

Thank you in advance.

[pixelsoul]

Well, you're asking for it to return pages WHERE post_type = 'page'.

[Kewne]

ok thank you..I got it...