bradleyy

[!--quoteo(post=354951:date=Mar 14 2006, 05:13 PM:name=shocker-z)--][div class=\'quotetop\']QUOTE(shocker-z @ Mar 14 2006, 05:13 PM) [snapback]354951[/snapback][/div][div class=\'quotemain\'][!--quotec--] <? $today = date("Y-m-d"); $result = mysql_query("SELECT * FROM gigs WHERE date >= '$today' ORDER BY date ASC"); $month=1; while($myrow = mysql_fetch_assoc($result)) { $date = $myrow['date']; list($year, $month, $day) = split("-", $date); $monthname=date('M', mktime(0, 0, 0, $month, $day, $year)); $date = date('d', mktime(0, 0, 0, $month, $day, $year)); if ($year != $lastyear) { echo("<B>Year $year</B><Br>"); } if ($month != $lastmonth) { echo("<B>$monthname</B><Br>"); } ?> <? echo $date; ?> - <a href="?pg=gi&id=<? echo $myrow[id]; ?>"><? echo $myrow['headline']; ?></a></b><br> <? $lastmonth=$month; $lastyear=$year; } ?> that should show year, month and then the day of each month :) [/quote] you are so awesome :p i'm at work now, can't fix it till tomorrow, so i'll update with solved etc tomorrow! BTW - i gave the wrong URL in 1st post - [a href=\"http://www.josephswell.co.uk/x/\" target=\"_blank\"]http://www.josephswell.co.uk/x/[/a]

[!--quoteo(post=354928:date=Mar 14 2006, 04:11 PM:name=shortj75)--][div class=\'quotetop\']QUOTE(shortj75 @ Mar 14 2006, 04:11 PM) [snapback]354928[/snapback][/div][div class=\'quotemain\'][!--quotec--] ok try this <? $today = date("Y-m-d"); $result = mysql_query("SELECT * FROM gigs WHERE date='$today' ORDER BY date ASC"); while($myrow = mysql_fetch_array($result)) { $date = $myrow['date']; list($year, $month, $day) = split("-", $date); $date = date('M d, Y', mktime(0, 0, 0, $month, $day, $year)); echo "$date - <a href="?pg=gi&id= $myrow[id]>$myrow[headline]</a></b><br>"; } ?> hopfully this helps [/quote] thanks for having a look, but i want to make a big list, won't that one just show one listing?

[!--quoteo(post=354927:date=Mar 14 2006, 04:09 PM:name=shocker-z)--][div class=\'quotetop\']QUOTE(shocker-z @ Mar 14 2006, 04:09 PM) [snapback]354927[/snapback][/div][div class=\'quotemain\'][!--quotec--] [code] <? $today = date("Y-m-d"); $result = mysql_query("SELECT * FROM gigs WHERE date >= '$today' ORDER BY date ASC"); $month=1;     while($myrow = mysql_fetch_assoc($result))     {     $date = $myrow['date'];     list($year, $month, $day) = split("-", $date);     $date = date('M d, Y', mktime(0, 0, 0, $month, $day, $year));     if ($month != $lastmonth) {         echo("<B>$month</B><Br>");     } ?> <? echo $date; ?> - <a href="?pg=gi&id=<? echo $myrow[id]; ?>"><? echo $myrow['headline']; ?></a></b><br> <? $lastmonth=$month;     } ?> [/code] Then all you need to do is take the month out of the date :) i think :P [/quote] Dude! it looks like you've pretty much helped me out! go here: [a href=\"http://josephswell.co.uk/x/?pg=g\" target=\"_blank\"]http://josephswell.co.uk/x/?pg=g[/a] how would i make it so instead of it saying 05 etc for month, May?

Hi! Basically the title says it all.. i am making a website for a music venue in Leeds, the UK. I am fine using PHP, and generally never have to get help anymore. However, this latest function i need is a little above me, and it seems tricky to Google and answer and also harder to find one in the books i have. SO, the gig dates, usually one for every night of the year, are stored in [b]2006-05-26[/b] for example. As you can see at [a href=\"http://www.josephswell.co.uk/?pg=g\" target=\"_blank\"]http://www.josephswell.co.uk/?pg=g[/a], i'm fine converting them to [b]May 26th, 2006[/b].. but what i need is a function to help me do this below.. [b]January[/b] Mon 1st [i]band name[/i] Tue 2nd [i]band name[/i] Wed 3rd [i]band name[/i] .... [b]February[/b] Mon 1st [i]band name[/i] Tue 2nd [i]band name[/i] Wed 3rd [i]band name[/i] .... I hope this makes sense! What i'll do, is post what i use at the moment and hopefully someone can link me to a page or give me a little help on how to do this! [code]<? $today = date("Y-m-d"); $result = mysql_query("SELECT * FROM gigs WHERE date >= '$today' ORDER BY date ASC");     while($myrow = mysql_fetch_assoc($result))     {     $date = $myrow['date'];     list($year, $month, $day) = split("-", $date);     $date = date('M d, Y', mktime(0, 0, 0, $month, $day, $year)); ?> <? echo $date; ?> - <a href="?pg=gi&id=<? echo $myrow[id]; ?>"><? echo $myrow['headline']; ?></a></b><br> <?     } ?>[/code]