Jump to content


This topic is now archived and is closed to further replies.


Select All Records with Specific Date

Recommended Posts

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!

Share this post

Link to post
Share on other sites

Oops, the solution was pretty easy, i just used the Like thingy.

$query = "SELECT * FROM bp_blog WHERE timestamp LIKE \'%$combo_date%\'";

Share this post

Link to post
Share on other sites


Important Information

We have placed cookies on your device to help make this website better. You can adjust your cookie settings, otherwise we'll assume you're okay to continue.