Er zijn geen items aanwezig in de database...";
exit();
}
?>
| Item nummer |
Item Naam |
Categorie / Sub-categorie |
Prijs |
\n\t$a1[ItemID] | \n\t$a1[ItemName] | \n\t$a1[CategoryName]";
if(!empty($a1[SubcategoryName]))
{
echo " / $a1[SubcategoryName]";
}
echo " | \n\t$MyPrice | \n\n\n";
}
echo "\n\n
\n\n";
$qnav = "select oneshop_producten.*, oneshop_categories.*, devbg_subcategories.* from oneshop_producten
left join oneshop_categories on oneshop_producten.ItemCategory = oneshop_categories.CategoryID
left join devbg_subcategories on oneshop_producten.ItemSubcategory = devbg_subcategories.SubcategoryID
order by ItemName ";
$rnav = mysql_query($qnav) or die(mysql_error());
$rows = mysql_num_rows($rnav);
echo "
";
echo "| | ";
$pages = ceil($rows/$ByPage);
for($i = 0; $i <= ($pages); $i++)
{
$PageStart = $ByPage*$i;
$i2 = $i + 1;
if($PageStart == $Start)
{
$links[] = " $i2\n\t ";
}
elseif($PageStart < $rows)
{
$links[] = " $i2\n\t ";
}
}
$links2 = implode(" | ", $links);
echo $links2;
echo "| | ";
echo "
\n";
?>