Query dates starting from today

machine

Im trying to query a list of dates. I need to show only dates starting from today and ignoring and past dates. I've searched the boards to no luck. Grateful for any help.
Thanks from another newbie in trouble.

<?php

ini_set ('display_errors', 1);
error_reporting (E_ALL & ~E_NOTICE);

if ($dbc = @mysql_connect ('*****', '*****', '*****')) {


if (!@mysql_select_db ('sr_admin')) {
    die ('<p>Could not select the database because: <b>' . mysql_error() . '</b></p>'); }

} else {
    die ('<p>Could not connect to MySQL because: <b>' . mysql_error() . 
'</b></p>');
}

$query = 'SELECT * FROM show_dates ORDER BY show_date ASC';

if ($r = mysql_query ($query)) {

while ($row = mysql_fetch_array ($r)) {

    $show_date = date("m/d/Y", strtotime( $row['show_date'] ) );

    print "<p><tr><td>$show_date</td>
    <td>{$row['show_city']}, {$row['show_state']}</td>
    <td> {$row['show_venue']}</td></tr></p>
    \n";
}

} else {
    die ('<p>Could not retrieve the data because: <b>' . mysql_error() . 
"</b>. The query was $query.</p>");
}

mysql_close();

?>

NogDog

SELECT * FROM show_dates WHERE show_date >= CURDATE() ORDER BY show_date

(This assumes that show_dates is defined as a date type column.)

machine

Wow. Thanks for the quick reply. It worked perfect. OK, one more question, I would like to have a message if there are no dates past today. eg "There are no upcoming dates". Much thanks.

bradgrafelman

I would recommend you list the column names that you are going to be working with as opposed to "SELECT *" as this helps conserve resources used - memory, CPU, hard drive seek time, etc.

You can easily detect if MySQL didn't find any rows by using [man]mysql_num_rows/man like so:

if(mysql_num_rows($r)) {
    echo 'Error: Nothing posted for today yet.';
} else {
    // found rows, do whatever you want w/ them...
}