Here’s the full chunk of code that has the problem:
<?php
if($_REQUEST[‘pagesubmitted’] == 1){
if($subcat=="" && $min=="" && $max==""){
$sql = mysql_query("SELECT * FROM stock_portfolio WHERE PFCDealerId IN ('1832208', '1986050', '1968553') ORDER BY Price LIMIT $from, $max_results");
}
//1 selected
elseif($subcat!= "" && $min=="" && $max==""){
$sql = mysql_query("SELECT * FROM stock_portfolio WHERE VehicleDescription LIKE '%$subcat%' AND PFCDealerId IN ('1832208', '1986050', '1968553') ORDER BY Price LIMIT $from, $max_results");
}
elseif($subcat== "" && $min!="" && $max==""){
$sql = mysql_query("SELECT * FROM stock_portfolio WHERE Price=>$min AND PFCDealerId IN ('1832208', '1986050', '1968553')ORDER BY Price LIMIT $from, $max_results");
}
elseif($subcat== "" && $min=="" && $max!=""){
$sql = mysql_query("SELECT * FROM stock_portfolio WHERE Price<=$max AND PFCDealerId IN ('1832208', '1986050', '1968553') ORDER BY Price LIMIT $from, $max_results");
}
//2 selected
elseif($subcat!= "" && $min!="" && $max==""){
$sql = mysql_query("SELECT * FROM stock_portfolio WHERE VehicleDescription LIKE '%$subcat%' AND Price=>$min AND PFCDealerId IN ('1832208', '1986050', '1968553') ORDER BY Price LIMIT $from, $max_results");
}
elseif($subcat!= "" && $min=="" && $max!=""){
$sql = mysql_query("SELECT * FROM stock_portfolio WHERE VehicleDescription LIKE '%$subcat%' AND Price<=$max AND PFCDealerId IN ('1832208', '1986050', '1968553') ORDER BY Price LIMIT $from, $max_results");
}
elseif($subcat== "" && $min!="" && $max!=""){
$sql = mysql_query("SELECT * FROM stock_portfolio WHERE Price BETWEEN $min AND $max AND PFCDealerId IN ('1832208', '1986050', '1968553') ORDER BY Price LIMIT $from, $max_results");
}
//3 selected
elseif($subcat!="" && $min!="" && $max!=""){
$sql = mysql_query("SELECT * FROM stock_portfolio WHERE VehicleDescription LIKE '%$subcat%' AND Price BETWEEN $min AND $max AND PFCDealerId IN ('1832208', '1986050', '1968553') ORDER BY Price LIMIT $from, $max_results");
}
else{
$sql = mysql_query("SELECT * FROM stock_portfolio WHERE PFCDealerId IN ('1832208', '1986050', '1968553') ORDER BY Price LIMIT $from, $max_results");
}
}else{
$sql = mysql_query(“SELECT * FROM stock_portfolio WHERE PFCDealerId IN (‘1832208’, ‘1986050’, ‘1968553’) ORDER BY Price LIMIT $from, $max_results”);
}
//$sql = mysql_query(“SELECT * FROM stock WHERE man_id=‘$make’ LIMIT $from, $max_results”);
///$stock_result = mysql_query($sql) or die(mysql_error());
///$stock_query = mysql_num_rows($stock_result);
while($row_stock = mysql_fetch_array($sql)){
// Build your formatted results here.
echo
?>
When I do <?php echo “$sql”; ?>
I get Resource id #9
Does this help?