<div>
I don't know anything about 3dcart. But, if it uses an sql database, you might be able to &quot;join&quot; a table with your userid to the 3dcart pricing table and retrieve the pricing level of the customer all in one query--assuming that I have understood your question correctly.
</div>


I don't know anything about 3dcart. But, if it uses an sql database, you might be able to "join" a table with your userid to the 3dcart pricing table and retrieve the pricing level of the customer all in one query--assuming that I have understood your question correctly.

<div>
Right that's what we want to do. But we don't know how to start, is there a website that can show me some sample code?
</div>


Right that's what we want to do. But we don't know how to start, is there a website that can show me some sample code?

<div>
<div class="content wysiwyg-content">
Hi all.<br />
<br />
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? <br />
<br />
The end user logs onto the website with their userid and they enter an item number in a box. <br />
<br />
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.<br />
<br />
Our table (myTable) is in one of our databases (myDatabase) on one of our servers (myServer). The table has 3 fields: userid, product, price.<br />
<br />
How can I do this? <br />
<br />
I've read that I could only do this via ASP or server side scripting.<br />
<br />
Any advice would be great!<br />
<br />
Thank you in advance!
</div>
</div>


Hi all.

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!

How can I search a sql database via my hosted website

Web development can range from developing the simplest static single page of plain text to the most complex web-based internet applications, electronic businesses, and social network services using a wide variety of languages and standards, including the familiar HTML, JavaScript and jQuery, ASP and ASP.NET, PHP, ColdFusion, CSS, PHP, Flex and Flash, but also the implementation of a broad list of standards including XML, WSDL, SSDL, VoiceXML and many more.