Recordset Edits
I see there were a few people with this problem but when I try to edit a SQL statement I seem to get a new one.
Editing this:
mysql_select_db($database_Chairs, $Chairs);
$query_WADAproducts = "SELECT product_id, name, weight, list_price, image FROM products ORDER BY product_id DESC";
$query_limit_WADAproducts = sprintf("%s LIMIT %d, %d", $query_WADAproducts, $startRow_WADAproducts, $maxRows_WADAproducts);
$WADAproducts = mysql_query($query_limit_WADAproducts, $Chairs) or die(mysql_error());
$row_WADAproducts = mysql_fetch_assoc($WADAproducts);
To This:
mysql_select_db($database_Chairs, $Chairs);
$query_WADAproducts = sprintf("SELECT products.product_id, products.name, products.weight, products.list_price, products.image, pmap.product_id, pmap.mc FROM products, pmap WHERE pmap.mc = %s ORDER BY products.product_id DESC", GetSQLValueString($Parammc_WADAproducts, "text"));
$query_limit_WADAproducts = sprintf("%s LIMIT %d, %d", $query_WADAproducts, $startRow_WADAproducts, $maxRows_WADAproducts);
$WADAproducts = mysql_query($query_limit_WADAproducts, $Chairs) or die(mysql_error());
$row_WADAproducts = mysql_fetch_assoc($WADAproducts);
It just inserts it as a new query. I saw you sent a file to some one to fix it but that is 2 years old. Is there a fix or setting for this?