Exit
  • Global community
    • Language:
      • Deutsch
      • English
      • Español
      • Français
      • Português
  • 日本語コミュニティ
  • 한국 커뮤니티
0

How to Load Values From Database on page load?

New Here ,
Sep 13, 2010 Sep 13, 2010

I am sure this is easy but... I have a website that lists products similar to the way Amazon lists them. Each product is listed in a separate HTMP table cell complete with Product Name, Desciption, Image and Pricing. Any given product will appear on many different pages within the website. I have a mysql dtabase that has columns that define the primary key, the Product Name, the Product Description and Pricing. I was hoping to use the Dremaweaver Recordset to load the correct pricing and product description for each product on any given web page at the time the page is loaded by the user. Surely I must be able to run an SQL query based on a hiiden vale (e.g. the primary key or name of the product) in order to fill in the correct descriotion and pricing. Am I on the right track or is there a better way to do this? Put another way, how do you load your product data from a database onto a web page without using URL paraneters?

TOPICS
Server side applications
405
Translate
Report
Community guidelines
Be kind and respectful, give credit to the original source of content, and search for duplicates before posting. Learn more
community guidelines
Guest
Sep 13, 2010 Sep 13, 2010
LATEST

Yes, you are on the right track. Besides URL parameter you can filter a recordset with a session variable, cookie, or entered value.

Translate
Report
Community guidelines
Be kind and respectful, give credit to the original source of content, and search for duplicates before posting. Learn more
community guidelines