Hi Guys , I couldnt dispay sum of a column of sqlite database in php . I tried the sql statement in database its working fine but not sure how to dispay the result in PHP . I belive i need to fetch it and then dispay any help will be appreciate . Thanks in advanced .
Sql statement :
<?PHP $dbhandle = new PDO('sqlite:test.sqlite'); $query = $dbhandle->query("SELECT COALESCE(SUM(Qty) ,0) AS TOTAL FROM RMA where (Status='Returne')"); ?>