<?php
$dbhost = 'localhost';
$dbuser = 'root';
$dbpass = 'WELCHgrape55';
$conn = mysql_connect($dbhost, $dbuser, $dbpass) or die ('Error connecting to mysql');
$dbname = 'dasr';
mysql_select_db($dbname);

$q = "select count(*) from bedfile_real";
$result = mysql_query($q);
while($row = mysql_fetch_array($result))
  {
  echo "$q:	".$row[0]."\n";
  }

$q = "select count(*) from summarybed_real";
$result = mysql_query($q);
while($row = mysql_fetch_array($result))
  {
  echo "$q:	".$row[0]."\n";
  }
  
$q = "select count(*) from agbed_real";
$result = mysql_query($q);
while($row = mysql_fetch_array($result))
  {
  echo "$q:	".$row[0]."\n";
  }

$q = "select count(*) from microbed_real";
$result = mysql_query($q);
while($row = mysql_fetch_array($result))
  {
  echo "$q:	".$row[0]."\n";
  }

$q = "select count(*) from rawbed_real";
$result = mysql_query($q);
while($row = mysql_fetch_array($result))
  {
  echo "$q:	".$row[0]."\n";
  }

?>