I have a CSV file with 3 fields, PatronID, LastName, and AccountBalance. I want to create a site similar to this http://fortcherry.schooltoweb.com/lunchbalance/find.php
so that parents can type in their student's lastname and pin number to see their lunch account balance.
I have MySQL and a new database created. I log into phpMyAdmin and create a new table. Add the fields and import the CSV file, however I can only see the first field listed. I have PatronID as INT, LastName as Text utf8-general, and AccountBalance as Decimal.
This is where I am and have no idea how to go any further.
Thank you in advance