Granny Annie

I'm way new at this and have taken over a band website after the designer skipped town. I understand what you are saying, but where do I find the date field? Is this where I enter the show dates to begin with? I have a pull down list for Month/Day/Year. I want shows to list with the month first, then day, then year. I'll try to find the code and copy it into a message.

The script below references a data base with shows from 2008 and 2009. It selects the next four sequential dates to list, but ignores the year. So I have shows from 2008 included. Suggestion? <?php $cur = date("m/d/y"); mysql_select_db("shows", $con); $s = mysql_query("SELECT * FROM live WHERE date >= '$cur' ORDER BY date LIMIT 0, 4"); while($r = mysql_fetch_array($s)) { echo $r['date'] . " <br> " . $r['place'] . " <br> " . $r['time']; echo "<br />"; echo "<br />";