close ad
Install the LAtest Updates to Work with CC 2017 and CC 2018
open ad
View Menu

Technical Support Forums

Free, outstanding support from WebAssist and your colleagues

rating

order management

Thread began 7/16/2010 8:41 am by tim.wolak331163 | Last modified 8/05/2010 1:24 pm by Jason Byrnes | 886 views | 7 replies |

tim.wolak331163

order management

I have gone through the wizard to create my detail pages but have a few issues. How can I get my order management pages to display one line for an order. For example if order 111 ordered four items there are four lines for order 111. Also I would like to have the detail combine the orders and orderdetails table which I have my sql statement saying select * from orders, orderdetails where orders.detailID = orderdetails.orderDetailID. This gets me that data I want I just need to know how to sort it like the question above.

Thanks,
Tim

Sign in to reply to this post

Dani Chankhour

If you want to show the order, then make sure to select the order table (not the order details table). and on your detail page, you will add an additional query to get the entries from the order detail page.

Let me know if I did not answer your question correctly.

Sign in to reply to this post

tim.wolak331163

order details

Dani,

I put in what you suggested and for the most part its working, however on the details page when I try to display the details it seems like its not matching the orderID's. If the last order in the DB is 111 I think its displaying the order details of order 1. I'm attaching my two pages hopefully you can offer some insight.

Thanks,
Tim

Attached Files
Archive.zip
Sign in to reply to this post

Dani Chankhour

Looking at the order detail page, the second record set might need to be changed to:

$query_WADAordersDetail = sprintf("SELECT * FROM orderdetails, orders WHERE DetailOrderID = %s", GetSQLValueString($ParamOrderID2_WADAordersDetail, "int"));

and where you are displaying the name and the description you could apply a repeat region server behavior to display the individual items.

Sign in to reply to this post

tim.wolak331163

Dani,

I'm working on getting up to speed on PHP, based on my code could you supple an example for a repeated region?

Thanks,
Tim

Sign in to reply to this post

Dani Chankhour

In Dreamweaver open the Server Behaviors panel (Window -> Server Behaviors), and then select the region you want to repeat. In your case, you will need to select the tr tag, and then click the + button from the Server Behaviors panel and select Repeat Region. In the repeat region window select the record set and select all records and click OK.

Her is an example:

?php do { ?>
<tr>
<td>&nbsp;</td>
<td>&nbsp;</td>
</tr>
<?php } while ($row_Recordset1 = mysql_fetch_assoc($Recordset1)); ?>

Sign in to reply to this post

tim.wolak331163

Thanks Dani,

Can you have a look at the details page and help me understand why the items and item description are not displaying on the details page?

Thanks,
Tim

Attached Files
Archive 2.zip
Sign in to reply to this post

Jason ByrnesWebAssist

Your sql is not right.

Have you seen the tutorial that we have on the eCart support page for creating order history pages:
creating_order_history.php

Sign in to reply to this post

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.

Want your website pre-built and hosted?

Close Windowclose

Rate your experience or provide feedback on this page

Account or customer service questions?
Please user our contact form.

Need technical support?
Please visit support to ask a question

Content

rating

Layout

rating

Ease of use

rating

security code refresh image

We do not respond to comments submitted from this page directly, but we do read and analyze any feedback and will use it to help make your experience better in the future.

Close Windowclose

We were unable to retrieve the attached file

Close Windowclose

Attach and remove files

add attachmentAdd attachment
Close Windowclose

Enter the URL you would like to link to in your post

Close Windowclose

This is how you use right click RTF editing

Enable right click RTF editing option allows you to add html markup into your tutorial such as images, bulleted lists, files and more...

-- click to close --

Uploading file...