RE: Selecting by date

2004-01-16 Thread Mike Johnson
From: Matthew Stuart [mailto:[EMAIL PROTECTED] > I have created a sql statement that enables me to select all > entries in to MySQL that are dated today, I am trying to do > the same for all items that are now one day old and also two > days old etc > > I am doing this: > > SELECT * > FROM ta

Re: Selecting by date

2004-01-16 Thread Lowell Allen
> I have created a sql statement that enables me to select all entries in > to MySQL that are dated today, I am trying to do the same for all items > that are now one day old and also two days old etc > > I am doing this: > > SELECT * > FROM table > WHERE category = 3 AND show = 1 AND date = NOW(

Selecting by date

2004-01-15 Thread Matthew Stuart
I have created a sql statement that enables me to select all entries in to MySQL that are dated today, I am trying to do the same for all items that are now one day old and also two days old etc I am doing this: SELECT * FROM table WHERE category = 3 AND show = 1 AND date = NOW()-1 I have it wo