How do I split a SQL statement into parts

[s_shrum]

I want to split a SQL query into it's various parts:

SELECT...
FROM...
WHERE...
ORDER BY...
GROUP BY...
LIMIT...
(plus any more I missed)

Ultimately, I want to query a table, first without the WHERE statement to get a TOTAL record count. Then I will query the table without LIMIT so I get a MATCH record count. Lastly, I will run the SQL statement in its' entirity to output to the user.

Here's the catch: Knowing that the order of commands may not always be used, what is the best way to handle spliting a SQL statement into parts?

TIA

Sean Shrum

[steved]

Seems like you could just assign the pieces to different variables and then combine them all together to get your sql statement. If you haven't assigned anything to a variable it will not get added.

$SELECT = "Select count(*) ";
$FROM= "From myTable ";
$WHERE= "";
$ORDER= "";
$GROUP= "";
$LIMIT= "";

$sql = "$SELECT $FROM $WHERE $ORDER $GROUP $LIMIT";

[s_shrum]

I used to do my SQL queries like that but I want to have it so a straight and complete SQL statement can be sent to my templating engine. I'll let the engine parse the statement.

Granted, I'll set it up later to do what your suggesting but for now...I need to parse the statement.

Sean Shrum