next closest date?

yellowzm

I am very new to php and i would appreciate a little help with something. I would like to keep this as simple as possible. I am designing a website for my kids wrestling team and on the home page i have a simple php set up to display one event from the events table of the mysql db. Currently it is set to ORDER BY eventdate, which is a DATE field of the db. can someone please help me figure out how to display the next upcoming date rather than the highest date in the db.

The code I am using is as follows

<?php
   mysql_connect("mysql","user","password");
   mysql_select_db("braves");
   $query ="SELECT eventtitle, eventbody, eventtime, eventsub, weighin, directions,";
   $query.=" DATE_FORMAT(eventdate, '%M %d, %Y') AS date";
   $query.=" FROM events ORDER BY eventdate DESC LIMIT 1";
   $result=mysql_query($query);
   while (list($eventtitle,$eventbody,$eventtime,$eventsub,$weighin,$directions,$eventdate,) = 
    mysql_fetch_row($result)) {
       echo "<dt><b><h1>$eventtitle </h1></b></dt>";
	   echo "<dd><b><h2>$eventsub </h2></b></dd>";
	   echo "<dd><b><h3>($eventdate)</h3></b></dd>";
	   echo "<dd><b><h3>$eventtime</h3></b></dd>";
       echo "<dd><b><h4>$weighin</h4></b></dd>";
	   echo "<dd>&nbsp;</dd>";
       echo "<dd>$eventbody</dd>";
	   echo "<dd>&nbsp;</dd>";
       echo "<dd>$directions</dd>";
	   echo "<dd>&nbsp;</dd>";
	   echo "<dd>&nbsp;</dd>";
   }
 ?>

I'm sure that the code above is not the best it could be but as I said I am very new to this, Thanks in advance for any help you can give.

~Zach

Weedpacket

How do you define the next upcoming date? Obviously, if it's not in the database then you will have to get it from somewhere else.

php_dev

If you are simply looking for the next most recent event, that can be added into your query.

<?php
$sql="SELECT eventtitle, eventbody, eventtime, eventsub, weighin, directions
FROM  FROM events 
WHERE events_date>CURDATE()
LIMIT 1";
?>

This should return one record, the next event in the database (but not the same day's event).

Hope this helps,
php_dev

yellowzm

I appreciate the help, I figured out what I needed to do to get it right.

<?php

   mysql_connect("mysql","user","pass");
   mysql_select_db("braves");
   $today = date('Y-m-d');
   $query ="SELECT eventtitle, eventbody, eventtime, eventsub, weighin, directions,";
   $query.=" DATE_FORMAT(eventdate, '%M %d, %Y') AS date"; 
   $query.=" FROM events WHERE eventdate >= '$today' ORDER BY eventdate ASC LIMIT 5";   

   $result=mysql_query($query);
   while (list($eventtitle,$eventbody,$eventtime,$eventsub,$weighin,$directions,$eventdate,) = 
    mysql_fetch_row($result)) {
       echo "<dt><b><h1>$eventtitle </h1></b></dt>";
       echo "<dd><b><h2>$eventsub </h2></b></dd>";
       echo "<dd><b><h3>($eventdate)</h3></b></dd>";
       echo "<dd><b><h3>$eventtime</h3></b></dd>";
       echo "<dd><b><h4>$weighin</h4></b></dd>";
       echo "<dd>&nbsp;</dd>";
       echo "<dd>$eventbody</dd>";
       echo "<dd>&nbsp;</dd>";
       echo "<dd>$directions</dd>";
    }