[RESOLVED] Sorting records

[webmasternovis]

Hi all,

I have two tables. One table contains general information about a company, while the other contains bids for it. I want to sort the companies in terms of how many bids they have, does anyone know how I could do this?

Thanks,
Mike

[laserlight]

Have a join that groups by the count of bids, then sort based on this count.

[Desdinova]

Try something like this:

$query = "SELECT C.Company, Count(B.*) AS Numbids FROM Companies AS C LEFT JOIN Bids AS C ON C.ID = B.CompanyID GROUP BY C.ID ORDER BY Company ASC, B.Numbids DESC";

didn't test it. should be about right, but might contain some errors. Do replace the fields with your field and table names

[laserlight]

Oh yes, group by company, not count of bids. You probably do not want to sort by company name though, since the intention is to sort by the count of bids.

[webmasternovis]

Perfect, thanks!