srhino Posted January 10, 2008 Share Posted January 10, 2008 I need help figuring this out. I have a site that on the main page events are listed in order by dates...when people upload an event the put in the month...day...year. I have them seperated in mysql database as $month $day $year. I want to create a link on my side nav bar for each month ex January February March...etc Is there a way when you click on January that it will pull all the tournaments from jan. The site is set up with an index page that includes maincontacts.inc page that the events display on. Thanks Quote Link to comment Share on other sites More sharing options...
nikefido Posted January 10, 2008 Share Posted January 10, 2008 the link URL will have to use $_GET data that a .php script will then grab and use to run a database query. <a href="www.mypage.com/getMonthData.php?month=January>January</a> <?php //getMonthData.php $month = $_GET['month']; //query database //select * from event where month= '{$month}' //something like that ?> Quote Link to comment Share on other sites More sharing options...
srhino Posted January 10, 2008 Author Share Posted January 10, 2008 Got it ! Thanks Quote Link to comment Share on other sites More sharing options...
Recommended Posts
Join the conversation
You can post now and register later. If you have an account, sign in now to post with your account.