Perfect Jason... But I went about it a tad differently...
I wrote this in the recordset above the <html>
SELECT * FROM ClassDetails WHERE NOW() < `CDLastTime`
Therefore I'm only returning the classes that are available...
The problem I'm having now is formatting the output as m/d/Y... Currently I'm using the DATE as the structure of the Row - and it returns yyyy-mm-dd which the manager of the project doesn't want...
When I use the mySQL function DATE_FORMAT() I get the perfect results, but, it removes my additional dynamic rows...
SELECT DATE_FORMAT( CDDate, '%m/%d/%Y' ) AS formatted_date FROM ClassDetails
So... Do I need to add a temp table to output the date to? If I duplicate the recordset and put the DATE_FORMAT() SQL code in it ABOVE the current RS it returns nothing, BELOW it returns the day only...
I've tried pimping the echo $row_ClassDetails['CDDate'] in the loop and have gotten 12/31/1969 returned over how many records there are or nothing...
<?php
do {
?>
<option value="<?php echo $row_ClassDetails['CDID']; ?>" ><?php echo $row_ClassDetails['CDDate']; ?> <?php echo $row_ClassDetails['CDName']; ?></option>
<?php
} while ($row_ClassDetails = mysql_fetch_assoc($ClassDetails));
?>
I know I'm doing something wrong, I just can't figure it out...
Would it be best to add the DATE_FORMAT() to a recordset above the <html> or write out the php???
I'm lost...