[請益] php語法
Warning: mysql_num_fields(): supplied argument is not a valid MySQL
result resource in C:\AppServ\www\new3.php on line 7
Warning: mysql_fetch_row(): supplied argument is not a valid MySQL
result resource in C:\AppServ\www\new3.php on line 10
<?php
$db=mysql_connect('localhost','root','密碼') or die('無法連上資料庫伺服器');
mysql_select_db("test",$db) or die('無法連上資料庫');
$sql="select * from test where id=1";
$result=mysql_query($sql,$db);
$no_fields=mysql_num_fields($result);<---有問題
echo "<table border=3>";
while($x=mysql_fetch_row($result)){ <----有問題
echo "<tr>";
for($j=0;$j<$no_fields;$j++)
echo "<td> $x[$j]</td>";
echo "</tr>";
}
echo "</table>";
mysql_close($db);
?>
懇請大大指點迷津一下,搞了好久都不行
--
※ 發信站: 批踢踢實業坊(ptt.cc)
◆ From: 36.237.172.129
※ 編輯: artorius 來自: 36.237.172.129 (10/06 21:55)
→
10/06 21:55, , 1F
10/06 21:55, 1F
→
10/06 21:56, , 2F
10/06 21:56, 2F
※ 編輯: artorius 來自: 36.237.172.129 (10/06 21:59)
※ 編輯: artorius 來自: 36.237.172.129 (10/06 22:00)
→
10/06 22:01, , 3F
10/06 22:01, 3F
→
10/06 22:02, , 4F
10/06 22:02, 4F
→
10/06 22:02, , 5F
10/06 22:02, 5F
※ 編輯: artorius 來自: 36.237.172.129 (10/06 22:02)
→
10/06 22:02, , 6F
10/06 22:02, 6F
→
10/06 22:03, , 7F
10/06 22:03, 7F
推
10/06 22:07, , 8F
10/06 22:07, 8F
→
10/06 22:11, , 9F
10/06 22:11, 9F
→
10/06 22:11, , 10F
10/06 22:11, 10F
推
10/06 22:13, , 11F
10/06 22:13, 11F
※ 編輯: artorius 來自: 36.237.172.129 (10/06 22:27)
→
10/06 22:30, , 12F
10/06 22:30, 12F
推
10/06 22:30, , 13F
10/06 22:30, 13F
→
10/06 22:31, , 14F
10/06 22:31, 14F
→
10/06 22:32, , 15F
10/06 22:32, 15F
推
10/06 22:36, , 16F
10/06 22:36, 16F
→
10/06 22:37, , 17F
10/06 22:37, 17F
※ 編輯: artorius 來自: 36.237.172.129 (10/06 22:37)
→
10/06 22:37, , 18F
10/06 22:37, 18F
<?php
$link = mysql_connect('localhost','root','密碼') or die('無法連上資料庫伺服器');
mysql_query("test") or die('無法連上資料庫');
$sqlstr="select filename from test01 where id = 3";
$result=mysql_query($sqlstr,$link);
echo "<td>".$row[$i]."</td>";
?>
上面先不要看,我這邊重新再打一個,變成無法連線到資料庫
※ 編輯: artorius 來自: 36.237.172.129 (10/06 22:39)
→
10/06 22:38, , 19F
10/06 22:38, 19F
※ 編輯: artorius 來自: 36.237.172.129 (10/06 22:40)
→
10/06 22:40, , 20F
10/06 22:40, 20F
改了還是不能連資料庫ㄟ>_<
※ 編輯: artorius 來自: 36.237.172.129 (10/06 22:48)
→
10/06 22:53, , 21F
10/06 22:53, 21F
→
10/06 22:54, , 22F
10/06 22:54, 22F
※ 編輯: artorius 來自: 36.237.172.129 (10/06 22:58)
推
10/08 11:43, , 23F
10/08 11:43, 23F
討論串 (同標題文章)
PHP 近期熱門文章
PTT數位生活區 即時熱門文章