WEB SELECT SCRIPT HELP
Posted on 2012-09-16
I have a mysql database with the following rows in the table "Mytbl" with the following rows
I want to be able to have a form where you can select dates as a time period then have another drop down to decide day or eve from the dayeve row then have the sql statement check the data base for most hit numberw in each of the rows "digitone,digittwo,digitthree, and the digitall row. So it will tell between that period of time (dates) chosen these are the number that came out in each of the rows the most times and how many times.
I can make the form I just am not sure how to do the sql for this.