Add the Item # to Products_Detail.php page

I'm using the options ability in PS2. I would like to have the Item number show up on the Products_Detail.php page, so the customers can see which item it is.

When I open the page in Dreamweaver cs4, I want to put it above the Product Price. I am assuming at this point, that it is just a matter of dragging the ProductID field from the Recordset WADAProducts in the Bindings...but when I try to expand the Binding, I get the following error:

MySQL Error#: 1064

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 '' at line 2

First of all, if I didn't get the error, am I correct in what I'm doing?
Secondly, what does this error mean?

Thanks!

Yes, that is the way you would add the ID to the page. The error is occuring because the SQL is too complicated for Dreamweaver to interpret correctly.

To display the product id, the correct syntax would be to use:
<?php echo $row_WADAProducts['ProductID']; ?>

Jimmy,

I realized that I meant the ProductSKU. So I changed it and it worked...the only problem, is when I change an option, it is supposed to show a different SKU. It is not.

When I created the default product, I added a few options called: size. When I updated the item with the different option, I changed the SKU. When I look at an item on the live site, and change an option, the original SKU is showing, not the updated one.

1. Can I do this?
2. If so, what do I need to change in order to have the correct SKU show?

Thanks again.

Paul

To get this to show up correctly you will have to set the onchange in the select box to change the sku display based on the option that is chosen.

Jimmy,

Can you be a little more specific?

Here is the code for the select box:

<select name="ProductOptions_<?php echo($row_ProductOptions['OptionGroupID']); ?>" id="ProductOptions_<?php echo($row_ProductOptions['OptionGroupID']); ?>" onchange="updateProduct(this.options[this.selectedIndex].value)" style="width:260px;">

I see the onchange, but not sure where to change the code.

Thanks

Can anyone help me with this?

Thanks

Since this isn't a supported feature, I can point you in the correct direction, but you'll have to code it on your own.

You will have to create a function that will set the display of the value. Then you would call this function in the onchange of the select box. The function will need to have the value of the selected option to be passed in to the function as a parameter and then it will use a recordset to find the sku value of the option. After that it will set the display to the correct sku.

Jimmy,

I put this in the cart page:
Item #:&nbsp;<?php echo $row_WADAProducts['ProductSKU']; ?>

so that it will show the Item number, and it works. But when therer are more than 1 item in the cart, they all show the SKU for the last item entered. Is this also a custom feature? Why aren't they showing the correct item #?

Thanks

Any help Jimmy?
Does anyone have this issue, and if so, what did you do? Just leave out the item #?

Jimmy,

Correct me if I'm wrong in my thinking. If the cart page shows multiple items on it, then it has to be some sort of repeat region, correct? If so, then when I add the SKU field to it:
Item #:&nbsp;<?php echo $row_WADAProducts['ProductSKU']; ?>
why doesn't it repeat with the correct SKU?

All I want is the Item # to show up below the Description for every item in the cart.

Thanks