Date Matching

[NZ_Kiwis]

Hi,

I have a table which has a comp_id, season, group_id (auto increase) and a date (which is set by a user)

Results of this can be seen at (i've only used comp_id 17)
http://www.rugbyleaguenz.com/test.php

What I want to do is do write a code which will get today's date (easy) but then find out which date has passed and what the next date is...

IE: If today's date was 2005-04-10. It would find that the correct group_id would be 86 because group_id 80 has been and gone ..

any ideas???

[devinemke]

SELECT * FROM table WHERE date >= CURDATE()

[NZ_Kiwi]

Originally posted by devinemke

SELECT * FROM table WHERE date >= CURDATE()

[/B]

but that would fine all date past today??? or could i limit it to one?

[devinemke]

SELECT * FROM table WHERE date >= CURDATE() LIMIT 1

[NZ_Kiwi]

This works very very well but i only shows one record.. i want it to loop for all my comp id's

<?php
mysql_connect (localhost, kk, kk);
mysql_select_db (kk);
$result = mysql_query ("SELECT * From results_comp_run where season = '2005'");
$row = mysql_fetch_array($result);
$comp_run_id = $row[comp_run_id];
$latest_group_id = $row[latest_group_id];


$result3 = mysql_query ("SELECT * FROM results_group WHERE group_date_new >= CURDATE() LIMIT 5");
while($row3 = mysql_fetch_array($result3)) {

echo "group is $row3[group_id] and is from comp id $row3[comp_run_id] and the date is $row3[group_date_new]";

$nowtime = strtotime("now");
$nowtime2 = date ('l', $nowtime);

if ($nowtime2 == 'Wednesday') {
echo $nowtime2;
}
?>
<p>
<?php
}
?>