= '$from_date_unix' AND date_time <= '$to_date_unix' ORDER by date_time"; $res = mysqli_query($conn,$sql); while($row = mysqli_fetch_assoc($res)) { $cid = $row['cid']; $ress = mysqli_query($conn,"SELECT * FROM custormer where id = '$cid'"); $rows = mysqli_fetch_assoc($ress); $id = $rows['id']; $pres = mysqli_query($conn,"SELECT * FROM `product_amt` where cid = '$id'"); $prows = mysqli_fetch_assoc($pres); } ?>

#	Product	Quantity	Rate	Total
1	'.$row['product'].'	'.$row['quantity'].'	'.$prows['amount'].'/-	'.$amt = $row['quantity'] * $prows['amount'].'/-