Getting some info off a table

[marcebra]

Hello,

I have a table as follows:

Name | Type | Color | Notes

And I want my php page to show all the differnt "type"s that I have. I did this:

$result = mysql_query("SELECT * FROM tablename ORDER BY '$Type",$db);
$myrow = mysql_fetch_array($result);
echo "<tr><td><a href=\"type.php?Type=$myrow[Type]\">$myrow[Type]</a></td></tr>";

But it will show muliples of "type"s when there are more than one name associated with each one. How can I get php to check to see if it has not already found a type?

[LordShryku]

Why select *? Are you doing something with the other data? Why not just select distinct type from table?

[marcebra]

thanks for the prompt response.

would it be possible to count how many times each "type" is found. So on the table it prints out, it can have a column that shows the number of each type found in the table?

Thanks

[LordShryku]

  SELECT type,
         count(*)
    FROM table
GROUP BY type

[marcebra]

Thanks, but how would I be able to implement that into my script:

$result = mysql_query("SELECT DISTINCT Type FROM tablename ORDER BY '$Type",$db); 
$myrow = mysql_fetch_array($result); 
   do {
echo "<tr><td><a href=\"type.php?Type=$myrow[Type]\">$myrow[Type]</a></td><td>@@Insert Number of times here@@</td></tr>";
} while ($myrow = mysql_fetch_array($result));

Would i just make it: "SELECT Type, count(*) DISTICT Type"? Or do I need to maek two mysql queries?

[Weedpacket]

Originally posted by marcebra
Would i just make it: "SELECT Type, count() DISTICT Type"? Or do I need to maek two mysql queries?

Er, no, you'd make it

  SELECT type,
         count(*)
    FROM table
GROUP BY type