[請益] JOIN的問題
product資料表中：有p_id(唯一)、c_id、p_name欄位
例如：p_id:1234 c_id:1 p_name:ADOBE
p_id:6789 c_id:1 p_name:MICROSOFT
webhd資料表中：有f_id(唯一)、p_id、c_id、f_name欄位
例如：f_id:1 p_id:1234 c_id:1 f_name:file1
f_id:2 p_id:1234 c_id:1 f_name:file2
若要將上面JOIN起來，$row2會抓不到值
$SQLStr2 = "SELECT product.*, webhd.* FROM product AS product ";
$SQLStr2 .= "LEFT JOIN webhd AS webhd ON product.p_id = webhd.p_id WHERE
c_id='$c_id'";
$res2 = mysql_query($SQLStr2);
$row2 = mysql_fetch_array($res2);
是哪裡錯了呢？
--
※ 發信站: 批踢踢實業坊(ptt.cc)
◆ From: 61.217.195.210
推
06/16 12:04, , 1F
06/16 12:04, 1F
推
06/16 16:26, , 2F
06/16 16:26, 2F
推
06/16 16:55, , 3F
06/16 16:55, 3F
推
06/16 23:56, , 4F
06/16 23:56, 4F
推
06/18 00:08, , 5F
06/18 00:08, 5F
PHP 近期熱門文章
PTT數位生活區 即時熱門文章
