Anonymous

<?php
  
$user = "*";
$pass = "*";
$connect = mysql_connect('localhost',$user,$pass) or die("Cannot connect to mySQL");
$catnames = "action,adventure,comedy,crime,fighting,horror,kids,music,other,scifi,television";
$cn = explode(",",$catnames);
$db = "dvddb";
$results = array();
mysql_select_db($db) or die("Cannot connect to database");

for ($i = 0; $i < count($cn); $i++) {
    $querystr = "SELECT * FROM $cn[$i] WHERE title LIKE '%star trek%'";
    $query = mysql_query($querystr) or die("mysql query failed");
    $total = mysql_num_rows($query);
    $array = mysql_fetch_array($query);
    $results = array($array);;
}

for ($i = 0; $i < count($results); $i++) {
    while (list($n,$v) = each($results)) {
        echo("$n => $v");
    }
}

?>