I have been searching wildly but can't find a solution simple enough for my needs. Hopefully this question is OK here.
I wish to have a page eg. /local/test.php that queries the database and provides a simple list. I have done this successfully to echo the current userid, so I know it works using require('../config.php');
I am struggling to get a list of all user names. Sounds so easy! What is the correct way to query the database then cycle through the results to print these as rows in a table?
I know there is lots of info out there about queries, and also about how to print mysql queries as rows but there is much less about how to construct a single php page that has the query and prints the results.
Can anyone please provide a sample php page that simply does this?
Thanks so much!