How to order name as number?

hello everyone how can i put a name into a number?

i have this but it shows the coin name but i like it to show the name as number

  <?php 
$query = "SELECT coin, COUNT(*) FROM list GROUP BY coin";
$result = mysqli_query($link,$query);
$rows = mysqli_fetch_row($result);
echo $rows[0]; 
?>             

because the coin name is the first item in the row.

How would that look like?

ok
you know stats? will i like the name to show as number so it be

Total coins supported
300

I don’t.

like

echo 'Total coins supported: ', $row[0]

Yes but i already have this i just cant get the name to display as the number

That should be…

echo 'Total coins supported: ', $row[1]

Oh look at that LoL
i have find my own problem

SELECT COUNT( DISTINCT coin ) FROM list

will thanks for the help :stuck_out_tongue:

So… you were trying to get a number equal to the number of types of coins? Cause that’s what you’ve generated.

1 Like

This topic was automatically closed 91 days after the last reply. New replies are no longer allowed.