create A Report of sales

[aa1979]

hi,

I trying to create a report of sales but still cannot found the solution here the result what I want : http://imgur.com/ruooAow , and here the current result : http://imgur.com/dbStBvr and here the code : http://pastebin.com/zezRnCKi

for yours answer and suggestion is very appreciated

thanks you

[jeepin81]

what's your sql query?

[aa1979]

sorry for delay, here the sql query

$strsql="SELECT * FROM tb_trans a 				
	LEFT JOIN tb_transdetail c ON (a.no_trans=c.no_trans)
	LEFT JOIN tb_sales b ON (a.sales=b.kode)								
	WHERE a.username like '".$_SESSION['swil']."'";

thanks

[xerxes]

You'll probably want a GROUP BY in there somewhere: http://www.w3schools.com/sql/sql_groupby.asp