Code: Select all
$query = mysql_query("SELECT name, COUNT(*) AS number FROM $table GROUP BY name");
if ( mysql_num_rows($query) == 0 ) echo "No rows in the database";
while ($row = mysql_fetch_array($query)) {
$name = $row['name'] ;
$count = $row['number'] ;
echo "$name has $count rows in the database<br>";
}
Code: Select all
while ($row = mysql_fetch_array($query,MYSQL_NUM)) $output .= "\"" . implode("\",\"",str_replace("\r\n"," ",$row)) . "\"\r\n";
echo $output; // or write $output to a file
Code: Select all
$query = mysql_query("SELECT COUNT(*) AS number FROM $table LIMIT 1");
$row = mysql_fetch_array($query);
if ($row['number'] > 1000 ) echo "You have over 1,000 rows";