Array Troubles

[Anon]

Good Morning,

Here's the code I'm working with :

<?php
$array = array ("backcountry", "ballooning", "birding", "biking", "climbing", "equine", "fishing", "golf", "hunting", "parasailing", "rivers", "scuba", "sailing", "skiing", "skydiving", "spelunking", "surfing");

echo "<CENTER><BR>";
echo "<UL>";

while ($array) {
$db = mysql_connect("xxx", "xxx");
mysql_select_db("xxx",$db);
$table = array_values($array);
echo "$table";
$sql = "SELECT * FROM $table WHERE Status=´HIDDEN´";
$result = mysql_query($sql);
$myrow = mysql_fetch_array($result);
$total = count($myrow);
$category = ucfirst($table);

  printf("<LI>[%s]<A HREF=\"xxx.php3?table=%s\">$category</A>", $total, $table);
  }

echo "</UL>";
echo "<CENTER>";

?>

Basically, I've loaded up an array (at the top of the code) with all the table names I have in a mySQL database. I want to do a query on each table for the number of entries that exists where Status=HIDDEN, and then present that info in bulleted form with a link to a page that will allow me to do things with that info. I'm having trouble with the array portion of it. Can anyone help?

Thanks!

Mark

[[deleted]]

change this

while ($array) {
$db = mysql_connect("xxx", "xxx");
mysql_select_db("xxx",$db);
$table = array_values($array);
echo "$table";
$sql = "SELECT * FROM $table WHERE Status=´HIDDEN´";
$result = mysql_query($sql);
$myrow = mysql_fetch_array($result);
$total = count($myrow);
$category = ucfirst($table);

                               printf("
                               [%s]<A HREF=\"xxx.php3?table=%s\">$category</A>", $total, $table); 

}

to this

$db = mysql_connect("xxx", "xxx");
mysql_select_db("xxx",$db);

for ($t=0;$t<count($array);$t++)
{
$table = $array[$t];
$sql = "SELECT count(*) as c FROM ".$table." WHERE Status=´HIDDEN´";
if ($result = mysql_query($sql))
{
$myrow = mysql_fetch_array($result,MYSQL_ASSOC);
$total = $myrow['c'];
$category = ucfirst($table);
printf("[%s]<A HREF=\"xxx.php3?table=%s\">$category</A>", $total, $table);
}
else
{
echo mysql_error();
};
}

[spider_man]

Hi.

<?

$array = blah, blah, blah;

foreach ($array as $table)
$selects[] = "select * from $table where status='hidden'";

$select = join(' union ', $selects);
free($selects, $array); / or something like that /

$results = mysql_query($select);

?>

Now you have to deal with the results, boy!
Good luck.

[Anon]

Vincent,

Thanks for the help. It works perfectly, and I understand what you did.

Mark