}
# 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>
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\"> %s</font></td>",
- $rowi['name']);
+ $rowi['subname']);
$table .= sprintf ("<td align=\"right\" width=\"20%%\"><font face=\"Helvetica,Arial\">%6.2f DM </font></td></tr>",
$rowi['price']);
}
</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\"> %s</font></td>", $cd, $rowi['name']);
-# printf ("<td align=\"right\" width=\"20%%\"><font face=\"Helvetica,Arial\">%6.2f DM </font></td></tr>", $rowi['price']);
-# }
-#
echo ("</table>");
echo ($le);
}