$strSQL="select order_detail.prod_id,prod_name,prod_total,SUM(quantity) as total from order_detail LEFT OUTER JOIN products ON ";
$strSQL=$strSQL."order_detail.prod_id = products.prod_id GROUP BY order_detail.prod_id HAVING order_detail.or_id='$result=[or_id]' ";
<?
$i=0;
$sql = "select * from orders Where or_date='$yy-$mm-$dd' ";
echo $sql;
$query = mysql_query($sql);
while($result= mysql_fetch_array($query))
{
$i++;
?>
<?php
$strSQL="select order_detail.prod_id,products.prod_id,products.prod_name,products.prod_total,SUM(order_detail.quantity) as total from order_detail LEFT OUTER JOIN products ON ";
$strSQL=$strSQL."order_detail.prod_id = products.prod_id GROUP BY order_detail.prod_id HAVING order_detail.or_id='$result=[or_id]' ";
$strQUERY=mysql_query($strSQL,$conn);
$strNum=mysql_num_rows($strQUERY);
while ($data = mysql_fetch_array($strQUERY)) {
//$strResult=mysql_fetch_array($strQUERY);
?>
<tr bgcolor="#e5e5e5">
<td width="63" bgcolor="#FFFFFF"><div align="center" class="style2"><?=$i;?>
</div></td>
<td width="112" bgcolor="#FFFFFF"><div align="center" class="style2">
<div align="center">
<?=$result["prod_id"];?>
</div>
</div></td>
<td width="222" bgcolor="#FFFFFF"><div align="center"><a href="orderdetail.php?OrID=<?=$data["prod_id"];?>" target="_blank" class="style2">
<?=$data["prod_name"];?>
</a></div></td>
<td width="107" bgcolor="#FFFFFF"><div align="center"><a href="orderdetail.php?OrID=<?=$result["or_id"];?>" target="_blank" class="style2">
<?=$data["prod_total"];?>
</a> </div></td>
<td width="107" bgcolor="#FFFFFF"><div align="center"><a href="orderdetail.php?OrID=<?=$result["or_id"];?>" target="_blank" class="style2">
<?=$data["total"];?>
</a></div></td>
</tr>
<?
}
}
?>
Warning: mysql_num_rows(): supplied argument is not a valid MySQL result resource in
Warning: mysql_fetch_array(): supplied argument is not a valid MySQL result resource in