I am new to databases.
I imported a large database using phpmyadmin and it has a FieldA which is a field consisting of grades.
Now what I want to do is have an HTMl form, which takes two inputs min and max for FieldA and computes the average, with the help of an SQL query, of all numbers in FieldA between the min and max.
What is the best way to do this? As in, how can I make my HTML form interact with the database I created on phpmyadmin
Example: I have HTML form with "Max: " and "Min:" User enters: 1000, 100 Clicks submit and the form calls an SQL query that finds all numbers in range of 100,1000 in FieldA of database, and returns their average on HTML screen
Sorry if anything unclear