I have a website that is about live local music. <a href="http://www.fingerlakeslive.com" target="_blank">fingerlakeslive</a><br /><br />Right now I am using phpbb with the mycalendar addon to take care of users inputting upcoming shows. What I am trying to do is make an index page <a href="http://www.fingerlakeslive.com/beta.php" target="_blank">see here</a><br />that pulls these events out and displays them on a side bar. I have made some progress, but have one question about my select query.<br /><br />current select query<br /><!--c1--><div class='codetop'>CODE</div><div class='codemain'><!--ec1-->$result = @mysql_query('SELECT * FROM phpbb_mycalendar,phpbb_topics WHERE phpbb_mycalendar.topic_id=phpbb_topics.topic_id ORDER BY cal_date LIMIT 10');<!--c2--></div><!--ec2--><br /><br />This works and displays what you see on my index page. But you will notice that it is displaying events that have already happened. How do I select only upcoming dates?<br /><br />do I use CURDATE() somehow in my query? I am somewhat new to php/mysql so take it easy on me. lol<br />thanks<!--content-->
Sorry, I don纾
Sorry, I don纾