Jump to content


Photo

Select All Records with Specific Date


  • Please log in to reply
1 reply to this topic

#1 mondodru

mondodru
  • Members
  • Pip
  • Newbie
  • 2 posts

Posted 22 October 2003 - 02:41 PM

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!

#2 mondodru

mondodru
  • Members
  • Pip
  • Newbie
  • 2 posts

Posted 22 October 2003 - 03:57 PM

Oops, the solution was pretty easy, i just used the Like thingy.
$query = "SELECT * FROM bp_blog WHERE timestamp LIKE \'%$combo_date%\'";





0 user(s) are reading this topic

0 members, 0 guests, 0 anonymous users