01.<strong>Code</strong>
02.<div class="code"><span class="notranslate"><font class="fontcode"><?php
03. $sql= "select * from tb_sell,tb_product where p_name like '%$search_product%' and date='$dateInput' and id_product=p_id order by id_sell DESC";
04. $exec = mysql_db_query($dbname , $sql);
05. while($db= mysql_fetch_array($exec))
06.{
07.
08.?>
09. <tr>
10. <td height="22" align="center" bgcolor="#FFFFFF"><?php echo $db[id_sell]; ?></td>
11. <td align="center" bgcolor="#FFFFFF"><?php echo $db[date]; ?></td>
12. <td align="center" bgcolor="#FFFFFF"><?php echo $db[id_product]; ?></td>
13. <td align="center" bgcolor="#FFFFFF"><?php echo $db[p_name]; ?></td>
14. <td align="center" bgcolor="#FFFFFF"><?php echo $db[amount]; ?></td>
15. <td align="center" bgcolor="#FFFFFF"><?php echo $db[pricesell]; ?></td>
16. <td align="center" bgcolor="#FFFFFF"><?php echo $db[pricesum]; ?></td>
17. <td align="center" bgcolor="#FFFFFF"><a href="delete_report_sell.php?id=<?php echo $db[id_sell];?>" class="style1" style="text-decoration:none" onClick="if(confirm('คุณต้องการการลบข้อมูลนี้ <?=$row['id_sell'] ?> (ใช่/ไม่) ?')) return true; else return false;">ลบ</a></td>
18. </tr></font></span></div>
