. offer.name -> offer.subname, damit ich eindeutige Feldbezeichner

[infodrom.org/infocon.infodrom.org] / src / shop / show.wml

diff --git a/src/shop/show.wml b/src/shop/show.wml
index 5b52362..e01aa0d 100644 (file)
--- a/src/shop/show.wml
+++ b/src/shop/show.wml
@@ -44,7 +44,7 @@
     }
 
     # Sub-Query
-    $sthi = dbquery ($dbh, sprintf ("SELECT name,price,articleid FROM offer WHERE article = '%s'ORDER BY articleid",
+    $sthi = dbquery ($dbh, sprintf ("SELECT subname,price,articleid FROM offer WHERE article = '%s'ORDER BY articleid",
                                      $row['article']));
     if (pg_NumRows ($sthi) > 0) {
       <protect>
@@ -53,7 +53,7 @@
       for ($ii=0; $ii < pg_NumRows ($sthi); $ii++) {
        $rowi = pg_fetch_array ($sthi, $ii);
        $table .= sprintf ("<tr><td align=\"left\" width=\"70%%\"><font face=\"Helvetica,Arial\">&nbsp;%s</font></td>",
-                          $rowi['name']);
+                          $rowi['subname']);
        $table .= sprintf ("<td align=\"right\" width=\"20%%\"><font face=\"Helvetica,Arial\">%6.2f DM&nbsp;</font></td></tr>",
                           $rowi['price']);
       }
@@ -71,14 +71,6 @@
     </protect>
     printf ("<tr><td width=\60%%\" align=\"left\" valign=\"bottom\">%s</td></tr>", $table);
   
-#   $sthi = dbquery ($dbh, sprintf ("SELECT name,price,articleid FROM offer WHERE article = '%s'ORDER BY articleid",
-#                                     $row['article']));
-#   for ($ii=0; $ii < pg_NumRows ($sthi); $ii++) {
-#     $rowi = pg_fetch_array ($sthi, $ii);
-#     printf ("<tr bgcolor=\"%s\"><td align=\"left\" width=\"70%%\"><font face=\"Helvetica,Arial\">&nbsp;%s</font></td>", $cd, $rowi['name']);
-#     printf ("<td align=\"right\" width=\"20%%\"><font face=\"Helvetica,Arial\">%6.2f DM&nbsp;</font></td></tr>", $rowi['price']);
-#   }
-# 
     echo ("</table>");
     echo ($le);
   }