I have a very basic question: If we have a website that is hosted by 3dcart, and we want to be able to search a sql table from the website how can we do this?
The end user logs onto the website with their userid and they enter an item number in a box.
When they click a button on the website it will display the product information (this info resides on 3dcart's tables) but we want to include the item's price based on the userid. The item's price based on the userid is not on 3dcart.
Our table (myTable) is in one of our databases (myDatabase) on one of our servers (myServer). The table has 3 fields: userid, product, price.
How can I do this?
I've read that I could only do this via ASP or server side scripting.
Any advice would be great!
Thank you in advance!