View Single Post
Old 11-17-2006, 06:00 AM   #2
CentaurAtlas
Green Mole
 
Join Date: Nov 2006
Location: Florida
Posts: 11
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! ;-) ]

Last edited by CentaurAtlas; 11-17-2006 at 06:03 AM.
CentaurAtlas is offline   Reply With Quote