row sum to verify CC data has been entered [closed]

[glix]

i am writing a query that gets the row dollar value if there is a numeric value in the cc_num or bank_act column. here is the code i have so far:\[code\] $query = "SELECT COUNT(*) as calls, vicidial_users.user, vicidial_users.full_name, sum(IF(s_amount !='','1','0')) as totalsAmnt, sum(vicidial_agent_log.pause_sec) as sumPause, sum(IF(custom_$customID[$i].up_amt !='','1','0')) as sumcountupAmnt, sum(IF(custom_$customID[$i].cc_num or custom_$customID[$i].bank_act !='','1','0')) as sumverifiedcountAmnt, sum(custom_$customID[$i].d_amt) as sumDamnt, sum(custom_$customID[$i].up_amt) as sumUpamnt, sum(custom_$customID[$i].md_amt) as sumMdamnt, sum(custom_$customID[$i].s_amount) as sumSamnt, sum(vicidial_agent_log.dispo_sec) as sumDispo FROM vicidial_agent_log INNER JOIN vicidial_users ON (vicidial_agent_log.user = vicidial_users.user) INNER JOIN custom_$customID[$i] ON (vicidial_agent_log.lead_id = custom_$customID[$i].lead_id) GROUP BY vicidial_users.full_name ORDER BY vicidial_agent_log.event_time DESC "; \[/code\]Thank in advance