mondodru Posted October 22, 2003 Share Posted October 22, 2003 Hey Gang. I have a question for you. I am building a news archive, with a calendar. I have my database built to use a Unix timestamp, in the format: 0000-00-00 00:00:00. I want to link the dates on the calendar so that when the user clicks a link for one of the days, he will be directed to a page with all news articles from that day. My problem is, I have the dates loaded as varables, however, I don\'t want to specify a time. My current (none-working) query is as follows: $day = $_REQUEST[\'day\']; $month = $_REQUEST[\'month\']; $year = $_REQUEST[\'year\']; $combo_date = "$year-$month-$day"; echo "<p>Archive for $combo_date</p>"; $query = "SELECT * FROM bp_blog WHERE timestamp=\'$combo_date\'"; This of course doesn\'t work because the $combo_date does not include the time. Is there anyway I could make this work without specifying the time? Thanks! Quote Link to comment https://forums.phpfreaks.com/topic/1209-select-all-records-with-specific-date/ Share on other sites More sharing options...
mondodru Posted October 22, 2003 Author Share Posted October 22, 2003 Oops, the solution was pretty easy, i just used the Like thingy. $query = "SELECT * FROM bp_blog WHERE timestamp LIKE \'%$combo_date%\'"; Quote Link to comment https://forums.phpfreaks.com/topic/1209-select-all-records-with-specific-date/#findComment-4040 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.