From f3b582307cc3caf5ee0c7514d461e47fb5893bc7 Mon Sep 17 00:00:00 2001
From: lonkaars <loek@pipeframe.xyz>
Date: Mon, 8 May 2023 17:14:06 +0200
Subject: uppercase is dumb

---
 public/index.php | 2 +-
 1 file changed, 1 insertion(+), 1 deletion(-)

(limited to 'public/index.php')

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>";
 					}
-- 
cgit v1.2.3