Member Avatar for mark2326l

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
  • 105 Views
  • 7 Hours Discussion Span
  • Latest Post Latest Post by mark2326l
Member Avatar for chrishea

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 because: Keep It Organized - For easy readability, always wrap programming code within posts in [code] (code blocks) and [icode] (inline code) tags.
Member Avatar for mark2326l

Thank You Chrishea. That was what I needed.

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.