[請益] 連結sql server只回傳一筆資料而已 以解決
以下是我的程式碼
$dbhost = '123.123.123.1';
$dbname = 'xx';
$dbpass = 'XXXXXX';
$dbuname = 'SunSQL';
$where_to_big5 = mb_convert_encoding("客戶","big5","utf8");
$where_end_big5 = mb_convert_encoding("測試客戶1","big5","utf8");
$dbi = mssql_connect($dbhost,$dbname,$dbpass);
mssql_select_db($dbuname);
$this_array = mssql_query("select * from $tbuname where $where_to_big5
= $where_end_big5 ");
$this_array = mssql_fetch_array($this_array);
print_r($this_array);
array改成mssql_fetch_row查出來的資料也還是只有一筆
但是我用mssql_num_rows去呼叫卻顯示有3XXX筆資料
不知道為什麼會這樣~
希望各位高手大大們能幫我解答我的疑惑
這不是做業文謝謝@@
---------------------------------------------------------------------
聽了大大的建議
我把他改寫成
$the_array = array();
for($i=0;$i<=mssql_num_rows($this_array);$i++)
{
$the_array[] = mssql_fetch_array($this_array);
}
print_r($the_array);
這樣對嗎?
--
※ 發信站: 批踢踢實業坊(ptt.cc)
◆ From: 60.250.35.133
→
10/13 10:55, , 1F
10/13 10:55, 1F
→
10/13 10:59, , 2F
10/13 10:59, 2F
※ 編輯: angelmark 來自: 60.250.35.133 (10/13 11:07)
推
10/13 11:58, , 3F
10/13 11:58, 3F
→
10/13 12:00, , 4F
10/13 12:00, 4F
→
10/13 13:34, , 5F
10/13 13:34, 5F
推
10/13 13:42, , 6F
10/13 13:42, 6F
推
10/13 18:33, , 7F
10/13 18:33, 7F
→
10/13 18:34, , 8F
10/13 18:34, 8F
→
10/13 18:34, , 9F
10/13 18:34, 9F
→
10/13 18:35, , 10F
10/13 18:35, 10F
→
10/15 14:52, , 11F
10/15 14:52, 11F
※ 編輯: angelmark 來自: 60.250.35.133 (10/15 14:52)