I am trying to make a graph based on a specific company's sales,
My table has the CompanyId, CurrentYear, MonthId, CurrentYearSales, PriorYearSales.
I was thinking of searching through the table in order to get the graph to populate
Searching for months from January- May and for companyId 3 would be searching in my monthId field for 1...5 and my CompanyId would be 3
I tested this and it works,
however i am having trouble making the 1 and 5 into variables and putting data in them
What is a good way to set up a dropdown of months for this to work