I have MySql table like this :
+----+----+----+
| g1 | g2 | g3 |
+----+----+----+
| 1 | 2 | 5 |
+----+----+----+
| 5 | 1 | 3 |
+----+----+----+
| 1 | 3 | 4 |
+----+----+----+
And I need get output in PHP like:
number 1 is used 4 times
number 2 is used 1 time
number 3 is used 2 times
I make some code but it only write me how many time I used the number and I don't know how to add whitch number. Thi is my code:
for ( $i=1 ; $i<=20; $i++){
$query = mysql_query("SELECT g1, g2, g3d FROM users
WHERE g1 = $i OR g2 = $i OR g3 = $i ") or die(mysql_error()) ;
$row1 = mysql_num_rows($query);
$row = mysql_fetch_array($query) ;
if ($row1 >=1){echo $row1; }
}
Thanks for any help.
Aucun commentaire:
Enregistrer un commentaire