Can I group results by domain ?

pk · Post by pk » Fri Jun 08, 2001 9:02 am

Hi,

Grouping is a pretty standard SQL feature.
I would like to group my webinator-results by domain,
is there a way to do this ?

The default webinator returns numerous pages on the same domain that I am not interested in, I´d rather have the results display a choice of different domains on the first page.

Thanks,

Rob

bart · Post by **bart** » Fri Jun 08, 2001 9:45 am

Yes, Webinator could group by domain with the proper code. The HTML table within Webinator does not keep the domain separately though, it just stores the whole url within one field. To use GROUP BY you'd have to add a field to store the domain by itself. Using ORDER BY Url and then checking for repeated domain prefixes would have the same effect without altering the table schema.

Post by **mark** » Fri Jun 08, 2001 10:44 am

If you're looking to display only one page per domain see http://thunderstone.master.com/texis/ma ... 3b1bcd6711