tabel1=produk, tabel2=produk2 caranya gmana biar bisa tampil semua?

<?
while ($row=mysql_fetch_array($query)){
$idshop=$row;
$idbrg=$row;
$iduser=$row;

$trow=mysql_fetch_array($pemesanan);
$idpesan=$trow;

//translate id

$transbrg=mysql_db_query($db,"select * from produk inner join produk2 where idbrg='$idbrg'",$koneksi);


while ($row=mysql_fetch_array($transbrg)){
$namabrg=$row;
$hargabrg=$row;
$total=$hargabrg+$total;
}

?>

<?
			while ($row=mysql_fetch_array($query)){
			$idshop=$row['idshop'];
			$idbrg=$row['idbrg'];
			$iduser=$row['iduser'];
			
			$trow=mysql_fetch_array($pemesanan);
			$idpesan=$trow['idpesan'];
			
				//translate id
			
			$transbrg=mysql_db_query($db,"select * from produk inner join produk2 where idbrg='$idbrg'",$koneksi);	
			
			
				while ($row=mysql_fetch_array($transbrg)){
					$namabrg=$row['namabrg'];
					$hargabrg=$row['hargabrg'];
					$total=$hargabrg+$total;
				}
				
			?>