Skip to main content
Eiolon
Known Participant
August 3, 2006
Question

Querying records by date range

  • August 3, 2006
  • 1 reply
  • 282 views
Using PHP and MySQL, each record that is inserted is timestamped. I want to query records by date range. For example, 10-26-2005 to 05-23-2006. Any way I can do this with Dreamweaver?
This topic is closed to new replies. Start a new post to keep the conversation going.

1 reply

Newsgroup_User
Inspiring
August 3, 2006
Eiolon wrote:
> Using PHP and MySQL, each record that is inserted is timestamped. I want to query records by date range. For example, 10-26-2005 to 05-23-2006. Any way I can do this with Dreamweaver?

SELECT * FROM myTable
WHERE myTimestampColumn BETWEEN '2005-10-26' AND '2006-05-23'

--
David Powers
Adobe Community Expert
Author, "Foundation PHP for Dreamweaver 8" (friends of ED)
http://foundationphp.com/
Terms & ConditionsAccessibility statement
Using the community Terms of use Privacy Cookie preferences Do not sell or share my personal information ad choicesAdChoices