I am using MIGXDB to populate the MySql and loop collection to display data in a table, this part is successful. However I want to something a little different and I cannot find a solution:
I have 2 questions
1/ Is there a way to produce a value in the front end that displays whether there is any data in the fields of a MySql column?
#Note# I do not want to display the actual data from each field, I want to count the number of fields with data in and display that as a number excluding the fields with blank data.
For example: If a column has 20 rows and 15 have actual data with 5 blank then it should display front end 15
2/ How to display difference between the number of entries in one column compared to another (simple subtraction)?
For example: if column A has 15 fields with actual data and column B has 5 fields with actual data then it should display the sum difference = 10
packageName=`tfsabah` classname=`Tfsabah` selectfields=`Asha_Region,Asha_Loc_id,Asha_Site_Name`
Any advice, guidance or code examples would be greatly appreciated