You cannot have two where clause in one select query (unless you have a sub-query; but that means you have more than one select query anyway)
select sum(Maden) as مدين,sum(Dayn) as دائن from Ezn_Qaid
where Qaid_date between ''and'' and Bayan_Oll='VISA'
Anyway, date between '' and '' would generate error. If you don't need it, why not simply:
select sum(Maden) as مدين,sum(Dayn) as دائن from Ezn_Qaid
where Bayan_Oll='VISA'
hth,
foxyland