Zikula Community

• **unknown user**
  
  

  • Rank: Registered User
  • Registered: Mar 16, 2002
  • Last visit: Oct 21, 2009
  • Posts: 11

  Posted: Jul 14, 2003 - 10:14 AM

  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

  • 
  •  
• **unknown user**
  
  

  • Rank: Registered User
  • Registered: Mar 16, 2002
  • Last visit: Oct 21, 2009
  • Posts: 11

  Posted: Jul 15, 2003 - 03:17 AM

  Should I have put this in the Database Knowledge Exchange forum instead?

  • 
  •  
•  
•  

Users on-line

• AllKnightAccess,
• DirkThiele,
• jmvaughn,
• mazdev,
• mdee

This list is based on users active over the last 60 minutes.