Reading values from specific tables in MySQL
Firstly I'm very very new to php and learning all the time but this particular issue is one I cannot find resources to answer in one clean go.
So I have a MySQL database with several tables. Each table has 3 columns labeled Record_Number, Field, Value. Each table has 97 rows with varying data under each column. I need, for example, to read all the data in say, Table1, in the Field column and Value column and assign a variable to each separate bit if data and then echo them out on a web page.
I know how to connect to the database. What I can't find is a concise way to specify the required table, and read the required data in the rows under the two specific columns, field and Value, and assign them to variables.
I hope this makes sense and would be grateful for any help.
Many thanks in advance