<? 		include ("connect/connect.inc"); 
		$sql= "SELECT *  FROM  `product` WHERE ProductType = 'casting' ORDER BY productID DESC"; 

    	$result = mysql_query($sql) or die ("Error Query1");
?>
<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd">
<html xmlns="http://www.w3.org/1999/xhtml">
<head>
<meta http-equiv="Content-Type" content="text/html; charset=utf-8" />
<title>spherejewel</title>
<link rel="stylesheet" type="text/css" href="css/style.css" />
<link rel="stylesheet" type="text/css" href="css/menu.css" />
</head>

<body>
<div style="min-height:100vh;height:auto; position:relative;padding-bottom:100px;">

    <div id="content" >
            <div align="center" >
                <img  src="images/logo.png" height="108px"  style="margin-top:30px;margin-bottom:30px" />
            </div>
        <div id="bgmenu"  >
                    <div id="bgmenu2">
                        <div id='cssmenu' >
                                <ul>
                                   <li class='has-sub'><a href='home.php'><span>HOME</span></a></li>
                                   <li class='has-sub'><a href='aboutUs.php'><span>ABOUT US</span></a></li>
                                   <li class='active'><a ><span>PRODUCTS</span></a> 
                                      <ul>
                                         <li ><a href='product_handmade.php' ><span>HANDMADE</span></a></li>
                                         <li ><a href='#' class="active"><span>CASTING</span></a></li>
                                      </ul>
                                   </li>
                                   <li class='has-sub'><a href='exhibition.php'><span>EXHIBITION </span></a></li>
                                   <li class='last'><a href='contact.php'><span>CONTACT</span></a></li>
                                </ul>
                                </div>
                    </div>
        </div> <!-------- menu   ---->
        
        <div id="sub_content" style="margin-top:130px;padding-bottom:0px;"> 
        
        		<table width="950px" align="center"  cellpadding="0" cellspacing="0" style="font-size:18px;font-family:MyriadPro-Semibold;" >
            	<tr valign="top" bgcolor="#A9A9AA" height="160">
                	<td  align="left" >
                    	<img src="images/casting_head.png" height="160px" />
                    	
                    </td>
                    <td align="right" style="font-family:TrajanPro-Bold">
                    	<div style="margin-right:20px;margin-top:30px;font-size:60px;color:#C7C7C9" >CASTING</div>
                    	<div style="margin-right:20px;margin-top:-10px;font-size:30px;color:#FFFFFF" >COLLECTION</div>
                    		
                    </td>
                </tr>
                <tr valign="top"  >
                	<td  colspan="2" align="center"  >
						<? while($row = mysql_fetch_array($result)){ ?>
                        <div style="width:860px;height:auto;position:relative;border-bottom :1px solid #D8D8D8;" align="center">
                        		<img src="product/<? echo $row['productImg']; ?>.png" width="860px" />
							<? if($row['productPattern'] == 1){ ?>
                    			<div class="head_hand" style="width:auto;left:30px;top:50px;"><? echo $row['productName']; ?></div>
                     
                        		
                        
                        	<? }else if($row['productPattern'] == 2){ ?>
                      			<div class="head_hand" style="width:auto;right:30px;top:50px;"><? echo $row['productName']; ?></div>
                        
                        
                        	<? }else if($row['productPattern'] == 3){ ?>
								<div class="head_hand" style="width:auto;left:30px;bottom:50px;"><? echo $row['productName']; ?></div>
                
                         	<? }else{ ?>	
								<div class="head_hand" style="width:auto;right:30px;bottom:50px;"><? echo $row['productName']; ?></div>
							
							<? } ?>
						</div>
                        
						<? } ?>

                    </td>
                </tr>
              </table>
        
        </div><!-------- sub_content   ---->
        
        
    </div><!-------   content--- - -----  -->

<div id="bottom"> 365/29-30 Soi Phayanak, Phayathai Road, Kwang Tanon Petchburi, Rajthevee District, Bangkok 10400 Thailand.</div>
    
</div><!---------max height ---->    

</body>
</html>