Posted by Dejan on 04/12/06 15:34

How cann i display now name and count number in this code?

print "<table cellspacing=0 border=1 width=\"25%\" class=\"redovi\">\n";
print "<tr class=\"headline\"><td> Grad </td></tr>";
while ($qry = mysql_fetch_array($result)) {
print "<tr><td><a href=\"" . "prikaz_jednoga.php?id=$qry[id]\"
>$qry[id]</a></td>";
print "</tr>\n";
}
print "</table>\n";


Jerry Stuckle <jstucklex@attglobal.net> wrote in message
news:P4GdnYD8Gs3boqPZnZ2dnUVZ_tGdnZ2d@comcast.com...
> Arjen wrote:
> > Arjen wrote:
> >
> >>
> >> SELECT COUNT (id) GROUP BY name
> >
> >
> > Ehmm .... SELECT name, COUNT (id) FROM table ORDER BY name
>
>
> SELECT name, COUNT(id) FROM table GROUP BY name
>
> --
> ==================
> Remove the "x" from my email address
> Jerry Stuckle
> JDS Computer Training Corp.
> jstucklex@attglobal.net
> ==================

[Back to original message]