|
Server : Apache/2.2.2 (Fedora) System : Linux App1.pathumtani.go.th 2.6.20-1.2320.fc5smp #1 SMP Tue Jun 12 19:40:16 EDT 2007 i686 User : apache ( 48) PHP Version : 5.2.9 Disable Function : NONE Directory : /home/pathumthani_integration/integration/application/industry/ |
Upload File : |
<?php
session_start() ;
header("Content-Type: text/html; charset=windows-874");
include_once("../../config/config_epm.inc.php");
include_once("function/function.inc.php");
?>
<table width="500" border="0" cellspacing="0" cellpadding="0">
<tr>
<td width="27%"> </td>
<td align="right"> </td>
<td align="right"> </td>
<td> </td>
</tr>
<?
$sqlIndustry=" SELECT *
FROM industry_shop
WHERE industry_shop.runid='".$_GET['runid']."'
";
$rsIndustry=mysql_db_query($dbname,$sqlIndustry);
$resIndustry=mysql_fetch_assoc($rsIndustry);
$sqlType_1=" SELECT * FROM industry_shop_type WHERE runid = '".$resIndustry['type_id']."' "; // ประเภท
$rsType_1=mysql_db_query($dbname,$sqlType_1);
$resType_1=mysql_fetch_assoc($rsType_1);
$sqlTambol=" SELECT ccDigi,ccName,ccType FROM ccaa WHERE ccaa.ccType = 'Tamboon' AND ccaa.ccDigi = '".$resIndustry['tambol']."' ";
$rsTambol=mysql_db_query($dbname,$sqlTambol);
$resTambol=mysql_fetch_assoc($rsTambol);
$sqlAmphur=" SELECT ccDigi,ccName,ccType FROM ccaa WHERE ccaa.ccType = 'Aumpur' AND ccaa.ccDigi = '".$resIndustry['amphur']."' ";
$rsAmphur=mysql_db_query($dbname,$sqlAmphur);
$resAmphur=mysql_fetch_assoc($rsAmphur);
$sqlProvice=" SELECT ccDigi,ccName,ccType FROM ccaa WHERE ccaa.ccType = 'Changwat' AND ccaa.ccDigi = '".$resIndustry['province']."' ";
$rsProvice=mysql_db_query($dbname,$sqlProvice);
$resProvice=mysql_fetch_assoc($rsProvice);
$location=$resIndustry['location'].' '.$resTambol['ccName'].' '.$resAmphur['ccName'].' '.$resProvice['ccName'].' รหัสไปษณีย์ '.$resIndustry['zipcode'];
?>
<tr>
<td width="27%" rowspan="7" valign="top">
<div class="showimg">
<img src="<?=(str_replace('files_image/','',$resIndustry['image'])!='')?$resIndustry['image']:'../../images/nopicture.gif'?>" width=120 height=160 boder=0>
</div>
</td>
<td width="2%" align="left"> </td>
<td width="29%" align="right" valign="top"><strong>ประเภทแหล่งการค้า:</strong> </td>
<td width="42%" valign="top"><?=$resType_1['name']?></td>
</tr>
<tr>
<td align="left"> </td>
<td align="right" valign="top"><strong>ชื่อแหล่งการค้า:</strong> </td>
<td valign="top"><?=$resIndustry['name']?></td>
</tr>
<tr>
<td align="right"> </td>
<td align="right" valign="top"><strong>รายละเอียด:</strong> </td>
<td valign="top"><?=$resIndustry['detail']?></td>
</tr>
<tr>
<td align="left"> </td>
<td align="right" valign="top"><strong>ทำเลที่ตั้ง:</strong> </td>
<td valign="top"><?=$location?></td>
</tr>
<tr>
<td align="left"> </td>
<td align="right" valign="top"><strong>ตำแหน่งพิกัด:</strong> </td>
<td valign="top"> จุดพิกัดแกน x : <?=$resIndustry['gpsx']?><br /> จุดพิกัดแกน y : <?=$resIndustry['gpsy']?></td>
</tr>
<tr>
<td align="right"> </td>
<td colspan="2">
<?php /*?><DIV style="background-color:#EEEEEE; padding:5px; border:#CCCCCC 1px solid; margin:2px;">
<?php
echo "<pre>";
print_r($_GET);
echo "</pre>";
?>
</DIV><?php */?>
</td>
</tr>
</table>