Recordset Sort Problem - Need to Add another Parameter

I received this great solution to a recordset sort problem I was having.  I now need to add this form to another page where I need to an additional parameter of 'merchant'.  I thought I could simply add the parameter into the query but it's not working.

The original recordset sort query - this part works:

$sortby_rsProductsDiscount = "ASC";
if (isset($_GET['sort'])) {
  $sortby_rsProductsDiscount = (get_magic_quotes_gpc()) ? $_GET['sort'] : addslashes($_GET['sort']);
}
$orderby_rsProductsDiscount = "price";
if (isset($_GET['order'])) {
  $orderby_rsProductsDiscount = (get_magic_quotes_gpc()) ? $_GET['order'] : addslashes($_GET['order']);
}
$colname2_rsProductsDiscount = "1";
if (isset($_GET['subcategory'])) {
  $colname2_rsProductsDiscount = (get_magic_quotes_gpc()) ? $_GET['subcategory'] : addslashes($_GET['subcategory']);
}


mysql_select_db($database_golena_IDBdb, $golena_IDBdb);
if( isset($_REQUEST['OrderBy']) && !empty($_REQUEST['OrderBy']) )
        $query_rsProductsDiscount = sprintf("SELECT ((IDBdb.retail_price-IDBdb.price)/IDBdb.retail_price) AS discount, IDBdb.name, IDBdb.shortDescription, IDBdb.merchant_display, IDBdb.retail_price, IDBdb.price, IDBdb.url, IDBdb.thumbnail, IDBdb.productID, IDBdb.category, IDBdb.category_display, IDBdb.subcategory, IDBdb.subcategory_display, IDBdb.merchant FROM IDBdb WHERE (((IDBdb.subcategory)='%s')) ORDER BY %s", $colname2_rsProductsDiscount,$_REQUEST['OrderBy']);
else
        $query_rsProductsDiscount = sprintf("SELECT ((IDBdb.retail_price-IDBdb.price)/IDBdb.retail_price) AS discount, IDBdb.name, IDBdb.shortDescription, IDBdb.merchant_display, IDBdb.retail_price, IDBdb.price, IDBdb.url, IDBdb.thumbnail, IDBdb.productID, IDBdb.category, IDBdb.category_display, IDBdb.subcategory, IDBdb.subcategory_display, IDBdb.merchant FROM IDBdb WHERE (((IDBdb.subcategory)='%s')) ORDER BY %s %s", $colname2_rsProductsDiscount,$orderby_rsProductsDiscount,$sortby_rsProductsDiscount);
 
$query_limit_rsProductsDiscount = sprintf("%s LIMIT %d, %d", $query_rsProductsDiscount, $startRow_rsProductsDiscount, $maxRows_rsProductsDiscount);
$rsProductsDiscount = mysql_query($query_limit_rsProductsDiscount, $golena_IDBdb) or die(mysql_error());
$row_rsProductsDiscount = mysql_fetch_assoc($rsProductsDiscount);
 
if (isset($_GET['totalRows_rsProductsDiscount'])) {
  $totalRows_rsProductsDiscount = $_GET['totalRows_rsProductsDiscount'];
} else {
  $all_rsProductsDiscount = mysql_query($query_rsProductsDiscount);
  $totalRows_rsProductsDiscount = mysql_num_rows($all_rsProductsDiscount);
}
$totalPages_rsProductsDiscount = ceil($totalRows_rsProductsDiscount/$maxRows_rsProductsDiscount)-1;


***Problem Below***
Now I tried adding an additional parameter - 'merchant' to the query - but I am getting the following error:  "Warning: sprintf() [function.sprintf]: Too few arguments in /home/golena/public_html/thefrugaldesigner.com/viewproducts_m.php on line 120
You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'LIMIT 0, 10' at line 1"

Here is the query I modified with the additional merchant parameter - this is not working.


$colname_rsProducts = "1";
if (isset($_GET['merchant'])) {
  $colname_rsProducts = (get_magic_quotes_gpc()) ? $_GET['merchant'] : addslashes($_GET['merchant']);
}
$sortby_rsProducts = "ASC";
if (isset($_GET['sort'])) {
  $sortby_rsProducts = (get_magic_quotes_gpc()) ? $_GET['sort'] : addslashes($_GET['sort']);
}
$orderby_rsProducts = "price";
if (isset($_GET['order'])) {
  $orderby_rsProducts = (get_magic_quotes_gpc()) ? $_GET['order'] : addslashes($_GET['order']);
}
$colname2_rsProducts = "1";
if (isset($_GET['subcategory'])) {
  $colname2_rsProducts = (get_magic_quotes_gpc()) ? $_GET['subcategory'] : addslashes($_GET['subcategory']);
}


mysql_select_db($database_golena_IDBdb, $golena_IDBdb);
if( isset($_REQUEST['OrderBy']) && !empty($_REQUEST['OrderBy']) )
        $query_rsProducts = sprintf("SELECT ((IDBdb.retail_price-IDBdb.price)/IDBdb.retail_price) AS discount, IDBdb.name, IDBdb.shortDescription, IDBdb.merchant_display, IDBdb.retail_price, IDBdb.price, IDBdb.url, IDBdb.thumbnail, IDBdb.productID, IDBdb.category, IDBdb.category_display, IDBdb.subcategory, IDBdb.subcategory_display, IDBdb.merchant FROM IDBdb WHERE (((IDBdb.subcategory)='%s')) AND (((IDBdb.merchant)='%s')) ORDER BY %s", $colname2_rsProducts,$_REQUEST['OrderBy']);
else
        $query_rsProducts = sprintf("SELECT ((IDBdb.retail_price-IDBdb.price)/IDBdb.retail_price) AS discount, IDBdb.name, IDBdb.shortDescription, IDBdb.merchant_display, IDBdb.retail_price, IDBdb.price, IDBdb.url, IDBdb.thumbnail, IDBdb.productID, IDBdb.category, IDBdb.category_display, IDBdb.subcategory, IDBdb.subcategory_display, IDBdb.merchant FROM IDBdb WHERE (((IDBdb.subcategory)='%s')) AND (((IDBdb.merchant)='%s')) ORDER BY %s %s", $colname2_rsProducts,$orderby_rsProducts,$sortby_rsProducts);
 
$query_limit_rsProducts = sprintf("%s LIMIT %d, %d", $query_rsProducts, $startRow_rsProducts, $maxRows_rsProducts);
$rsProducts = mysql_query($query_limit_rsProducts, $golena_IDBdb) or die(mysql_error());
$row_rsProducts = mysql_fetch_assoc($rsProducts);
 
if (isset($_GET['totalRows_rsProducts'])) {
  $totalRows_rsProducts = $_GET['totalRows_rsProducts'];
} else {
  $all_rsProducts = mysql_query($query_rsProducts);
  $totalRows_rsProducts = mysql_num_rows($all_rsProducts);
}
$totalPages_rsProducts = ceil($totalRows_rsProducts/$maxRows_rsProducts)-1;



Thank you