how to find daily cash book record from two tables with php mysql

[Faruk Web]

I am making account management application for daily cash book summery record with php and mysql. tbl_credit: for income such as id,date,name,credit tbl_debit: for cost such as id,date,name,debit I can not set up opening cash for first day and cash hand will be opening cash for tomorrow. Thus it will be continue..... anybody can help me. plz see screenshot below. screenshot Thanks in advance.