PHP code for latest post title?

if all you want is the title of the latest post and i assume it linking to it aswell use the following

<?php
foreach($wpdb->get_results("SELECT ID,post_title FROM wp_posts WHERE post_status = 'publish' ORDER BY post_date DESC LIMIT 0,1") as $p){
echo "<h1><a href="".get_bloginfo('siteurl')."/?p=".$p->ID."">".$p->post_title."</a></h1>";
}
?>

This “Should” just pull out the last published post and display it in a H1 with a link to the post.

Its quick and dirty and ive not tested it so dont shout if it dont work ??

just tested it to make sure it works and it does ?? on a default WP install at least

Hmm, I get an error with it:

Parse error: syntax error, unexpected T_CONSTANT_ENCAPSED_STRING, expecting ‘,’ or ‘;’ in /home/.kathlee/hjo3/hjo3.net/wordpress/wp-content/plugins/exec-php.php(45) : eval()’d code on line 3

Any idea why? Again, my php skills are quite lacking. Thanks ??

Erm, i guess this is cos your using it thru exec-php – i dont use that so have no way of knowing whats wrong with it.

If you just create a page template and use that inside the pages template it will work

Erm, change:

<?php
foreach($wpdb->get_results("SELECT ID,post_title FROM wp_posts WHERE post_status = 'publish' ORDER BY post_date DESC LIMIT 0,1") as $p){
echo "<h1><a href="".get_bloginfo('siteurl')."/?p=".$p->ID."">".$p->post_title."</a></h1>";
}
?>

to

<?php
foreach($wpdb->get_results("SELECT ID,post_title FROM wp_posts WHERE post_status = 'publish' ORDER BY post_date DESC LIMIT 0,1") as $p){
echo "<h1><a href=".get_bloginfo('siteurl')."/?p=".$p->ID.">".$p->post_title."</a></h1>";
}
?>

There were two extra quotation marks in the a href part. Anyways, thanks for posting the code phunky, I was stumped on this for a while. Using it on my site right now ??