Re: Re: repeating data from one column until data from another column changes
| From: | Curt Zirzow | Date: | Tue, 04 May 2004 22:53:39 +0000 |
| Subject: | Re: Re: repeating data from one column until data from another column changes | ||
| References: | 1 2 3 4 5 6 7 | Groups: | php.general |
| Request: | Send a blank email to php-general+get-185372@lists.php.net to get a copy of this message | ||
* Thus wrote msa (melissa@maddesignusa.com):
>
> "Marek Kilimajer" <kilimajer@webglobe.sk> wrote in message
> news:40980736.4030707@webglobe.sk...
> > date('m') was not parsed by php as it was in the string. Syntax
> > highlighting would help you see it. Try:
> >
> > "SELECT * FROM NewsArchive WHERE YEAR(date) = '" . date('Y') .
> > "' AND
> > MONTH(date) ='" . date('m') . "' ORDER BY sort DESC";
>
> Well, still not working...but maybe closer? Not getting an error message,
> just not returning any data.....
You should pay attention to what your doing.
select month('2004-02-02');
2
echo date('m');
02
Curt
--
"I used to think I was indecisive, but now I'm not so sure."