phpaccounts

Php general ledger query

I am new in PHP I want to know how to create general ledger.
I have two tables invoice and payment received.

I want to create general ledger using both tables.

mysql_query("select * from invoice");
mysql_query("select * from invoice");
Solution

  • Maybe you want to count the total, you can do it like this:

    $total = mysql_query("SELECT count(money) as total FROM invoice");//your query string
$res = mysql_fetch_array($total);
$count = $res['total']; //statistics