list box of months

[macca2727]

hi i have a list box with months of the year as values,

i have a table with a column dateordered showing dates as "2006/12/04"

if the month December was selected from the list box

how can i get the results page to show all the table rows that have a month of 12?

[Guest]

2006/12/04 is a three-element list, delimited by the slash ( / ). So if ListGetAt(foo, 2, "/") is 12, you have found a December date.

[Kronin555]

What database are you using?

[macca2727]

database is mysql

[stpaz]

select * from table where month(dateordered) = 12 ?

[Guest]

so...what are you missing? between jdeline's response and stpaz's response, you've got your answer.

[macca2727]

i have a column with date values "2006/12/04"

how can i generate my list box, from this column

i would like distinct months to appear?

ie if the column has "2006/12/04" i would like to show December in my list box

[philh]

SELECT DISTINCT DATE_FORMAT(mydatecolumn,%M) as monthname
FROM Mytable
ORDER BY monthname

[macca2727]

Hi thanks for that i am getting a error on this line
SELECT DISTINCT DATE_FORMAT(DateOfSMS,%M) as monthname

i am using mysql what could be wrong?

[stpaz]

what is the error?

[philh]

I lifted the DATE_FORMAT function syntax from the MySQL documentation. Hard for me to test it since I don't have it here.

Also, once you get over this hurdle, add a month-number column and order by that instead of the month name.

[tclaremont]

Is the field where the date is store a true date field, or is it a text field?