Not getting all my search results

[cs1h]

Hi,

 

I have a a script that gathers information from three different databases and displays the data in the same table, it is designed top do this for three times. The first database gets the code to access the second database, the second database is where most the information is stored and a piece of information from the second database is whats used to search the third on for the information that is needed.

 

The problem is that its getting the first result from the third database but its not getting the second or third result from the third database.

 

The code is

 

<?php 

mysql_connect("localhost","aaaa","aaaa"); 

mysql_select_db("raaaal") or die("Unable to select database");

$art = $_GET['id'];
$sql = "SELECT * FROM items WHERE id=$art";

$result = mysql_query($sql)or die(mysql_error());
$num_rows = mysql_num_rows($result);
if($num_rows == 0) {
echo "No results please try a different <a href=asearch.html>search</a>.";
} else {
while($row = mysql_fetch_array($result)) {
$code1 = $row['code1']; 
$code2 = $row['code2'];

mysql_close();

}
}

mysql_connect("localhost","ssss","ssss"); 

mysql_select_db("ssss") or die("Unable to select database"); 

$sql = "SELECT * FROM `$code1 by $code2` ORDER BY id DESC LIMIT 3";

$result = mysql_query($sql) or die(mysql_error());

$num_rows = mysql_num_rows($result);
if($num_rows == 0) {
echo "";
} else {
$CommAuth = array();
$Comment = array();
$horde = array();
$title = array();

while($row = mysql_fetch_assoc($result)) {
$CommAuth[] .= $row['name']; 
$Comment[] .= $row['message'];
$horde[] .= $row['horde'];
$title[] .= $row['title'];

}
}


mysql_close();

mysql_connect("localhost","dddd","dddd"); 

mysql_select_db("dddd") or die("Unable to select database");

$sql2 = "SELECT * FROM ac_users WHERE username IN  ( ";
foreach($title as $t)
$sql2 .= " '$t',";
$sql2 = rtrim($sql2, ',');
$sql2 .= ' ) LIMIT 3 '; 

$result2 = mysql_query($sql2)or die(mysql_error());
$num_rows2 = mysql_num_rows($result2);
if($num_rows2 == 0) {
echo "No results please try a different <a href=reports.php>search 2</a>.";
} else {
$CommAvatar = array();
while($row2 = mysql_fetch_array($result2)) {
$CommAvatar[] .= $row2['avatar'];

}
}
$count = 0;
foreach ($CommAuth as $value){

print "<div id=\"comment\">
<img src=\"/avatar/{$CommAvatar[$count]}\" width=\"56\" height=\"56\" class=\"comment_photo\" />
<div id=\"comment_header\"><span class=\"comment_author\"> {$value} </span><span class=\"comment_wrote\">wrote...</span><span class=\"comment_stars\"><img src=\"stars_5.png\"/></span></div>
<div class=\"comment_text\">{$Comment[$count]}</div>
<div id=\"comment_footer\"><span class=\"comment_delete\">Report | Comment on {$value} Profile | Message {$value}</span></div>
</div>";
$count++;
}
?>

 

Does anyone know how to solve this?

 

Thanks,

Colin