I once asked on a thread how it would be possible to create a website with an active database linked to it, so that users could click on MUI style column sorters to arrange fields in order (like when you click price on eBay and they go in highest or cheapest order).
I was told AmiSQL can do this but I seem to have PHP in my mind.
What's the relation between PHP, Apache, SQL and CGI scripts? And what is https, XML and CSS?