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