Re: show data between values
| From: | David Robley | Date: | Fri, 12 Oct 2001 00:41:22 +0000 |
| Subject: | Re: show data between values | ||
| References: | 1 | Groups: | php.general |
| Request: | Send a blank email to php-general+get-70868@lists.php.net to get a copy of this message | ||
On Fri, 12 Oct 2001 09:18, Devon wrote:
> How can u show data between to values in a mysql database. eg. I want
> to be able to search between certain dates.
>
> Cheers
> Dev
That's really a mysql question, don't you think? Without any information
about your data structure, a broad suggestion would be something like
SELECT blah FROM table WHERE (datefield < $highvalue AND datefield >
$lowvalue)
--
David Robley Techno-JoaT, Web Maintainer, Mail List Admin, etc
CENTRE FOR INJURY STUDIES Flinders University, SOUTH AUSTRALIA
Nunnery - Where nuns are hatched