2. PHPRunner General questions
  3. how to make a custom view from a temporary table?
This topic is locked

how to make a custom view from a temporary table?

 		4/6/2011 10:41:02 PM
PHPRunner General questions
C
 caese author

Hello! I have a table to take the control of monthly contributions

The Database fields are:

Member_Number, last_month_paid, last_year_paid,

Each month that a member pays, I entry the fee paid

for the month and year that corresponds to that period.
It is possible to make a custom view that creates a table

to insert the months since the last payment owed, to today´s date

and after having been viewed, clear the table?
Thanks in advance, and please, sorry about my english.
Sergey Kornilov admin 4/7/2011

I'm not sure if you need a temporary table for this purpose. I would suggest to create a custom view in PHPRunner and modify SQL Query to perform required calculations.
Will that work for you?
C
 		caese author 4/7/2011

I add a field to the table, so these are the current fields:
member_number, last_month_paid, last_year_paid, paid
Ok. How do I insert a record with a "NO" in the paid field, for each month from (the last paid="YES")+1 to the current date? (I intend display only the months and years with a "NO" in the paid field.)
And if is possible: How make these in the before display from the custom view?
Sorry about my english. I never give enough thanks to Google translator.
Sergey Kornilov admin 4/8/2011

I guess I need to see some sample data that explains the logic behind this.
If you have a valid support contract post your application to Demo Account and open a ticket at http://support.xlinesoft.com sending your Demo Account URL. 'Demo Account' button can be found on the last screen in the program.