[RESOLVED] how to show my blog entries like this?

[jasondavis]

I use the following query to build a blog page for a user, it just gets all blogs post from a User

What I am wanting to do though is make the main blog page that this is on, only show blogs for the month, I know I can just modify the above to show only for the current month but then I will have links for other months

What I am having trouble with is I would like to show the date in a row and all post for that DAY, then show the next day and all post for that day under it, to understand you would have to see this image

http://img529.imageshack.us/img529/2381/blogsq.jpg

So instead of my current set up that shows like this

July
blog post
blog post
blog post
blog post
blog post
blog post
blog post
blog post

it should show like this instead

July
July 7th
blog post
blog post
blog post
July 4th
blog post
blog post
July 3rd
blog post
blog post
July 1st
blog post

here is my current Query please help
SELECT * FROM friend_blog WHERE userid='1' ORDER BY autoid DESC limit 0,15

[ixalmida]

Change this part of query (using whatever your date field is named): "ORDER BY blog_date, autoid"

Then detect when the date changes using code:

if($row['blog_date'] != $previous_date)
  {
  // Create new heading here!
  $previous_date = $row['blog_date'];
  }

[jasondavis]

awsome ill give it a try thanks

[jasondavis]

just to confirm that worked perfectly, amazing how sometimes something can be so simple