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