Posted by naixn on 12/08/06 00:22

GarryJones wrote :
> [...]

You can do your query like this :
SELECT
*, DATE(CONCAT('2007', ml_mna, '-', ml_dya)) AS thedate
FROM
ml_lopp
LEFT JOIN
scfmforening
ON
(scfmforening.scfmnum = ml_lopp.scfmnum)
LEFT JOIN
ml_tidplats
ON
(ml_tidplats.loppnum = ml_lopp.loppnum)
ORDER BY
thedate

This idea is to concatenate 2007, the month, and the day, then you get
2007-2-1 for the 1st of january, and the function :
DATE() receives it [ DATE('2007-2-1') ] and return :
2007-02-01
And this value is put in "thedate", which is used for the sorting ;)

Could you try and tell the result?

--
Naixn
http://fma-fr.net

• Next in forum: Re: Any luck with MS SQL Server API from PHP5?
• Prev in forum: Re: -> Image submit buttons OK in Firefox, not in IExplorer. Why? <-
• Thread view: Re: Sort after adding leading zero to date?

[Reply to this message]