close ad
Databridge V2 with MySQLi support IS Now Available!
open ad
View Menu

Technical Support Forums

Free, outstanding support from WebAssist and your colleagues

rating

Order management without data assist?

Thread began 10/27/2010 11:44 am by tim.wolak331163 | Last modified 10/27/2010 1:29 pm by CraigR | 660 views | 3 replies |

tim.wolak331163

Order management without data assist?

Can anyone help with a basic setup for order management without data assist? I have the SQL statement to pull all the data but I need help with laying it out in a table to view the basic overview of the order and in the order detail page would have the entire detail.

If there are any tutorials or docs out there that would be great.

Thanks,
Tim

Sign in to reply to this post

CraigRBeta Tester

How are you planning to view the orders ?

Are you looking to have a table with a list of the orders, with each row having a link to the order details ?

Start with the orders table, if you have the recordset already, just create a table with 2 rows and the appropriate number of columns, with an extra column for your links
the link column should contain a link to your order details page, using the orderid as the url parameter

the first row contains the column headers
the second row contains the recordset fields.

once these are in place, select the whole second row and add a repeat region server behavior to it, which will give you a list of all of the orders.

the table on the order details page will be created in the same way, but the recordset will be based on the order details table, filtered by the orderid from the url parameter

Sign in to reply to this post

tim.wolak331163

Thanks, Craig!

I would like to have a page that will display the orders most current on top, when you click on the order number it would bring you to the detail page.

I tried this once before and if the order had four items there were four line for the same order on the first page and when you went to the details page it only had detail for one item.

I'm still learning PHP/MySQL if you can point me to any tutorials or examples that would be great.

Thanks,
Tim

Sign in to reply to this post

CraigRBeta Tester

a good start would be

ecommerce-database/

there should be plenty of tips here.

for php, try php.net/ or PHP/

there are some great books by David Powers if you want to do some reading

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...