I think you can't achieve this with the example you've provided.
Perhaps something like this will work:
query = "";
mysql_query("SELECT * FROM table ". $query );
query = "WHERE date = '2001-01-01'"; // This should return all rows with
2001-01-01 as date.
query = "WHERE date > '1995-01-01'"; // All items newer than 1995-01-01.
query = "WHERE date < '1995-01-01'"; // All items older than 1995-01-01.
query = "WHERE date > '1995-01-01' AND date < '1998-01-01'"; // All items
between 1995-01-01 and 1998-01-01.
Hope this helps
/Joakim
> -----Original Message-----
> From: Craig Westerman [mailto:[EMAIL PROTECTED]]
> Sent: Monday, February 25, 2002 7:34 PM
> To: [EMAIL PROTECTED]
> Subject: [PHP] php - assigning date variables
>
>
> $query = ""
> mysql_query("SELECT * FROM table WHERE date LIKE '%". $query ."%'");
> // returns all items in database
>
>
> $query = "2001-01-01"
> mysql_query("SELECT * FROM table WHERE date LIKE '%". $query ."%'");
> // returns all rows that have 2001-01-01 as the date
>
>
> What is proper way to define a variable to include all dates
> newer than
> 1995-01-01?
> $query = "???"
>
> What is proper way to define a variable to include all dates
> older than
> 1995-01-01?
> $query = "???"
>
> What is proper way to define a variable to include all dates between
> 1995-01-01 and 1998-12-31?
> $query = "???"
>
>
> Everything I tried gives me a error. This has to be simple,
> but I must be
> overlooking something. Where would I find the answer?
>
> Thanks
>
> Craig ><>
> [EMAIL PROTECTED]
>
>
> --
> PHP General Mailing List (http://www.php.net/)
> To unsubscribe, visit: http://www.php.net/unsub.php
>
--
PHP General Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php
