Hi,
Doing a simple CD database with php and mysql..
On my page I am displaying Total CD = 176, that is easy as each record count..
however, I would like to display the number of Artists, but I need to count the artist only once or the Total ARTIST = 176..
Do I do this in my SQL recordset or i nmy page code..?
Here is the example of total CD's:
mysql_select_db($database_MP3, $MP3);
$query_rsArtists = "SELECT Artist FROM MP3new";
$rsArtists = mysql_query($query_rsArtists, $MP3) or die(mysql_error());
$row_rsArtists = mysql_fetch_assoc($rsArtists);
$totalRows_rsArtists = mysql_num_rows($rsArtists);
Artists: <?php echo $totalRows_rsArtists ?>
Any suggestions appreciated!
Regards.. Ken
