Issue building an SQL string with sprintf

1

I’m having an issue with trying to build a dynamic SQL string with sprintf.

Keeps giving me the error:

**Warning**:  sprintf() [[function.sprintf](http://localhost/retailersform/includes/function.sprintf)]: Too few arguments in **/Applications/MAMP/htdocs/retailersform/includes/submitsurvey.php** on line **22

**

I have tried every darn combination, but i really would like to use sprintf. Here’s some code, it’s pretty straight forward:

<?php

if(isset($_POST['submit'])){
    $error = array();
    $count = 0;
    $insert_fields = "";
    $insert_placeholders = "";
    $insert_safe_values = "";
    include ('safeSQL.php');
    foreach ($_POST as $key => $value) {
        $insert_fields .= "`".$key."` ,";
        $insert_placeholders .= "%s,";
        $insert_safe_values .= "'".safeSQL($_POST[$key], 'text')."',";
           if($value == "" && $count < 9){
            array_push($error, $key);
        }
        $count++;
    }

    $insert_safe_values = rtrim($insert_safe_values, ",");
    
    $query_brands = sprintf("INSERT INTO  `retailersform`.`retailers` ($insert_fields `dateadded` ,`approved`) VALUES ($insert_placeholders NOW() ,'0');", $insert_safe_values);
    echo $query_brands;
    
    //if(count($error) < 1){
        //include('includes/rmg.php'); 
        
        //mysql_select_db($database_rmg, $rmg);
        
        //$grab_brands = mysql_query($query_brands, $rmg) or die(mysql_error());
    //}
}

?>