Kick ass shit :)
I wish it was faster

__________________
מטבחים (hebrew)

What does the letter 'z' means in this string: $szSQL?

I honestly find this to be overkill. And I know this is difference in our coding style, but I see it as unnecessarily long and harder to read then my method of doing it. the easiest and fastest way to prevent this is to clean your queries and put your values in ''s. That way you cannot inject false values (' is escaped).

SELECT * FROM `table` WHERE `value` = '$value'

This is what the mysql manual says to do.

__________________
The tool I likely used to answer your question.

It just looks a bit better than $sSQL.

How would you do this with sprintf:

This gives an error because of the %d from the DATE_FORMAT.

To print a literal percent symbol, use two together
printf('%d%% sale, today only!', 50); // 50% sale, today only!

__________________
salathe@php.net

I do it all the time.

__________________
VillageIdiot can have my babbies ;d