."<font face=\"Helvetica,Arial\"><a href=\"show.php3?article=%s\">%s</a></font></th></tr>",
$ch, $row['article'], $row['name']);
- $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']));
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\">%s</font></td>", $cd, $rowi['name']);
+ printf ("<tr bgcolor=\"%s\"><td align=\"left\" width=\"70%%\"><font face=\"Helvetica,Arial\">%s</font></td>", $cd, $rowi['subname']);
printf ("<td align=\"right\" width=\"20%%\"><font face=\"Helvetica,Arial\">%6.2f DM</font></td>", $rowi['price']);
printf ("<td align=\"center\" width=\"10%%\"><font face=\"Helvetica,Arial\"><input name=\"%s\" size=\"3\" maxlength=\"3\">"
."</font></td></tr>", $rowi['articleid']);