PDA

View Full Version : List how many Sites have been indexed?


Dan
10-29-2006, 12:15 PM
Hi,

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

-Dan

CentaurAtlas
11-17-2006, 07:00 AM
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):
<?php
$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! ;-) ]