Class: sql_query_generator

This class will generate a large range of SQL SELECT queries from a submitted form.

It provides facilites for simple queries on one field on a table, joins, selection of fields to be returned, aliasing of fields (eg. SUM(Price) AS Total), ORDER BY, even multiple queries from one form.

Comes with a basic demo file, which I hope to update in time. GROUP BY and HAVING are also provided, but not entirely reliable.

Demo file provides overview of creating forms necessary to generate results.

If you know an application of this package, send a message to the author to add a link here.