Jump to content

Gig Schedule question


one bad monkey

Recommended Posts

My apologies if this has been answered before; I haven't found it.

 

I'm working on making a gig schedule for my site, where I can just add everything into mysql and have it show up. That part I have taken care of, and it works just fine. Here's what I'm stumped at.

 

I would like the php to move any of the performances that have already happened to a spot below the "Upcoming Performances" section, entitled "Previous Performances." This is the code thus far.

 

$sql = mysql_query ("SELECT * FROM `Schedule` ORDER BY day ASC") or die (mysql_error ());

 

echo "<table width=100%>" . "<br>" .

"<tr><td width=15%>Date</td>" .

"<td width=10%>Time</td>" .

"<td width=20%>Venue</td>" .

"<td width=20%>Performance</td>" .

"<td width=10%>Price</td>" .

"<td width=25%>Additional Information</td></tr>";

 

while ($row = mysql_fetch_assoc ($sql)) {

 

echo "<tr><td>" . date("D, F j", strtotime($row['day'])) . "</td>" .

"<td>" . $row['time'] . "</td>" .

"<td>" . $row['venue'] . "</td>" .

"<td>" . $row['show'] . "</td>" .

"<td>" . $row['price'] . "</td>" .

"<td>" . $row['info'] . "</td></tr>";

 

}

 

echo "</table>";

 

My thought is that I need to add in the line for the mysql_query something to the effect of WHERE day >= "current date" for the first one, and then repeat this code below it, with a WHERE day < "current date" function. Am I on the right path? Any comments are appreciated.

Link to comment
Share on other sites

The way taquitosensei reccommended is a preferred method, as it only requires 1 SQL query and 1 loop

I would disagree!

For simplicity a second query is not expensive.

Fill your tables into the appropriate places:

<?php
// future gigs
$result = mysql_query("SELECT * FROM Schedule WHERE FROM_UNIXTIME(day) >= CURDATE() ORDER BY day ASC");
while($row = mysql_fetch_assoc($result)) {

}

// past gigs
$result = mysql_query("SELECT * FROM Schedule WHERE FROM_UNIXTIME(day) < CURDATE() ORDER BY day ASC");
while($row = mysql_fetch_assoc($result)) {

}
?>

Link to comment
Share on other sites

in your php you could do  as long your day field is a datetime

if(strtotime($row['day']) >= strtotime(date("Y-m-d H:i:s")))
{
// html for upcoming performances

}
else
{
// html for previous 
}

As the requirement is to have past gigs in a separate table / section adding html in this control structure would not work as you are looping through the entire result set. If using 1 query you would build a multidimensional associated array i.e $gigs['future'], $gigs['past']. Then loop each array into its own section. Using 2 queries is not expensive and a simpler implementation.
Link to comment
Share on other sites

This thread is more than a year old. Please don't revive it unless you have something important to add.

Join the conversation

You can post now and register later. If you have an account, sign in now to post with your account.

Guest
Reply to this topic...

×   Pasted as rich text.   Restore formatting

  Only 75 emoji are allowed.

×   Your link has been automatically embedded.   Display as a link instead

×   Your previous content has been restored.   Clear editor

×   You cannot paste images directly. Upload or insert images from URL.

×
×
  • Create New...

Important Information

We have placed cookies on your device to help make this website better. You can adjust your cookie settings, otherwise we'll assume you're okay to continue.