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
> 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(
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