 |
|
|
 |
 |
|
ใช้ SUM ถูกแล้ว แต่ใช้ GROUP BY Item no แทน
|
 |
 |
 |
 |
| Date :
2013-05-16 10:59:47 |
By :
teez1232002 |
|
 |
 |
 |
 |
|
|
 |
 |
|
 |
 |
| |
|
|
|
| |
|
มีตัวอย่างเป็นโค๊ด mssql ไหมครับ 
|
| |
|
|
| |
| Date :
2013-05-16 11:01:38 |
By :
nattkhanesha |
|
|
| |
|
|
|
|
|
| |
|
|
|
| |
|
|
|
| |
|
เอาโค๊ดที่เขียนแล้วออกมา 2 ค่า มาครับเดี๋ยวลองแก้ให้
|
| |
|
|
| |
| Date :
2013-05-16 11:03:03 |
By :
teez1232002 |
|
|
| |
|
|
|
|
|
| |
|
|
|
| |
|
|
|
| |
|
Code (PHP)
<?
$objConnect = mssql_connect("10.1.1.18","sa","sa") or die("Error Connect to Database");
$objDB = mssql_select_db("KHLD");
$strSQL = "SELECT * FROM codeitem WHERE COMPANY = '430' AND ITEM = 'BSCDVAIMAR-0179' AND LOT LIKE '%4243#02%' ";
$objQuery = mssql_query($strSQL) or die ("Error Query [".$strSQL."]");
?>
<table width="100%" border="1" cellpadding="0" cellspacing="0">
<tr>
<th div align="center">Item_no </div></th>
<th><div align="center">Item_name </div></th>
<th><div align="center">Item_description </div></th>
<th><div align="center">Lot</div></th>
<th><div align="center">Print_Qty </div></th>
</tr>
<?
while($objResult = mssql_fetch_array($objQuery))
{
?>
<?
$COMPANY = $objResult["COMPANY"];
$ITEM = $objResult["ITEM"];
$LOT = $objResult["LOT"];
$QUANTITY = $objResult["QUANTITY"];
$a1 = $objResult["BRANCH"];
$a2 =$objResult["LMCATEGORY2"];
$a3 =$objResult["LMCATEGORY3"];
$a4 =$objResult["PRODUCTTYPE"];
$a5 =$objResult["LOT"];
$LOTNUMBER = $a1.$a2.$a3.$a4.$a5;
?>
<tr>
<td><?=$objResult["ITEM"];?></td>
<td><?=$objResult["ITEMNAME"];?></td>
<td><?=$objResult["ITEMDES"];?></td>
<td><?=$LOTNUMBER;?></td>
<td><?=$objResult["QUANTITY"];?></td>
</tr>
<?
}
?>
</table>
<?
mssql_close($objConnect);
?>
ขอบคุณครับ
|
ประวัติการแก้ไข
2013-05-16 11:14:19
2013-05-16 11:14:39
| |
|
|
| |
| Date :
2013-05-16 11:13:18 |
By :
nattkhanesha |
|
|
| |
|
|
|
|
|
| |
|
|
|
| |
|
|
|
| |
|
Code (PHP)
SELECT ITEM,ITEMNAME,ITEMDES,BRANCH,LMCATEGORY2,........,SUM(QUANTITY) FROM codeitem WHERE COMPANY = '430' GROUP BY ITEM
ค่าที่ซ้ำคือ ITEM ใช่มั้ย ที่ผมจุดๆไว้คือค่าที่จะต้องเอามาโชว์ ขี้เกียจพิมพ์ครับ 
|
| |
|
|
| |
| Date :
2013-05-16 11:26:27 |
By :
teez1232002 |
|
|
| |
|
|
|
|
|
| |
|
|
|
| |
|
|
|
| |
|
งงเลยครับ ไม่รู้ผิดตรงไหน
Warning: mssql_query() [function.mssql-query]: message: Column 'codeitem' is invalid in the select list because it is not contained in either an aggregate function or the GROUP BY clause. (severity 16) in D:\AppServ_2556\www\sql20081.php on line 16
Warning: mssql_query() [function.mssql-query]: Query failed in D:\AppServ_2556\www\sql20081.php on line 16
Error Query [SELECT ITEM,ITEMNAME,ITEMDES,BRANCH,LMCATEGORY2,LMCATEGORY3,PRODUCTTYPE,LOT,SUM(QUANTITY) FROM codeitem WHERE COMPANY = '430' AND ITEM = 'BSCDVAIMAR-0179' AND LOT LIKE '%4243#02%' GROUP BY ITEM ]
|
ประวัติการแก้ไข
2013-05-16 11:59:59
| |
|
|
| |
| Date :
2013-05-16 11:51:51 |
By :
nattkhanesha |
|
|
| |
|
|
|
|
|
| |
|
|
|
| |
|
|
|
| |
|
SELECT ITEM,ITEMNAME,ITEMDES,BRANCH,LMCATEGORY2,LMCATEGORY3,PRODUCTTYPE,LOT,SUM(QUANTITY) FROM codeitem WHERE COMPANY = '430' AND ITEM = 'BSCDVAIMAR-0179' AND LOT LIKE '%4243#02%' GROUP BY ITEM,ITEMNAME,ITEMDES,BRANCH,LMCATEGORY2,LMCATEGORY3,PRODUCTTYPE,LOT
|
| |
|
|
| |
| Date :
2013-05-16 12:50:56 |
By :
thep |
|
|
| |
|
|
|
|
|
| |
|
|
|
| |
|
|
|
| |
|
ลอง DISTINCE item no อย่างเดียวดูครับ
|
| |
|
|
| |
| Date :
2013-05-16 14:01:03 |
By :
Anonymous |
|
|
| |
|
|
|
|
|
| |
|
|
|
| |
|
|
|
| |
|
ได้แล้วขอบคุณครับ
|
| |
|
|
| |
| Date :
2013-05-16 16:37:53 |
By :
nattkhanesha |
|
|
| |
|
|
|
|
|
| |
|
|
|
|
