[請益] 在While row內的多次搜尋
$sql="SELECT * FROM `product` WHERE `logo`='$logo' ORDER BY price";
$result = mysql_query($sql,$link);
while($row=mysql_fetch_assoc($result))
{
$sql2 = "SELECT * FROM `message` WHERE `p_id`=".$row["p_id"]."";
$result2 = mysql_query($sql2,$link);
$count= mysql_num_rows($result2);
.
.
.
在第一次query之後,while會帶著 $row["p_id"] 跑每一筆資料的p_id,
利用這個回傳值,再做一次query查messages這table內相關的資料數量,但只有
第一筆成功回傳數值,接下來的都出現
mysql_num_rows(): supplied argument is not a valid MySQL result resource in
這行如果有寫die(XXX)
$result2 = mysql_query($sql2,$link) or die(XXX);
就在這行停掉
也曾試過在while最下面寫mysql_free_result( $result2 );
還是沒用
問題在哪裡呢? <(_ _)>跪求
--
※ 發信站: 批踢踢實業坊(ptt.cc)
◆ From: 218.170.11.113
推
03/16 00:31, , 1F
03/16 00:31, 1F
推
03/16 13:33, , 2F
03/16 13:33, 2F
→
03/16 13:34, , 3F
03/16 13:34, 3F
→
03/16 13:35, , 4F
03/16 13:35, 4F
→
03/16 13:35, , 5F
03/16 13:35, 5F
→
03/16 13:36, , 6F
03/16 13:36, 6F
→
03/17 12:26, , 7F
03/17 12:26, 7F
→
03/17 12:26, , 8F
03/17 12:26, 8F
→
03/17 12:27, , 9F
03/17 12:27, 9F
→
03/17 12:28, , 10F
03/17 12:28, 10F
推
03/17 21:43, , 11F
03/17 21:43, 11F
推
03/18 15:40, , 12F
03/18 15:40, 12F
→
03/19 15:45, , 13F
03/19 15:45, 13F
→
03/19 15:46, , 14F
03/19 15:46, 14F