Querying records by date range

[Eiolon]

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?

[Newsgroup_User]

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/