Hi,

I have an idea about a project that I would like to start, but am unsure about the feasibility of it. I have a fairly large relational database (MySQL) with client information in it, spread over multiple tables and want to build small programme that will allow me to extract data from it without having to write complex SQL queries all the time.

Ideally I would want to be able to build a 'search' based on rules, where I pick whether to include or exclude the customer based on whether the rule passed or failed. Building the interface etc... Shouldn’t be too much of a problem, but I’m unsure how to go about converting my 'rules' into executable SQL which will either include or exclude the customer.

If anyone could help me I would be very grateful


James