Categorizing posts by date

[assassingod]

I've had a quick try (and seeing as i'm not sure how your table is setup) and i've got a little way but sadly it's not the most efficient way - but i hope you can work around it (or someone posts an easier way to do it)

PHP Code:

<?php
 //connect to the DB
 $conn = mysql_connect("localhost","root","")
  or die("Couldnt connect"); //failed?
 $rs = mysql_select_db("postdate", $conn)
  or die("Couldnt select DB!"); // failed?
 
     //run query
     $querytime = mysql_query("SELECT * FROM post WHERE postdate = '1st Jan'");
 
     // loop results
     while($posted = mysql_fetch_array($querytime))
     {
          $poststuff .= "-$posted[post]<br />";
     }
 
     //run query again
     $querytime1 = mysql_query("SELECT * FROM post WHERE postdate = '4th Jan'");
 
     // loop results again
     while($posted1 = mysql_fetch_array($querytime1))
     {
          $poststuff2 .= "-$posted1[post]<br />";
     }
 
//echo crappy results, i had to hardcode in the dates sadly
echo("1st Jan <br />$poststuff<br />4th Jan<br /> $poststuff2 ");
?>