Displaying Closest Date In The Future

[Hilly_2004]

Hi guys,

 

I've searched through the forums, and haven't found anything that might help me.

 

I have a field in a table called "Fixture_Date" with a 'date' type e.g. YYYY-MM-DD, does anyone know a select query that will select the next upcoming event based on the current date?

 

Thanks for any help you can throw my way!

[AndyB]

SELECT whatever_fields from table_name WHERE Fixture_Date>'$today' ORDER by Fixture_Date ASC LIMIT 1

 

$today = date("Y-m-d") of course

[Hilly_2004]

Cheers!

 

Works a treat. For anyone else wondering my script looks like:

 

<?php

//Load all fixtures from the database and then ORDER them by Date (nearest date displayed first)

$today = date("Y-m-d");

$result = mysql_query("SELECT * FROM tbl_fixtures WHERE Fixture_Date > '$today' ORDER BY Fixture_Date ASC LIMIT 1", $connect);

//Loop and Get All The Fixtures From The Database

while($myrow = mysql_fetch_array($result))
{

//Prints Results

echo "<p class=\"ColumnTitle\">";		   
echo $myrow['Opponent'];
echo "</p>";
}

?>				

[fenway]

Replace '$today' with NOW() or CURDATE() as applicable.