 |
join 4 ตารางค่ะ ไม่แสดงในตารางเลยช่วยดูโค้ดให้หน่่อยนะคะ |
|
 |
|
|
 |
 |
|
เอาคำสั่ง query ใช้กับเครื่องมือช่วยดูก่อนว่าทำงานได้ไหม
|
 |
 |
 |
 |
Date :
2010-09-26 23:08:25 |
By :
dekkuza |
|
 |
 |
 |
 |
|
|
 |
 |
|
 |
 |
 |
|
|
 |
 |
|
??? ยกตัวอย่างสักนิดได้ไหมคะ มือใหม่ งงมาก
|
 |
 |
 |
 |
Date :
2010-09-26 23:10:53 |
By :
maltra |
|
 |
 |
 |
 |
|
|
 |
 |
|
 |
 |
 |
|
|
 |
 |
|
ขอลองก่อนนะคะขอบคุณค่ะ
|
 |
 |
 |
 |
Date :
2010-09-26 23:13:48 |
By :
maltra |
|
 |
 |
 |
 |
|
|
 |
 |
|
 |
 |
 |
|
|
 |
 |
|
อีกนิดได้ไหมคะ ยังไม่ได้เลยค่ะไม่โชว์เหมือนเดิมCode (PHP)
SELECT company.c_id AS a, company.cname AS b, companytype.ctname AS c, company.caddress AS d, worktime.woname As e, location.loname As f, company.zipcode AS g, company.phone AS h,company.fax AS i
FROM (company INNER JOIN worktime ON company.c_id = worktime.worktimeid)
INNER JOIN location ON company.c_id = location.locationid INNER JOIN companytype ON company.c_id = companytype.ctypeid;";
echo $sql;
$db_query=mysql_db_query($db,$sql);
$result=mysql_fetch_array($db_query);
$c_id=$result[a];
$cname=$result;
$caddress=$result[c];
$zipcode=$result[d];
$ctname=$result[e];
$woname=$result[f];
$loname=$result[g];
$phone=$result[h];
$fax=$result[i];
|
 |
 |
 |
 |
Date :
2010-09-26 23:33:53 |
By :
maltra |
|
 |
 |
 |
 |
|
|
 |
 |
|
 |
 |
 |
|
|
 |
 |
|
ได้แล้ว ค่ะ ขอบคุณคุณ num จากบอร์ด https://www.thaicreate.com/php/forum/029741.html
  
Code (PHP)
SELECT c_id, cname, caddress, zipcode,phone, fax,
companytype.ctname, worktime.woname ,location.loname
FROM company INNER JOIN companytype ON company.ctypeid
= companytype.ctypeid INNER JOIN worktime ON
company.worktimeid = worktime.worktimeid INNER JOIN
location ON company.locationid = location.locationid
|
 |
 |
 |
 |
Date :
2010-09-27 08:08:08 |
By :
maltra |
|
 |
 |
 |
 |
|
|
 |
 |
|
 |
 |
|
|