I want to write a PHP page that will take all the fields from a column from one table, look them up in another table on the same database and display one or more fields from that column on a web page.
The database's name is "amx_bans". I want to take all of the fields from the column "steamid" in the table "amx_amxadmins" and look them up in another table called "snarkrewards" under a column with the same name "steamid" and then display on the page some data in the following format:
(Title of field) (column in the MySQL table "snarkrewards")
Last time on server: lastvisit
There would be more than one result so displaying them all on one page in whatever way is fine. Also if there is a better way of displaying the data I outlined above, go for it.