However, if you don't know what you are doing, and that is what it sounds like since you don't know how to make a connection to your database, I really wouldn't recommend you doing it. You can open yourself up to an SQL injection or any number of things that can put your customer's information at risk to hackers and your server at risk. It isn't worth the risk if you don't know how to secure your asp code. I would strongly suggest you go with one of the developers who make add ons for Product Cart. 

The company I work for uses WMS and Grey Beard for anything we don't have the time to do or can't do in house. We highly recommend them, but any of the developers here can do what you are asking.

Second, I thought I was fairly descriptive of what I wanted to do.  I wanted to know what ASP coding I would need to employ to access the ProductCart database to pull specific field's data in a product record.  They are as follows:

Hope this clarifies what I wanted to do.

I am not aware of anyone attempting to run PC on MySQL. I would not hold out much hope there as there are some really complex SQL queries (search results itself is a real doozie!) in PC and I am quite sure that there would be significant syntax differences between the way MySQL handles some of the more advanced SQL syntax.

As for the rest, it's all pretty straight forward stuff for any developer, even a novice. However, your question is way to vague for anyone here to help other than to say that the home page is already full of examples for exactly what you have in your screenshot.

I'd have to assume that you are looking to query the db for something other than featured products, specials, new arrivals or best sellers (standard options). First we would need to know what criteria you are using to query the db to return a record set for (I dunno? top rated products? Products from some category subset? Clearance/low stock?).

If you could at least provide the criteria for generating the record set, one of us might be able to help you further.

I want to know if there is a way to grab product record fields to display certain aspects of the product record on another ASP web page outside of the ProductCart folder/pages.

I want to pull the data fields from a product record that hold the Name, Short Description, Online Price and Thumbnail Image.  I want to use the data in these to display them on my main default.asp page in the root (first page people see when they type in the URL).  I wanted to pull it from the PC database the same way that ProductCart pulls it so no matter what type of database (have Access DB now and looking to change to MySQL) or the changes to the product, it will display on my default site page.

I made a screenshot of the page I'm working on and highlighted an annotated the area and layout of the product data that I'd like to populate from the ProductCart store database: