php content display in own page

[Remote Control]

Hi All,

 

I am currently upgrading a site and would like to combine 2 pages into 1, Currently I have a page that displays band names pulled from a db with sql, I want make it so when a user clicks on the band name a list of their release's displays is pulled from the db and displayed on the page.

 

I am stuck with which way to do this and am not sure it needs to be AJAX or CSS.

 

Here is the code that display the band name at the moment

 

echo "<table>";
while ($row=SQL_fetch_array($res)){
		echo "<tr><td>";
		$ren_url=make_redundant_url($row['title']);
		echo "</td><td><a href='band_info.php?id=".$row['id_band']."$ren_url'>".$row['title']."</a></td>";

		echo "</tr>";
}			
echo "</table>";			
?>

 

And here is the code that displays that displays the releases at the moment

 

while ($row=SQL_fetch_array($res)){
		$ren_url=make_redundant_url($row['bandname'],$row['title']);
		echo "<div class=\"catalogue_item\"><a href='release_detail.php?id=".$row['id_release'].$ren_url."'><img src='tinyimage.php?file=uploads/releases/".$row['imageurl']."' border='0'></a><a href='release_detail.php?id=".$row['id_release'].$ren_url."'>".$row['catnum']."</a> <b>".$row['bandname']."</b>-<i>'".$row['title']."'</i> ".$row['type'];
			if ($row['date_avail']<>""){
				if ($row['date_avail']>time()){
					echo " <u><i>available ".date("D d M",$row['date_avail'])."</i></u> ";
				}
			 }				
			 if ($row['new']==1){
				echo " <b><font color='#FF0000'>NEW!!</font></a></b> ";
			 }				
		echo "</div>";
}			
?>

 

As always any help would be appreciated[/code]