ดู insert ให้ทีครับ <? include "../include/config.inc.php";?>

<? include "../include/config.inc.php";?>
<form action="car_garage_record.php" method="post" enctype="multipart/form-data" name="form1">
  <table width="90%" border="0" align="center" cellpadding="4" cellspacing="0">
    <tr>
      <td colspan="4"><p class="style1">อู่ซ่อมรถ<br><br>
      </td>
    </tr>
    
    <tr>
      <td width="30%" rowspan="14" bgcolor="#000000"><span class="style9"></span></td>
      <td><div align="right" class="style7">Email</div></td>
      <td>:</td>
      <td><input name="email" type="text"  id="email" value="<?=$email?>" size="30" /></td>
    </tr>
    <tr>
      <td width="21%"><div align="right" class="style7">web site</div></td>
      <td width="0%">:</td>
      <td><input name="web" type="text" id="web" value="<?=$web?>" size="40"/></td>
      </tr>
   <tr>
      <td><div align="right" class="style7">ชื่อศูนย์ซ่อม</div></td>
      <td>:</td>
      <td><input name="company" type="text" id="company" value="<?=$company?>" size="30"/></td>
    </tr>
    <tr>
      <td><div align="right" class="style7">ที่อยู่</div></td>
      <td>:</td>
      <td><textarea name="address" cols="30" rows="3" id="address" value="<?=$address?>"/></textarea></td>
    </tr>
    <tr>
      <td><div align="right" class="style7">โทร</div></td>
      <td>:</td>
      <td><input name="tel"  type="text" id="tel" value="<?=$tel?>" size="30"/></td>
    </tr>
    <tr>
      <td><div align="right" class="style7">โทรสาร</div></td>
      <td>:</td>
      <td><input name="fax" type="text" id="fax" value="<?=$fax?>"/></td>
    </tr>
    <tr>
      <td><div align="right" class="style7">ติดต่อคุณ</div></td>
      <td>:</td>
      <td><input name="name" type="text" id="name" value="<?=$name?>"/></td>
    </tr>
    <tr>
      <td><div align="right" class="style7">มือถือ</div></td>
      <td>:</td>
      <td><input name="mobile" type="text" id="mobile" value="<?=$mobile?>"/></td>
    </tr>
    

    <tr>
      <td><table width="100%" height="100" border="0" cellpadding="2" cellspacing="0" >
        <tbody>
          <tr valign="top" align="right">           
            <td width="14%" ><div class="style7">ประเภทซ่อม</div></td>                                   
          </tr>
          <tr valign="top" align="right">
            <td width="19%" ><div class="style7">ซ่อมประเภท</div></td>                                           
          </tr>
        </tbody>
      </table></td>
      <td>:</td>
      <td><table width="100%" height="100" border="0" cellpadding="2" cellspacing="0" >
        <tbody>
          <tr valign="top" align="left">
            <td width="19%"><input name="car_type" type="checkbox" id="car_type" value="Y"  readonly="readonly" <? if($Rw['car_type']=="Y"){?> checked="checked"<? }?>/>
              รถญี่ปุ่น</td>
            <td width="17%"><input name="car_type2" type="checkbox" id="car_type2" value="Y" readonly="readonly" <? if($Rw['car_type2']=="Y"){?> checked="checked"<? }?> />            
              รถยุโรป</td>
            <td width="16%"><input name="car_type3" type="checkbox" id="car_type3" value="Y"  readonly="readonly" <? if($Rw['car_type']=="Y"){?> checked="checked"<? }?>/>
            อื่นๆ</td>
            <td width="19%" bgcolor="#FFFFFF">&nbsp;</td>
            <td width="29%" bgcolor="#FFFFFF">์</td>
          </tr>
          <tr valign="top" align="left">
            <td width="19%"><input name="repair_type" type="checkbox" id="repair_type" value="Y" readonly="readonly" <? if($Rw['repair_type']=="Y"){?> checked="checked"<? }?> />
            เครื่องยนต์</td>
            <td width="17%"><input name="repair_type2" type="checkbox" id="repair_type2" value="Y" readonly="readonly" <? if($Rw['repair_type2']=="Y"){?> checked="checked"<? }?> />
            เกียร์</td>
            <td width="16%"><input name="repair_type3" type="checkbox" id="repair_type3" value="Y" readonly="readonly" <? if($Rw['repair_type3']=="Y"){?> checked="checked"<? }?> />
            ช่วงล่าง</td>
            <td width="19%"><input name="repair_type4" type="checkbox" id="repair_type4" value="Y"  readonly="readonly" <? if($Rw['repair_type4']=="Y"){?> checked="checked"<? }?>/>
            ทำสีตัวถัง</td>
            <td width="29%"><input name="repair_type5" type="checkbox" id="repair_type5" value="Y" readonly="readonly" <? if($Rw['repair_type5']=="Y"){?> checked="checked"<? }?> />
            ไฟฟ้ารถยนต์</td>
          </tr>
        </tbody>
      </table></td>
    </tr>
    <tr>
      <td><div align="right" class="style8">view1</div></td>
      <td>:</td>
      <td><label>
        <input name="fileupload" type="file" id="fileupload">
        <span class="style3">jpg,gif และ png เท่านัน </span> <br>
        <? if($Rw['pic'] != ""){?>
        <img src="../car_small/<?=$Rw['pic']?>">
        <? }?>
      </label></td>
    </tr>
    <tr>
      <td><div align="right" class="style8">view2</div></td>
      <td>:</td>
      <td><input name="fileupload2" type="file" id="fileupload2">
        <span class="style3">jpg,gif และ png เท่านัน </span> <br>
        <? if($Rw['pic2'] != ""){?>
        <img src="../car_small/<?=$Rw['pic2']?>"  />        <? }?></td>
    </tr>
    <tr>
      <td><div align="right" class="style8">view3</div></td>
      <td>:</td>
      <td><input name="fileupload3" type="file" id="fileupload3">
        <span class="style3">jpg,gif และ png เท่านัน </span> <br>
        <? if($Rw['pic3'] != ""){?>
        <img src="../car_small/<?=$Rw['pic3']?>"  />        <? }?></td>
    </tr>
    
    <tr>
      <td><span class="style7"></span></td>
      <td>&nbsp;</td>
      <td>&nbsp;</td>
    </tr>
    <tr>
      <td><span class="style7"></span></td>
      <td>&nbsp;</td>
      <td><label>
        <input type="submit" name="Submit" value="บันทึก">
        <input type="reset" name="Submit2" value="ยกเลิก" />
        <input type="hidden" name="action" value="<?=$action?>" />
        <input name="ID" type="hidden" id="ID" value="<?=$ID?>" />
      </label></td>
    </tr>
  </table>
</form>

<? include "../include/config.inc.php";
if($_POST['action']="Create")
{
$Sq="INSERT INTO db_garage (email, web_url, company_name, address, tel, fax, name, mobile, car_type, car_type2, car_type3, repair_typr, repair_type2, repair_type3, repair_type4, repair_type5, pic, pic2, pic3)
VALUES('$_POST[email]','$_POST[web]','$_POST[company]','$_POST[address]','$_POST[tel]','$_POST[fax]','$_POST[name]',
'$_POST[mobile]','$_POST[car_type]','$_POST[car_type2]','$_POST[car_type3]','$_POST[repair_type]','$_POST[repair_type2]',
'$_POST[repair_type3]','$_POST[repair_type4]','$_POST[repair_type5]','$_POST[pic]','$_POST[pic2]','$_POST[pic3]')";
mysql_query($Sq))
mysql_close();

}
?>