Trying to join the order table and order detail together on the detail page

I trying to create an order history and detail page to my site. When I test the pages I can get the history page to display information but when I click the link to see the detail page. I get an sql sytax error was is, You have an error in your SQL syntax; check the manual that corresponds to your MYSQL server version for the right syntax to use near 'FROM orders INNER JOIN -1 ON orders.OrdersID = -1.DetailOrdersID WHERE -1.DetailO' at line 1.


I have followed the instruction posted on your web site regarding how to create an order history page. I tried to change the WADAorderdetails server behavior for the detail page.

I entered the code to join the orders and ordersdetails tables as follows:
SELECT orders.*, orderdetails.*
FROM orders INNER JOIN orderdetails ON orders.OrderID = orderdetails.DetailsOrderID
WHERE orderdetails.DetailOrderID = WADAOrderID AND order.OrderUserID = paramUserID


I did add the variable parameter paramUserID. My question is for the first variable parameter was colname. What should the first variable name be? What did I do wrong?

Help?

judging by the error, it looks one of the parameters you created was named "orderdetails"



when naming a parameter, I always preface the name with "param", for example, "paramOrderdetails"

I have read the how to create an order history page several times and retrace my steps.
I am still having problems with this. My problems is customize the order detail page. According to the direction the Server Behaviors WADAorderdetails needs to be change.

I have modified the entire SQL statement. I also add another variable parameter for paramUserID. My questions is what should be the first parameter when you modified the SQL statement. I am confused regarding this. The SQL statement looks like this:

SELECT orders.*, orderdetails.*
FROM orders INNER JOIN orderdetails ON orders.OrderID = orderdetails.Details.Details.DetailOrderID
WHERE orderdetails.DetailsOrderID = WADAOrderID and order.OrderUserID = paramUserID

This is in the how to create an order history tutorial. I also have applied the Login/Registration as well. What should I do next? I really want this to be part of the site.

Hi there

I am asuming you are using dreamweaver and you are connecting to a mysql database.

i do not know what you database erd and structure looks like but looking at your join statement I noticed this:

"SELECT orders.*, orderdetails.*
FROM orders INNER JOIN orderdetails ON orders.OrderID = orderdetails.DetailsOrderID"

1. You joining primary Key with primary key of another table !Wrong !
2. I think you should try to clean up your statement to look like this below.

Select * from Orders INNER JOIN OrderDetails ON
orders.OrderID = orderdetails.OrderID (you could also leave out INNER for now)

Leave out the where clause for now just to get your join to work !!!

Now what I would reccomend is open dreamweaver ...

1. Create a connection.
2. Create a recordset and in the dialogue copy and paste the join statement that I gave you ***INTO THE SQL TEXT BOX THAT IS THERE ***and click test ! If it works then you will actually see all the fields in both tables ...! Else it will tell you that you have a syntax error.

If that is the case I suggest you examine your ERD carefully to see that the PK OrderId is actullay refencing the OrderDetails Table as ForeignKey !

I hope this will be of some help !!! Let me know !
Mustapha