Help us test the new Databridge BETA with MySQLi support

Technical Support Forums

Free, outstanding support from WebAssist and your colleagues

› WebAssist Forums › Data Bridge › DataAssist › Add details from items table on order history page.

Add details from items table on order history page.

Thread began 2/13/2010 9:06 am by ant.knott394719 | Last modified 2/16/2010 6:58 pm by ant.knott394719 | 1371 views | 13 replies

2/14/2010 5:31 pmDave BuchholzBeta Tester

A simple example of the code needed to join the orderdetails and items tables (assuming that you have based your database on the bkue sky music example and that you are storing ItemID in the orderdetails table as DetailItemID) would be:

SELECT orderdetails.DetailItemName, orderdetails.DetailItemDesc, items.ItemThumb FROM orderdetails JOIN items WHERE (orderdetails.DetailItemID = items.ItemID)

You can expand this to include other fields and tables as necessary. For more info on SQL to get you started see default.asp

Build websites with a little help from your friends

Your friends over here at WebAssist! These Dreamweaver extensions will assist you in building unlimited, custom websites.

Build websites from already-built web applications

These out-of-the-box solutions provide you proven, tested applications that can be up and running now. Build a store, a gallery, or a web-based email solution.