Price database and confusing SQL query

[eluser]TheFuzzy0ne[/eluser]

Code:

// Set up your query here


$subquery = $this->db->_compile_select(); // Get your query.
$this->db->_reset_select(); // Reset the class before reusing it.

The code above is untested

These are private functions, so this should work, but I would imagine there's a better way. I'm totally sure there is a much simpler way that I've overlooked, and another member is going to jump up and smack me round the head with it...

Also, it will break when CodeIgniter eventually supports only PHP version 5 and up (if this ever happens). So please, keep an eye on this post in case someone, does indeed, offer you a real solution.