smartcard

Thanks it works fine

Many thanks the above is working. I want to know how can I output / display only few columns of the database. My database has about 20 columns but I need to display only 3-4 columns in the table.

Is there is simple way to use a single PHP file to extract and display MySQL data in a report format? I want a PHP file in it I will add the database connection credentials (db name, user name, password etc) and I want to run the following query and result the data in a report format. SELECT * FROM `users` WHERE `allowed_user`=1;