I need some help with my project. I would like to make my everyday work easier. I would like to:
upload excel(or CSV) to MySQL, in separeted tables
need dropdown boxes, first lists tables, second list the choosen table's fields
more same function boxes
if i choose a field it will be added to a query
For example, i have multiple excels with one ID column and 2-3 other data columns, upload them in separated mysql tables. I need to compare selected tables. These datas using the same ID-s(so i need JOIN). And i would like to highlight the lowest value in each row.
Is this possible to make it with PHP and MySQL? Any help would be great!
P.s: Sorry my english isn't good, i hope it's understandable.