$strSQL = "SELECT DISTINCT (idcode_pb) , order_ID FROM `order` WHERE (idcode_pb LIKE '%".$_GET["txtKeyword"]."%' order by order_ID )";
$objQuery = mysql_query($strSQL) or die ("Error Query [".$strSQL."]");
รันออกแบบนี้ ครับ
Search Error Query [SELECT DISTINCT (idcode_pb) , order_ID FROM `order` WHERE (idcode_pb LIKE '%200%' order by order_ID )]
SELECT DISTINCT (idcode_pb) , order_ID FROM `order` WHERE (idcode_pb LIKE '%200%' order by order_ID )
ต้องเป็น
SELECT DISTINCT (idcode_pb) , order_ID FROM `order` WHERE (idcode_pb LIKE '%200%')order by order_ID
(จริงๆ ไม่ต้องมีวงเล็บตรง (idcode_pb) และ (idcode_pb LIKE '%200%') ก็ได้)
$strSQL = "SELECT DISTINCT (idcode_pb) , order_ID FROM `order` WHERE (idcode_pb LIKE '%".$_GET["txtKeyword"]."%') order by order_ID";
$objQuery = mysql_query($strSQL) or die ("Error Query [".$strSQL."]");
Load balance : Server 04
