Php-mysql statement GROUP BY?

Tom

New member
im trying to count how many of the same item (in the same col but new rows) are the same and then display them .. i also need them as a variables as i need to use then later on in the page.

number title
1 text
2 text
1 text
2 text
2 text
4 text
1 text
1 text
1 text

I know i need to use the Group by , but i dont no how to display them on screen as i dont no if i put then into a while ($row = mysql_featch_array($****)){ }



any ideas?
 
Back
Top