Re: [PHP-DB] date problems

2007-09-06 Thread Mike Gohlke
Argh, make sure you add the closing paren for the date_add since I forgot it. Mike... Mike Gohlke wrote: It's much better to use add_date instead of to_days since mysql isn't smart enough to do it for you. Such as: SELECT yourEventFields FROM theTable WHERE theEventDate BETWEEN

Re: [PHP-DB] date problems

2007-09-06 Thread Mike Gohlke
It's much better to use add_date instead of to_days since mysql isn't smart enough to do it for you. Such as: SELECT yourEventFields FROM theTable WHERE theEventDate BETWEEN now() AND date_add(now(), INTERVAL 21 DAYS; This way mysql will calc the now() and date_add and will essentially convert

Re: [PHP-DB] Query with numbers like 1, 3, 5..........

2002-02-07 Thread Mike Gohlke
$ref1->id  $ref2->id   btw, the   is to keep the internal cell borders from not appearing using netscape. (keeps it from being empty). Hope this helps Mike... Raymond Lilleodegard wrote: >Hi again Rick! : ) > >It is because I am trying to list all products that I have in a database >