Select Across Multiple Tables

[raouleduke]

I want to compile a list of different tables and find out if there are records in each one pertaining to the user that logs in, then display links for each of the tables. I can get all the tables to show:

<?php
	mysql_connect("","",""); 
	mysql_select_db(""); 
	$query = "SELECT catagory FROM Dealers";
	$result = mysql_query($query);
	while ($row = mysql_fetch_array($result)){
	printf("<tr><td>%s</td></tr>\n",
	$row['catagory']	
	);
	}
	?>

Then I need to compile a list, and put them into another query,
SELECT * FROM "ALL TABLES" WHERE Some Conditon
Display Results as links, the links will be one of the TABLES.

Thanks in advance for the help.

[raouleduke]

Can anyone help me on this one. I got it to work partially.

<?php 
	mysql_connect("","",""); 
	mysql_select_db("a0020386"); 
	$sql1="SELECT catagory FROM Dealers"; 
	$res1=mysql_query($sql1) or die(mysql_error()); 
	while($row1=mysql_fetch_array($res1)) 
	{ 
  	$sql2="SELECT * FROM ".$row1['catagory']." WHERE HOLD LIKE 'N' AND FOLLOWUPCONTACT LIKE 'N' AND DEACTIVATE LIKE 'N' AND CALLER_ID = '8'"; 
  	$res2=mysql_query($sql2); 
  	while($row2=mysql_fetch_array($res2)) 
  	{ 
    echo($row1['catagory']."<br />\n"); 
  } 
} 
?> 

I am trying to Display the Catagory name, which is catagory, it working but displays all of them, how do I group the catagory to just display one so that I can us ahref and link to another page.

Thanks in advance.