GROUP

[Miko]

Hello!

 

I making an SQL statement.

My DB looks like this:

 

nr | year | month | day

 

here I have data that is simply plain date:

 

25 | 2009 | 12 | 01

 

but since there are more then 1 day in a month I have this:

 

25 | 2009 | 12 | 02

25 | 2009 | 12 | 03

25 | 2009 | 12 | 04

 

So what I want to do is select the nr 25 and list the dates which have the nr 25 of course.

 

This is very simple with this SQL statement:

 

SELECT * FROM dates WHERE nr = 25

 

The main thing is, I want to make combo boxes of each collumn in php, so I group it by year, but then I have only 1 result : 25 | 2009 | 12 | 01

And not the others.

Anyone knows how to do this?

 

Thanks

[Mchl]

This query should return all dates with nr = 25. If you only get one, it's quite possible you're doing something wring on PHP side.