Count AND DISTINCT(url) combineren

$count = mysql_result(mysql_query("SELECT count(1) FROM cms_url"), 0);

$count = mysql_result(mysql_query("SELECT count(1) FROM cms_url"), 0);

$count = mysql_result(mysql_query("SELECT DISTINCT(url) count(1) FROM cms_url"), 0);

$count = mysql_result(mysql_query("SELECT DISTINCT(url) count(1) FROM cms_url"), 0);

$query = mysql_query("SELECT DISTINCT(url) COUNT(1) FROM cms_url") or die(mysql_error());
while($res = mysql_fetch_array($query)) {
// de rest
}

$query = mysql_query("SELECT DISTINCT(url) COUNT(1) FROM cms_url") or die(mysql_error());
while($res = mysql_fetch_array($query)) {
// de rest
}

<?php

    $countUrls = mysql_query("SELECT url, COUNT(*) AS aantal
                              FROM cms_url
                              GROUP BY url
                              ORDER BY aantal DESC");
    
    while ($cmsUrl = mysql_fetch_assoc($countUrls)) {

        $cmsUrl = array_map('stripslashes', $cmsUrl);
        $cmsUrl = array_map('htmlspecialchars', $cmsUrl);
        
        echo 'Url: ' . $cmsUrl['url'] . ', Aantal: ' . $cmsUrl['aantal'] . '<br />';
           
    }

<?php
 
    $countUrls = mysql_query("SELECT url, COUNT(*) AS aantal
                              FROM cms_url
                              GROUP BY url
                              ORDER BY aantal DESC");
 
    while ($cmsUrl = mysql_fetch_assoc($countUrls)) {
 
        $cmsUrl = array_map('stripslashes', $cmsUrl);
        $cmsUrl = array_map('htmlspecialchars', $cmsUrl);
 
        echo 'Url: ' . $cmsUrl['url'] . ', Aantal: ' . $cmsUrl['aantal'] . '<br />';
 
    }

SELECT count(DISTINCT url) FROM cms_url

SELECT count(DISTINCT url) FROM cms_url