|
Pour Stan
Solution finale :
j'ai bossé ça ce midi:
Avec la table suivante
#
# Structure de la table `table_test`
#
| quote: | CREATE TABLE table_test (
nom varchar(16) NOT NULL default ''
) TYPE=MyISAM;
#
# Contenu de la table `table_test`
#
INSERT INTO table_test VALUES ('Armin');
INSERT INTO table_test VALUES ('Shito');
INSERT INTO table_test VALUES ('Lytchix');
INSERT INTO table_test VALUES ('Stan');
INSERT INTO table_test VALUES ('Tiesto');
INSERT INTO table_test VALUES ('Svenson');
INSERT INTO table_test VALUES ('Gielen');
INSERT INTO table_test VALUES ('Dumonde'); |
Le source php
| quote: |
mysql_connect('localhost', 'test', '')
or die(mysql_error());
mysql_select_db('test')
or die(mysql_error());
$lettre = 'A';
echo '';
for ($i=0 ; $i<26; $i++) {
$query = 'SELECT COUNT(*) FROM table_test WHERE nom LIKE "' . $lettre . '%";';
$result = mysql_query($query)
or die(mysql_error());
$row = mysql_fetch_row($result);
if ($row[0])
echo $lettre, " => ", $row[0], "\n";
$lettre++;
}
echo ' ';
?> |
La sortie ça donne ça:
| quote: | A => 1
D => 1
G => 1
L => 1
S => 3
T => 1 |
Voilà voilà 
|
