1 files changed, 1 insertions, 1 deletions
diff --git a/public/index.php b/public/index.php
index 653962c..84dc753 100644
--- a/public/index.php
+++ b/public/index.php
@@ -13,7 +13,7 @@
 			<h1>hier zijn de aanbiedingen</h1>
 			<ul>
 				<?php
-					$res = $cursor->query("select product.ID as id, product.name as name from promotion join product on product.ID = promotion.product");
+					$res = $cursor->query("select product.id, product.name as name from promotion join product on product.id = promotion.product");
 					while ($product = $res->fetch_object()) {
 						echo "<li><a href=\"/product.php?id=$product->id\">$product->name</a></li>";
 					}