List how many Sites have been indexed?

  • Hi,

    How can you show on your homepage how many sites are currently indexed by the search engine?

    -Dan


  • You should be able to do a mysql command to count the number of entries in the sites table to show the sites indexed.

    Something like this command from the mysql command prompt would show the number of sites:
    SELECT count(*) as num FROM phpdig_sites;

    (assuming your table is phpdig_sites, it could be just sites or something else).

    So you could do something like this (haven't tested, but hopefully the idea is clear):
    $num_sites = mysql_query("SELECT count(*) as num FROM phpdig_sites;");
    echo "Number of sites indexed: ";
    echo $num_sites;
    echo "n";
    ?>

    [Sorry for any typos, in a rush! ;-) ]







  • #If you have any other info about this subject , Please add it free.#
    Your name:
    E-mail:
    Telphone:

    Your comments:


    If you have any other info about List how many Sites have been indexed? , Please add it free.

    Jonas Brothers cd or what? Who's better for Nick Jonas - Miley Cyrus or Selena Gomez?