Adding Fields & Retrieving Data from a Dbase

[reecesp]

Guys,

Google searches don't really help so I hope you guys can help.

I am trying to build a page in my joomla site that allows the user to input an invoice number (taken from an invoice I send them) and the website should retrieve the correct figure owed from a dbase and this will allow the user to click a paypal/cc link.

What the user should see:

- The user should click on a payment page link
- The fields on the page should include a freetext input field (for the user to key in the invoice number) and a field to show the amount that is pulled from the dbase.
- The user can then click on a paynow button and it takes them to the appropriate payment method.


Having an online shop isn't really appropriate as the webs is for consultancy services only... I understnd the theory, but the practise isn't working.

I am fine with the page creation and the payment stuff, but it is the database intricacies i am having problems with.

Any ideas?

Ta
Steve

[ooffick]

Which Joomla version do you have?
What did you try so far?

What exactly is the problem with the database?

Olaf

[nibra]

I am fine with the page creation and the payment stuff, but it is the database intricacies i am having problems with.

Please specify.

Regards,
Niels

[kclark]

I have the same problem. I can do the pages fine. But how exactly do I connect to my data tables? and where do I go in joomla to put the php for my page to display the data? What modules/plugins/components are required?