mysql_select_db('filecart_store');
$sqlquery = "SELECT ds_items.id, title, price, description, ds_items.category, ds_category.parent FROM ds_items LEFT JOIN ds_category ON ds_items.category=ds_category.catid WHERE title LIKE '%$productname%'";
$result = mysql_query($sqlquery);
$number = mysql_numrows($result);
$i = 0;
?>
Results from our Online Store:
if ($number < 1) {
echo "| This product is not in our online store. |
";
} else {
while ($number > $i) {
$storepid = mysql_result($result,$i,"id");
$title = mysql_result($result,$i,"title");
$description = mysql_result($result,$i,"description");
$cat = mysql_result($result,$i,"category");
$price = mysql_result($result,$i,"price");
$price = number_format($price, 2);
$pcat = mysql_result($result,$i,"ds_category.parent");
if ($pcat == '0')
$pcat = $cat;
$fproduct = ereg_replace(' ','_',$title);
$srcount++;
echo "
| $srcount. |
$title |
|
$$price |
|
BUY NOW |
";
$i++;
}}
?>