Php general ledger query

Question

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");

Answer 1

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