display events under specified month....

[searls03]

Ok, so I have made 12 columns in mysql for each month.........I will have an event manager page that you can select each month that the event will take place in 0 is false 1 is true.........so I need to know how I can edit this code so that if the current month equals whatever month is checked, it will display..........is there a way to do this????????or would I need to use a date format instead of varchar and use a format such as yyyy-mm-dd and value = 0000/mm/00 so that only the month will display and then it could equal current month?

<?php


// if no id is specified, list the available articles
if(!isset($_GET['eventid']))
{

   $query = "SELECT eventid, event, startdate, enddate FROM Registration ORDER BY eventid";
   $result = mysql_query($query) or die('Error : ' . mysql_error());
  
   // create the article list

   while($row = mysql_fetch_array($result, MYSQL_NUM))
   {
      list($eventid, $event, $startdate, $enddate) = $row;
  
      $as .= "<p><a href=\"viewevent.php?eventid=$eventid\">$startdate - $enddate --- $event</a></p>\r\n";
   }


   $Events = 'Events';
} else {
   // get the article info from database
     $query = "SELECT event, description, startdate, enddate, location, subevent1, subevent2, subevent3, subevent4, subevent5, subevent6, subevent7, subevent8, price1, price2, price3, price4, price5, price6, price7, price8 FROM Registration WHERE eventid=".$_GET['eventid'];
   $result = mysql_query($query) or die('Error : ' . mysql_error());
   $row = mysql_fetch_array($result, MYSQL_ASSOC);
   $startdate = $row['startdate'];
      $enddate = $row['enddate'];
     $location = $row['location'];
   $description = $row['description'];
$event= $row["event"];
$subevent1 = $row['subevent1'];
$subevent2 = $row['subevent2'];
$subevent3 = $row['subevent3'];
$subevent4 = $row['subevent4'];
$subevent5 = $row['subevent5'];
$subevent6 = $row['subevent6'];
$subevent7 = $row['subevent7'];
$subevent8 = $row['subevent8'];
$title1 = $row['title1'];
$title2 = $row['title2'];
$title3 = $row['title3'];
$title4 = $row['title4'];
$title5 = $row['title5'];
$title6 = $row['title6'];
$title7 = $row['title7'];
$title8 = $row['title8'];
$price1 = $row['price1'];
$price2 = $row['price2'];
$price3 = $row['price3'];
$price4 = $row['price4'];
$price5 = $row['price5'];
$price6 = $row['price6'];
$price7 = $row['price7'];
$price8 = $row['price8'];
$date1 = $row['date1'];
$date2 = $row['date2'];
$date3 = $row['date3'];
$date4 = $row['date4'];
$date5 = $row['date5'];
$date6 = $row['date6'];
$date7 = $row['date7'];
$date8 = $row['date8'];
}
?>

<table width="410" border="1" cellspacing="0" cellpadding="0">
    <tr>
      <td width="339" bgcolor="#999999" scope="col">EVENTS</td>
    </tr>
    <tr>
      <td class="afasd"><?php echo date("F",strtotime("-0 month")); ?></td>
    </tr>
    <tr>
      <td><?php echo $as; ?></td>
    </tr>
    <tr>
      <td class="adfaf"><?php echo date("F",strtotime("+1 month")); ?></td>
    </tr>
    <tr>
      <td><?php echo $as; ?></td>
    </tr>
    <tr>
      <td class="jasdfjs"><?php echo date("F",strtotime("+2 month")); ?></td>
    </tr>
    <tr>
      <td><?php echo $as; ?></td>
    </tr>
  </table>

 

does this make sense?

[searls03]

would this be a good way to do it?  or no.......... :confused: :confused: :confused: :confused: :confused: :confused: :confused:

[sunfighter]

If I read this right you have 12 radio buttons that will send the name of a month via $_GET and you want to check that to the current month to control what your displaying.  Use this IF ($_GET['month'] == strftime('%B')). Note first letter of month is capitalized. So this month is March.