Re: SELECTing a date range from a table
| From: | Chase Knott | Date: | Sun, 04 Aug 2002 18:04:54 +0000 |
| Subject: | Re: SELECTing a date range from a table | ||
| References: | 1 2 | Groups: | php.db |
| Request: | Send a blank email to php-db+get-20981@lists.php.net to get a copy of this message | ||
Oh sure... Use logic!!!
I am using a MySQL database that has 4 columns, right now, they are all set to VARCHAR since I was getting errors trying to make them date fields. The column names are "vendor," "edate," "cdate," and "fname." I want to pull all entries in the database where "cdate" is either between a certain range, or is greater than or equal to a specified date.
Any help would be great!!!
Jason Wong wrote:
On Sunday 04 August 2002 11:33, Chase Knott wrote:I am a newbie. There, I said it! *gryn* Maybe someone here can help me out... I am trying to figure out how to select a range of dates from my table to be used in a dynamic page. I know it is something simple, but I just can't seem to find anything. Any help would be great. Thanks!!Knowing what you're using would be helpful -- MySQL? Access? MS-Sql? Also knowing what your table looks like, specifically the datatype of the column(s) which holds your date info, would also be very helpful.