I thought I was getting this Postnuke/PHP/MySQL stuff all figured out until I tried to get data from the users table.
Here's what I've got so far:
I've created/modified an events module to allow the admin to setup payments for paypal. The user is able to register for the event as well as make some other purchases related to the event (i.e. supplies) and pay for the registration and supplies through paypal. So far so good. :D
I've even created a report section so that I can see who's registered for the event, when they registered, what form of Payment I can expect from the user, as well as other fields that I've capture through the users registration. I've also setup a field so that I can mark regs confirmed (i.e. recieved payment and any additional forms). From here I want to get the users data from the users table to generate other reports.
During the registration process I've basically captured:
username
event_id
reg_date
payment_method
payment_amt
What I'd like to do is query my event_registration table for info for a particular event. No problem I've done that so far. Then for each username returned by my initial query, select additional information from the users table to complete my reports. (i.e. name and email) This way I can have a report that would return:
Name Username RegDate PaymentAmount PaymentMethod EmailAddy Etc..
Thanks in advance,
Shane
- mdee responded to »Different page content under one template (tpl file) based on URL« 05:39 AM
- Guite responded to »Remove contents of nuke_sc_anticracker from Database« 01:30 AM
- espaan responded to »Categories disappear when editing ...« 08. Feb
- eledril responded to »How decrease zikula cpu usage« 08. Feb
- jmvaughn responded to »PN 0.764 to Zikula 1.1.2 (migration) Internal Server Error« 08. Feb
- eledril created topic »Where can I download BBCode and BBSmile?« 08. Feb
- Paustian responded to »Need Feedback« 08. Feb
Zikula Blog
- Anatomy of Open Source Projects on Mar 07
- Continuous Review on Mar 01
- Not Invented Here on Feb 24
- How to Contribute Your Code at Github on Jan 13
- 10 Steps to Coding-Nirvana: Tips for Successful Module Writing on Nov 12
- Submitting Bug Report Tickets That Get Results on Aug 17
- Cozi Tricks #1: Syntax Highlighting on Aug 07
