I can take existing code and pretty much make it do what I want, but this one is just over my head.
I have a web site that I'm working on. The site private portal has an attendance program (URL deleted -- Mod.). Simple enough, however I want to display the attendance in a different format. The program displays all the people that attended an event (training in this case). I need it to only display if the logged in user attended the training.
So as a member I log in and I click on the attendance link, I should see in date order the events that I attended, not the events I did not attend. I should also not be able to see other attendees.
The members portal works perfect as does the admin side of the attendance program.
The problem is that I just don't know how to get the code right.
I have a sql query that pulls the required information from the two databases, but not sure how to display it all.
How do I format information from the database and display it via pho into the desired format.
The sql query is SELECT site_events.event_title FROM site_events_users left join site_events on site_events_users.event_id = site_events.event_id WHERE site_events_users.user_id = medicalr_amember.amember_members.login
The dates are in a strange format:
1051761600
1083384000
Which equates to:
1051761600 = May 01, 03 12:00 am
1083384000 = May 01, 04 12:00 am
Desired display is
2003
May Training
June Training
July Training
2004
May Training
Any help would be appreciated.
