what happens if you simplify the recordset code from:
php:
$colname_WADAtyres = "-1";
if (isset($_POST['S_width'])) {
$colname_WADAtyres = (get_magic_quotes_gpc()) ? $_POST['S_width'] : addslashes($_POST['S_width']);
}
$colname5_WADAtyres = "-1";
if (isset($_POST['S_runflat'])) {
$colname5_WADAtyres = (get_magic_quotes_gpc()) ? $_POST['S_runflat'] : addslashes($_POST['S_runflat']);
}
$colname3_WADAtyres = "-1";
if (isset($_POST['S_load'])) {
$colname3_WADAtyres = (get_magic_quotes_gpc()) ? $_POST['S_load'] : addslashes($_POST['S_load']);
}
$colname4_WADAtyres = "-1";
if (isset($_POST['S_speed'])) {
$colname4_WADAtyres = (get_magic_quotes_gpc()) ? $_POST['S_speed'] : addslashes($_POST['S_speed']);
}
$colname1_WADAtyres = "-1";
if (isset($_POST['S_depth'])) {
$colname1_WADAtyres = (get_magic_quotes_gpc()) ? $_POST['S_depth'] : addslashes($_POST['S_depth']);
}
$colname2_WADAtyres = "-1";
if (isset($_POST['S_size'])) {
$colname2_WADAtyres = (get_magic_quotes_gpc()) ? $_POST['S_size'] : addslashes($_POST['S_size']);
}
mysql_select_db($database_connect, $connect);
$query_WADAtyres = sprintf("SELECT * FROM tyres WHERE tyres.sale >0 AND tyres.width = %s AND tyres.`depth` = %s AND tyres.`size`= %s AND tyres.speed LIKE %s AND tyres.load LIKE %s AND tyres.runflat >= %s", GetSQLValueString($colname_WADAtyres, "int"),GetSQLValueString($colname1_WADAtyres, "int"),GetSQLValueString($colname2_WADAtyres, "text"),GetSQLValueString("%" . $colname4_WADAtyres . "%", "text"),GetSQLValueString("%" . $colname3_WADAtyres . "%", "text"),GetSQLValueString($colname5_WADAtyres, "text"));
$WADAtyres = mysql_query($query_WADAtyres, $connect) or die(mysql_error());
$row_WADAtyres = mysql_fetch_assoc($WADAtyres);
$totalRows_WADAtyres = mysql_num_rows($WADAtyres);
to:
php:
mysql_select_db($database_connect, $connect);
$query_WADAtyres = "SELECT * FROM tyres";
$WADAtyres = mysql_query($query_WADAtyres, $connect) or die(mysql_error());
$row_WADAtyres = mysql_fetch_assoc($WADAtyres);
$totalRows_WADAtyres = mysql_num_rows($WADAtyres);
the try to add the add to cart button? After adding the add to cart button, you can revert the recordset code to the original.
