sprintf?????

[amrknt]

What's the actual uses of sprintf?
I've seen somewhere something like this:

$sql = sprintf("SELECT COUNT(*) AS test FROM %s WHERE email = '%s' AND active = 'y'", $this->table_name, $this->user_email); 

Is it not good like this:

$sql = "SELECT COUNT(*) AS test FROM $this->table_name WHERE email = '$this->user_emails' AND active = 'y' "; 

[Mike]

Have you read the documentation? http://ca3.php.net/sprintf

I haven't had a use for it myself, but it looks lke it'd be handy for mathematical formatting, among others.

[amrknt]

Have you read the documentation? http://ca3.php.net/sprintf

I haven't had a use for it myself, but it looks lke it'd be handy for mathematical formatting, among others.

Yes I'd, but I coudn't find any good example(not on the php.net, i'm
talking about PHP scripts spread allover the web) to use this.

[frezno]

sprintf() becomes handy when it comes eg to formatted output.
if you want to print a list with several columns and don't wan´t to use tables you could do something like:

sprintf("%4s %-11s %-40s %6s %6s", "Qty", "ItemNr.", "Item", "Price", "Total");
//-- ...
while ( ... )
{
    sprintf("%4s %-11s %-40s %6s %6.2f %s\n",
             $qty, $item_nr, $name,
             $price, ($p_sp_price * $qty), $currency);
}