I have built a site with an events diary.
On the home page I display the next 4 events by selecting 4 recording from start_date ASC.
SELECT id, start_date, end_date, date_format(`start_date`,'%D %M %Y') as `formattedDate`, end_time, title, `description`, venue, link, icon, image, image_alignment, status FROM eventer_events ORDER BY start_date ASC
<span class="purpletext"><?php echo $row_latestnews['title']; ?></span><br>
<span class="venuefeed"><?php echo $row_latestnews['venue']; ?></span><br>
<?php echo $row_latestnews['formattedDate']; ?> </div>
<?php } while ($row_latestnews = mysql_fetch_assoc($latestnews)); ?>
The problem is that dates that have past will show at the top of the list. I need to not display an event that has already past, any ideas how to do this?
The date value is in the database as varchar(10) by the way...