Display Part Of A New Post?

<?php $recent = new WP_Query(“cat=1&showposts=3“);

@dressedinvalue: I guess it shouldnt be restricted to category 1.

I would try this …

<div class="featured">
<?php
global $wpdb;
$sql = 'SELECT ID,post_title FROM '.$wpdb->posts.' WHERE post_password="" AND post_status="publish" AND post_type="post" ORDER BY post_modified_gmt DESC LIMIT 3';
$result = $wpdb->get_results($sql);
foreach($result as $row){
?>
<h2><a href="<?php echo get_permalink($row->ID)" rel="bookmark"><?php echo $row->post_title ?></a></h2>
<?php } ?>
</div>

I didn’t test this!
It should show the 3 most recent posts that aren’t password protected.
Maybe there is another way, than calling $wpdb directly.

ixi, i tried yours and its saying

Parse error: syntax error, unexpected T_CONSTANT_ENCAPSED_STRING, expecting ‘,’ or ‘;’

also, how can i have it only show part? like when i did what dresse said, it showed the whole thing

Ohh, whoops! I overlooked that part.

@belgin fish let us know if that code works.

dresse, your works, its just it displays the whole post, how can i just display a little bit of it

Oops … yea, my bad. Fixed it.
The 2nd thing .. how much you wanna show of the post. The first x characters, the first x words?
My code displays the first 250 chars. But this is just an example.
Its the quick an dirty way. All HTML tags are removed. If you have a link or an image in the first 250 chars, it will not be displayed.

<div class="featured">
<?php
global $wpdb;
$sql = 'SELECT ID,post_title, post_content FROM '.$wpdb->posts.' WHERE post_password="" AND post_status="publish" AND post_type="post" ORDER BY post_date_gmt DESC LIMIT 3';
$result = $wpdb->get_results($sql);
foreach($result as $row){
?>
<h2><a href="<?php echo get_permalink($row->ID);?>" rel="bookmark"><?php echo $row->post_title;?></a></h2>
<?php echo substr(strip_tags($row->post_content), 0, 250 );?>
<?php }?>
</div>

nobody knows?

@belginfish, did you try ixiter’s code?

ok, thanks guys it works now, lol sorry i hadnt seen your second post :p