When you access a database using PHP it is quite normal to put the login data in a php file. THe only other alternative is to get each user to enter it which then requires that you publish it where all your users can see it and thus makes it less secure.
Many thanks for your assistance, I will implement your solution!
I have started playing with the code provided by ScallioXTX and it seems to be putting some of the data into IE, however it does not prompt you to save the data as a CSV, I must have missed something so I will play with this to see.
One other question I have regarding security, as this piece of script has the database username and password in it, how safe (or secure) is it in it’s current form?
Well a long time since I last wrote but this project has been on the sidelines for a little while (now back into focus)
I have had a look through your example (which I appreciate, thank you) and whilst a little over my head I’m working my way through it (SQL is very new to me)
As the output table needs to be very specific in format, there will need to be some blank cells so the data corresponds with the correct cell. Can this be generated by the query, or should I creat a “temp” table for this?