GIG dates like 2006-05-26, 2006-05-27, to all apprear under month headings

[bradleyy]

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]

[shocker-z]

[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

[shortj75]

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

[bradleyy]

[!--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?

[bradleyy]

[!--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?

[shocker-z]

<?
$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 :)

[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]