Jump to content

Archived

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

mondodru

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.