Tour dates - best approach - PHPBuilder Forums

Tour dates - best approach

jamiethehill

I am creating a website for a Queen Tribute band which has an admin section for them to enter their tour dates i.e. date/month/year. I have these in seperate database columns to make life easier.

My question is, what would be the easiest way to display the current and following month in the following format:

November 2003
Gig 1
Gig 2
Gig 3
Gig 4
etc...

December 2003
Gig 1
Gig 2
Gig 3
Gig 4
etc...

Click to view all dates

In December this would then show Dec and Jan dates etc..

Bearing in mind that there are dates before and after these two months in the database?

Many Thanks in advance

Krait

SELECT * FROM tour_data WHERE tour_month = MONTH(NOW()) AND tour_month = extract(MONTH FROM date_add(NOW(), INTERVAL '1' YEAR_MONTH)) AND (tour_year = (YEAR(NOW()) OR tour_year = extract(YEAR FROM date_add(NOW(), INTERVAL '1' YEAR_MONTH)));

A bit clumsy, but should work, I guess.

jamiethehill

Thanks

How could I get it listed the way I want it though:

Month Year
Date - Venue
Date - Venue
Date - Venue

bigswifty

you need a while loop to put the results into a html table

print "<table><tr><td>$currentmonth</td><td>$currentyear></td></tr>";

while(mysql_fetch_array($result)){
$date = mysql_result($result, "date");
$venue = mysql_result($result, "venue");
print("<tr><td>$date</td><td>$venue</td><tr> ");
}

print "</table>";

of course you will have to modify it to conform to your data and display exactaly the way you want it, but thats the basic idea

you will also need a section to determine the month
an if loop somewhere should do the trick to place the data under the proper table header, you might just forget the this month and next month stuff and just list everything, its a lot easier