0

I have entry dates of my records in format yyyy-mm-dd.
I have 2 drop down menus, one for Year, and one for Month to select. I have no idea how to return results without using the complete date.
If I use a text box and enter the exact date (Y,m,d) I can get results, but again, I don't know how to return all results for a particular month. Other than using separate fields one for Year and one for Month, and using those to return the results.
Can anyone point me in the right direction?
Thank You.

2
Contributors
2
Replies
3
Views
8 Years
Discussion Span
Last Post by mark2326l
0

If your problem is how to select the appropriate record from a (MySQL) database, then you could use:

Select * from table1 where date like '%-$mm-%'

To select a specific month.

Edited by peter_budo: Keep It Organized - For easy readability, always wrap programming code within posts in [code] (code blocks) and [icode] (inline code) tags.

This question has already been answered. Start a new discussion instead.
Have something to contribute to this discussion? Please be thoughtful, detailed and courteous, and be sure to adhere to our posting rules.