[請益] 查詢資料庫的方法
若我想靠讀取某欄位的特定數值分別讀取出來
有以下兩種寫法（或許更多...）
1.先分開取出要的，要用的時候就直接拿不同的row用
mysql_select_db($database_members, $members);
$query8 = "SELECT * FROM A WHERE Anumber LIKE '8%'";
$D8 = mysql_query($query1, $members) or die(mysql_error());
$row8 = mysql_fetch_assoc($D8);
$total_D8 = mysql_num_rows($D8);
mysql_select_db($database_members, $members);
$query9 = "SELECT * FROM A WHERE Anumber LIKE '9%'";
$D9 = mysql_query($query9, $members) or die(mysql_error());
$row9 = mysql_fetch_assoc($D9);
$total_D9 = mysql_num_rows($D9);
2.另外一種是像這樣，先fetch到同一個row上，然後要用的時候再分別進行判斷
mysql_select_db($database_members, $members);
$query = "SELECT * FROM A ";
$D = mysql_query($query, $members) or die(mysql_error());
$row = mysql_fetch_assoc($D);
$total = mysql_num_rows($D);
//需要用時，這邊要跑個迴圈...
if ($row['Anumber']=='8%') echo balabalabala
if ($row['Anumber']=='9%') echo balabalabala
想請問哪一種寫法比較好？
個人現在是偏向第二種，想問問各位的意見：）
簡單的問就是說 我想請益是要先在讀取資料庫的時候就先判斷好所需要的
還是先把他讀取出來再用PHP的指令去判斷？
--
還是說我該去db版問XD"
--
※ 發信站: 批踢踢實業坊(ptt.cc)
◆ From: 114.44.200.221
推
03/26 00:42, , 1F
03/26 00:42, 1F
推
03/26 00:44, , 2F
03/26 00:44, 2F
推
03/26 01:19, , 3F
03/26 01:19, 3F
→
03/26 01:19, , 4F
03/26 01:19, 4F
→
03/26 01:19, , 5F
03/26 01:19, 5F
推
03/26 06:14, , 6F
03/26 06:14, 6F
推
03/26 09:23, , 7F
03/26 09:23, 7F
推
03/26 10:40, , 8F
03/26 10:40, 8F
推
03/26 10:46, , 9F
03/26 10:46, 9F
→
03/26 10:46, , 10F
03/26 10:46, 10F
推
03/26 11:44, , 11F
03/26 11:44, 11F
推
03/26 14:48, , 12F
03/26 14:48, 12F
→
03/26 18:00, , 13F
03/26 18:00, 13F
→
03/26 18:00, , 14F
03/26 18:00, 14F
→
03/26 18:00, , 15F
03/26 18:00, 15F
→
03/26 21:12, , 16F
03/26 21:12, 16F
→
03/26 21:14, , 17F
03/26 21:14, 17F
PHP 近期熱門文章
PTT數位生活區 即時熱門文章
