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.
mark2326l
0
Light Poster
Recommended Answers
Jump to PostIf 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.
All 2 Replies
Reply to this topic
Be a part of the DaniWeb community
We're a friendly, industry-focused community of developers, IT pros, digital marketers, and technology enthusiasts meeting, networking, learning, and sharing knowledge.