[請益] 連接mysql時抓不到資料
如題,從php要抓SQL內的資料一直有問題
po上相關的程式碼,請幫我看看
因為一直抓不到資料,所以我就寫了一個function,專門來看連結的情況
該function的部份程式碼是這樣
$LinkID=mysql_connect("127.0.0.1","root","yenchang");
$SQLSyntax="select * from gpm_part.part";
$SQLSyntax2="select ".$Target." from ".$this->dbSchema.".".$Source."
where ".$Rule;
$Result=mysql_query($SQLSyntax,$LinkID);
$Result2=mysql_query($SQLSyntax2,$LinkID);
print "<br></br>LinkID=$LinkID";
print "<br></br>SQLSyntax=$SQLSyntax";
print "<br></br>SQLSyntax2=$SQLSyntax2";
print "<br></br>Result=$Result";
print "<br></br>Result2=$Result2";
$Target,$Source,$Rule是這個function的參數
結果如下
LinkID=Resource id #3
SQLSyntax=select * from gpm_part.part
SQLSyntax2=select partid,typename,partname from gpm_part.part,type where part.typeid=type.typeid
Result=Resource id #4
Result2=
有一個query會失敗,請問是為什麼??
--
※ 發信站: 批踢踢實業坊(ptt.cc)
◆ From: 111.251.166.219
→
02/29 14:42, , 1F
02/29 14:42, 1F
→
02/29 14:44, , 2F
02/29 14:44, 2F
→
02/29 14:44, , 3F
02/29 14:44, 3F
→
02/29 14:44, , 4F
02/29 14:44, 4F
→
02/29 14:47, , 5F
02/29 14:47, 5F
→
02/29 14:47, , 6F
02/29 14:47, 6F
→
02/29 14:47, , 7F
02/29 14:47, 7F
→
02/29 14:48, , 8F
02/29 14:48, 8F
→
02/29 14:48, , 9F
02/29 14:48, 9F
→
02/29 14:49, , 10F
02/29 14:49, 10F
→
02/29 14:49, , 11F
02/29 14:49, 11F
→
02/29 14:50, , 12F
02/29 14:50, 12F
→
02/29 14:50, , 13F
02/29 14:50, 13F
→
02/29 14:52, , 14F
02/29 14:52, 14F
推
02/29 14:54, , 15F
02/29 14:54, 15F
→
02/29 14:54, , 16F
02/29 14:54, 16F
→
02/29 14:57, , 17F
02/29 14:57, 17F
→
02/29 14:57, , 18F
02/29 14:57, 18F
→
02/29 15:01, , 19F
02/29 15:01, 19F
→
02/29 15:04, , 20F
02/29 15:04, 20F
→
02/29 15:04, , 21F
02/29 15:04, 21F
→
02/29 15:37, , 22F
02/29 15:37, 22F
推
02/29 15:54, , 23F
02/29 15:54, 23F
→
02/29 17:33, , 24F
02/29 17:33, 24F
→
02/29 19:09, , 25F
02/29 19:09, 25F
→
02/29 19:09, , 26F
02/29 19:09, 26F
→
02/29 19:09, , 27F
02/29 19:09, 27F
→
02/29 19:10, , 28F
02/29 19:10, 28F
→
02/29 21:47, , 29F
02/29 21:47, 29F
→
03/01 11:38, , 30F
03/01 11:38, 30F
PHP 近期熱門文章
PTT數位生活區 即時熱門文章
