I want to know how can i display the data of the same city of logged user in a page?

Question

I have two tables, one for admin with (uname, pwd, city). Other one transactions, which logged user can add transactions under his city only. I want to know how can I display the data of the same 'city' of logged user in a page? both tables have a field called 'city'.

Answer 1

You can make a database by SQL and you can use PHP