searls03 Posted April 26, 2013 Share Posted April 26, 2013 hello all, I have been working on a calendar system for someone, and they were using one date events....now they want events with a range. I have this code working to select one date $result = mysql_query("SELECT * FROM classes where date='".$m1."/".sprintf ("%02u", $d)."/".$year."'");....this is fine, don't critique it please. My data base now has a start date and an end date fields in them. I need to know how I can pull the data if the date that I want to display falls inbetween or on those startdate and enddate field. so for example, May 1st through the 5th is an event called test i would like it to pull data and then display it similar to this: 1-test 2-test 3-test 4-test 5-test the numbers being the May "date". can anyone help me with this? Quote Link to comment https://forums.phpfreaks.com/topic/277321-select-a-date-range/ Share on other sites More sharing options...
Jessica Posted April 26, 2013 Share Posted April 26, 2013 Use BETWEEN. Moving this to the MySQL forum. Quote Link to comment https://forums.phpfreaks.com/topic/277321-select-a-date-range/#findComment-1426681 Share on other sites More sharing options...
requinix Posted April 26, 2013 Share Posted April 26, 2013 (edited) That "date" column is an actual DATE-type column, right? Edited April 26, 2013 by requinix Quote Link to comment https://forums.phpfreaks.com/topic/277321-select-a-date-range/#findComment-1426685 Share on other sites More sharing options...
searls03 Posted April 26, 2013 Author Share Posted April 26, 2013 Actually that fate won't be there anymore, the "date" for reference will be created via php. Quote Link to comment https://forums.phpfreaks.com/topic/277321-select-a-date-range/#findComment-1426686 Share on other sites More sharing options...
Barand Posted April 26, 2013 Share Posted April 26, 2013 So you are trying to search by date on a database table that has no date field? Quote Link to comment https://forums.phpfreaks.com/topic/277321-select-a-date-range/#findComment-1426748 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.