[scottyadam]

My project i'm trying to build is in the title, looking for a class that will dynamically build me a complex mysql SELECT query conforming to this... http://dev.mysql.com.../en/select.html

Alrighty, been searching around and here is what I have found:

http://stackoverflow...ilder-php-class
which points to this project: https://github.com/i...L-Query-Builder

There is another link on that page but that isn't exactly it...

Can't find anything else on Google, turns out nobody on this forum has asked about this type of thing so I figured i'd see if anyone else knew about this kind of thing existing...maybe i've been going about this all wrong...

I can take the existing class on github and modify to included embedded select and joins but don't want to go through all of that unless somebody else has already done it. Anyone know of this project already done or is it time i pull a few all nighters to build it...or extend rather on that other php class...

[Atli]

I've never used it directly myself, but as I understand it, the Doctrine DBAL has a powerful query builder. Worth looking into, at least. It's what the Doctrine ORM is built on top of.