| 
 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 
> ==================
 
  
Navigation:
[Reply to this message] 
 |