Just display the month?

[Jack Franklin]

I've been working on adding a breadcrumb to my site - you can see it in action right now if you check it out. At the moment it is 'Home>Category>Post'. How can I find out the month of the post, so I can have it like: 'Home>Month>Category>Post'

Thanks, and I apologise for yet another question! This is the PHP code that selects the stuff from the database and displays the bread crumb.

PHP: Select all

$display_posts = @mysql_query("SELECT contentid, contenttitle, contentintro, content, author, category, views, date_format(date, '%M %D, %Y') AS date FROM content WHERE contentid='$contentid'");
if(!$display_posts) {
echo '<h4>Error Displaying Comments.' . mysql_error() . '</h4>';
}
while ($posts = mysql_fetch_array($display_posts)) {
$contentid = $posts['contentid'];
$contenttitle = $posts['contenttitle'];
$contentintro = $posts['contentintro'];
$content = $posts['content'];
$author = $posts['author'];
$category = $posts['category'];
$date = $posts['date'];
//display
echo '<p id="youareheretext">You are here: <span id="youarehere"><a href="index.php">Home</a> :: <a href="category.php?category.php?category=' . $category . '">' . $category . '</a> :: <a href="single.php?contentid=' . $contentid . '">' . $contenttitle . '</a></span></p>'; 

I think it will use

PHP: Select all

MONTH(date) 

somewhere, but I'm not sure where.

Thanks,

Jack

[Marc]

Just change:
date_format(date, '%M %D, %Y') AS date to date_format(date, '%M') AS date..

Will that not work?

[Jack Franklin]

Yes, but I want to display the Main date (22nd January 2008) AND use the month on the same page. If you look here: http://jackfranklin.co.uk/single.php?contentid=29 You can see the breadcrumb at the top, I want the Month to display here, but you can also see the date next to the Post title. I need to display both. Could I do this?

PHP: Select all

display_posts = @mysql_query("SELECT contentid, contenttitle, contentintro, content, author, category, views, date_format(date, '%M %D, %Y') AS date, date_format(date, '%M') AS month 

[Marc]

try it, it might

[Jack Franklin]

Will do and I shall get back to ya

[Jack Franklin]

WORKED ! Check out http://www.jackfranklin.co.uk/single.php?contentid=20 to see the result, in the breadcrumb bit. If you would like to see the code just ask.

[Marc]

Good work!