'0') { $DisplayCategory .= " / $a1[SubcategoryName]"; } ?>
"; } else { echo " "; } ?>
Categorie:
Prijs: Euro


'0') { $DisplayCategory .= "|$a1[ItemSubcategory]"; } //build the category menu $q2 = "select * from oneshop_categories order by CategoryName "; $r2 = mysql_query($q2) or die(mysql_error()); $MySelect = ""; ?>
Er zijn geen items in de database..."; exit(); } ?>
Editeer het product
Product naam: Huidige afbeelding:

\n"; } else { echo "Er is geen foto beschikbaar voor dit product."; } ?>
Categorie:
Beschrijving:
Nieuwe afbeelding:
Prijs verzending:
Product prijs:
\n\t\n\t\n\t\n\t\n\t\n\n\n"; } echo "\n\t\n\n\n
ItemID Item naam Categorie / Sub-categorie Prijs Selecteer
$a1[ItemID]$a1[ItemName]$a1[CategoryName]"; if(!empty($a1[SubcategoryName])) { echo " / $a1[SubcategoryName]"; } echo "$MyPrice

\n\t
\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 ""; 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 "|

\n"; ?>