Simple Php Mysql Retrieval
I need a simple PHP script to retrieve, display and email the results of a search of the first field of a simple Mysql DB.
The results need to be sorted by the last data column.
The DB consists of 5 fields Name, NumberA, NumberB, NumberC and NumberD.
The script needs to accept search input from a HTML form box or a file designated in the script.
The file will contain search terms one per line. The HTML form box must also accept multiple keywords, one per line and the script will need to iterate through the list.
I created a PHP script that retrieves results from a form input but I’m unable to sort the results by the last column.
I’m attaching an image of a sample output from my script.