I have a cust table with sid, name, address, phone
I have payments table with sid, month_paid.
I want to show the latest 5 months paid on one line, like this:
joe guy, 124 chicken place, 5551212, jan, feb, mar, apr, may, <jun>
example of those paid for may, bu not june
SELECT students.sid, students.name, payments.forMonth
FROM students Inner JOIN payments
ON students.sid = payments.sid
Right now, this shows a row per each month that was paid. I would like one row with each month paid shown, and radio buttons for months not paid for 5 months that are based on the current month. If the radio button is clicked, that month is inserted into payments under that sid.