Re: Sort array from a Query

Thank you. Now it works. I wrote like that:

$search_breweries = mysql_query("SELECT b.BREWERY_CODE, b.BREWERY,
COUNT(c.ID) as cant FROM breweries as b JOIN coasters as c ON
b.BREWERY_CODE = c.BREWERY_CODE Group by b.BREWERY_CODE order by cant
DESC ");

Sean schrieb:

> Follow this up in the sql forums, but you want something like this:
>
> SELECT b.BREWERY_CODE, b.BREWERY, COUNT(c.id) as num_coaster
> FROM breweries b LEFT JOIN coasters c ON b.BREWERY_CODE =
> c.BREWERY_CODE
> Group by b.BREWERY_CODE
> order by COUNT(c.id) DESC
>
> UNTESTED!
>
> This will get you what you want in one pass. (i think)

.

Relevant Pages

  • Re: Sort array from a Query
    ... Follow this up in the sql forums, but you want something like this: ... FROM breweries b LEFT JOIN coasters c ON b.BREWERY_CODE = ... Prev by Date: ...
    (comp.lang.php)
  • Re: Sort array from a Query
    ... COUNTFROM breweries as b JOIN coasters as c ON ... result resource in.... ... Prev by Date: ...
    (comp.lang.php)