yang sy ingin tampilkan adalah : table Produk beserta sisa stok dari beberapa toko...
table sql:
PRODUK

REATE TABLE IF NOT EXISTS `produk` (
  `ID_PROD` int(11) NOT NULL AUTO_INCREMENT,
  `Merek` varchar(64) DEFAULT NULL,
  `Type` varchar(64) DEFAULT NULL COMMENT 'Type',
  `Harga` varchar(12) DEFAULT NULL COMMENT 'Harga',
  PRIMARY KEY (`ID_PROD`)
) ENGINE=InnoDB  DEFAULT CHARSET=latin1 AUTO_INCREMENT=317 ;

STOK TOKO

CREATE TABLE IF NOT EXISTS `stock_hp` (
  `ID` int(11) NOT NULL AUTO_INCREMENT,
  `ID_PROD` int(11) DEFAULT NULL,
  `Nama_Toko` varchar(32) NOT NULL,
  `Jumlah_stok` int(11) DEFAULT NULL,
  PRIMARY KEY (`ID`)
) ENGINE=InnoDB  DEFAULT CHARSET=latin1 AUTO_INCREMENT=828 ;

Tampilannya seperti ini, Untuk Tokonya bisa dinamis nantinya bisa di tambahkan lagi atau di kurangi toko1,2,3 dst

<table width="100%" border="1">
  <tr>
    <td><strong>NO</strong></td>
    <td><strong>MEREK</strong></td>
    <td><strong>TYPE</strong></td>
    <td><strong>HARGA</strong></td>
    <td><strong>Toko1</strong></td>
    <td><strong>Toko2</strong></td>
    <td><strong>Toko3</strong></td>
    <td><strong>Toko4</strong></td>
  </tr>
  <tr>
    <td>1</td>
    <td>NOKIA</td>
    <td>1280</td>
    <td>Rp.230.000</td>
    <td>2 unit</td>
    <td>2 unit</td>
    <td>1 unit</td>
    <td>0 unit</td>
  </tr>
  <tr>
    <td>2</td>
    <td>BLACKBERRY</td>
    <td>8520</td>
    <td>Rp.1.750.000</td>
    <td>1 unit</td>
    <td>1 unit</td>
    <td>1 unit</td>
    <td>2 unit</td>
  </tr>
  <tr>
    <td>3</td>
    <td>SAMSUNG</td>
    <td>E1195</td>
    <td>Rp.330.000</td>
    <td>0 unit</td>
    <td>4 unit</td>
    <td>0 unit</td>
    <td>1 unit</td>
  </tr>
  <tr>
    <td>4</td>
    <td>SONY</td>
    <td>ST17I</td>
    <td>Rp.3.500.000</td>
    <td>3 unit</td>
    <td>0 unit</td>
    <td>2 unit</td>
    <td>3 unit</td>
  </tr>
</table>

saya mohon bantuannya untuk solusinya dari master2 ku semua....
Sebelumnya terima kasih..

<?php
$conn = mysql_connect("localhost","root","");
mysql_select_db("sagitamo_stock",$conn);
$sql = "select * from produk p inner join stock_hp s on p.ID_PROD=s.ID_PROD";
$result = mysql_query($sql);
?>


<table cellpadding="5" cellspacing="0" border="1">
	<tr>

		<th>Merek</th>
		<th>Type</th>
		<th>Harga</th>
		<th>TOKO WOSI</th>
        <th>TOKO SANGGENG</th>
	</tr>
             
             
<?php while ($produk = mysql_fetch_array ($result)) {?>
	<tr>
    
		<td><?php echo $produk['Merek'];?></td>
		<td><?php echo $produk['Type'];?></td>
		<td><?php echo $produk['Harga'];?></td>
        <td><?php if($produk['Nama_Toko'] == 'WOSI') echo $produk['Jumlah_stok'];?></td>
         <td><?php if($produk['Nama_Toko'] == 'SANGGENG') echo $produk['Jumlah_stok'];?></td>
 
	</tr>
	<?php }?>
</table>

<?php
mysql_connect("localhost","root","");
mysql_select_db("help");
$sql = "select merk,harga,type,nama_toko,jumlah_stock from toko, stok where stok.id_prod = toko.id_prod";
$result = mysql_query($sql);
?>
 
 
<table cellpadding="5" cellspacing="0" border="1">
	<tr>
 
		<th>Merek</th>
		<th>Type</th>
		<th>Harga</th>
		<th>TOKO WOSI</th>
        <th>TOKO SANGGENG</th>
	</tr>
 
 
<?php while ($produk = mysql_fetch_array ($result)) 
{?>
	<tr>
 
		<td><?php echo $produk['merk'];?></td>
		<td><?php echo $produk['type'];?></td>
		<td><?php echo $produk['harga'];?></td>
		<td><?php if($produk['nama_toko'] == 'WOSI') echo $produk['jumlah_stock'];?></td>
		<td><?php if($produk['nama_toko'] == 'SANGGENG') echo $produk['jumlah_stock'];?></td>

 
	</tr>
	<?php }?>
</table>