As well as showing the whole database table, PHP can be used to select individual records, or records which match certain criteria. To do this you must use a variation of the SELECT query. To display the whole table you can use:
SELECT * FROM tablename
If you just want to select records which have value=1 in the field1-name row you would use the following query:
SELECT * FROM tablename WHERE field1-name='1'
In the same way you could select records based on any field in the database. You can also search in more fields by adding more:
sections into the query.
For example, the following query will select all records which have value=1 in the field1-name row and value=2 in the field2-name row:
SELECT * FROM tablename WHERE field1-name='1' AND field2-name='2'