$rsCat = mysql_query("select c.catid, c.name, ( select count(v.id) from vendors v where v.catid = c.catid ) as num_vendors order by c.name asc") or die(mysql_error()); ?>
| Category ID | Category Name | Num Vendors |
|---|---|---|
| = $row["catid"]?> | = $row["name"]?> | = $row["num_vendors"]?> |