Re: [PHP] Select Query problem

>Now my question is: What if I would like to display data for the CURRENT MONTH >and the last 11 months???(May also said to be the LAST MONTHS) >HOw should my select query be like?? On Mon, 06 Oct 2003 07:30:26 +0100, David Otton <[EMAIL PROTECTED]> wrote: This question isn't on-topic for this

Re: [PHP] Select Query problem

n Mon, 6 Oct 2003 14:22:59 +0800, you wrote: >Now my question is: What if I would like to display data for the CURRENT MONTH >and the last 11 months???(May also said to be the LAST MONTHS) >HOw should my select query be like?? On Mon, 06 Oct 2003 07:30:26 +0100, David Otton <[EMAIL PROTECTED]>

Re: [PHP] Select Query problem

On Mon, 6 Oct 2003 14:22:59 +0800, you wrote: >Now my question is: What if I would like to display data for the CURRENT MONTH >and the last 11 months???(May also said to be the LAST MONTHS) >HOw should my select query be like?? This question isn't on-topic for this list; it's about SQL, not PHP.

[PHP] Select Query problem

Hi all, Having a slight problem with mysql select query right here. I've learnt that if I were to select a particular data within the last 30 days, this is what my select query should be like: SELECT something FROM tablename WHERE TO_DAYS(NOW(()_TO_DAYS(date_column)<=30; (This query sel