good advice, as ever
Thank you Jason.
I've installed and configured HeidiSQL but, unlike SQL Server Management Studio, I can't easily see how I add tables to create a View, which is how I'm creating this INNER JOIN query. In SQLSMS I can simply select, from a list, all of the tables I want to use in my query (A view is just another name for a query table, right?). Where, in HeidiSQL, is the visual builder?
Thank you again for all your help Jason. My intention is to purchase eCart in the next month or two and really push on with developing in PHP.
I only hope that it, too, doesn't die like Classic ASP did.
Oh, and with that in mind, is there an upgrade option for eCart? I'm currently using version 4.5.2.