https://www.webmaster-forums.net/crss/node/1005934 en https://www.webmaster-forums.net/web-database-development/grouping-database-rows-asp#comment-1031615 <p>Well, no thanks to anyone here, I figured it out myself <img src="http://www.webmaster-forums.com/ubb/smile.gif" alt="" class="bb-image" />. Thought I'd post what I did just in case someone else out there was waiting for an answer, too.</p> <p>It wasn't the simple "GROUP BY" SQL clause that I'd hoped would work: I turned out to need another column indicating how many programs are present for each merchant. Then it became a "brute force" thing, looping through all the records one at a time. When it's the first row for a given merchant, I add a rowspan=MerchRecCount field to the first two column &lt;td&gt; tags; in all other rows for that merchant the first two column cells are omitted. There is a slight complication due to the paging of results (showing 20 at a time). But since I am already keeping track of the fact that "this is row n of MerchRecCount", it's easy to adjust the rowspan number accordingly for the first displayed row.</p> <p>The working results (as of today while I complete my testing) are on my site on the page at<br /> <a href="http://www.RewardsLookup.com/EarnSearch2.asp" class="bb-url">http://www.RewardsLookup.com/EarnSearch2.asp</a> </p> <p>By tomorrow I should have moved it over to the main search URL mentioned in the first message of this thread.</p> <p>------------------<br /> <a href="http://www.RewardsLookup.com" class="bb-url">http://www.RewardsLookup.com</a></p> Mon, 19 Jun 2000 17:58:00 +0000 KLWong comment 1031615 at https://www.webmaster-forums.net