Hi,
why this doesn't work:
$sql = "SELECT * FROM ".$code." WHERE Name != '' GROUP BY Cat ORDER BY Cat ASC";
$result = mysql_query($sql) or die('Erreur : '.mysql_error());
$query = mysql_num_rows($result);
In the Cat column, i've got;
3 row = 12
2 row = 21
1 row = 44
if i echo $query, i get 1 ... but i'm suppose to get 3??????
nomad9