Adding Model To Shopping Cart

[CoolCarPartsOnline]

I am trying to add the product_id and model to the shopping cart form. I have this code:

<?php echo '<li>Part#' . TEXT_OPTION_DIVIDER . $product['id'] . '</li>';
                        $products_model = $db->Execute("SELECT products_model FROM " . TABLE_PRODUCTS . " WHERE products_id = " . $product['id'] . " LIMIT 1;");
                          if ($products_model->RecordCount() > 0) {
                            $products_model = $products_model->fields['products_model'];  
                            echo '<li>Mfg Part#' . TEXT_OPTION_DIVIDER . $products_model . '</li>';
                          } ?>

It worked fine; until I tested it with a product that has attributes.

If I add a product with attribute I get this error

Part# - 2791:3b55bc83a02d362882e9292dddf7eb29
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 ':3b55bc83a02d362882e9292dddf7eb29 LIMIT 1' at line 1
in:
[SELECT products_model FROM products WHERE products_id = 2791:3b55bc83a02d362882e9292dddf7eb29 LIMIT 1;]

Any idea how to fix this.

[haredo]

this might help you out ...

http://www.zen-cart.com/forum/showthread.php?t=64280

[CoolCarPartsOnline]

Thanks that did take care of the model issue, but any idea why when adding a product with attribute the products_id is always followed by :session_id?

Only items with attributes show that.

Part# - 2786:31c900c2a34b6ef10e6c880139e956ae

[gilby]

Thanks that did take care of the model issue, but any idea why when adding a product with attribute the products_id is always followed by :session_id?

Only items with attributes show that.

Part# - 2786:31c900c2a34b6ef10e6c880139e956ae

Pretty sure thats not a session id.
I believe thats a products_prid.
Its a form of hash that enables the cart to keep track of the same item with same or different attributes.

[CoolCarPartsOnline]

How can I disable that. Even if I add the product_id outside the attribute function it still display the number.

[gilby]

How can I disable that. Even if I add the product_id outside the attribute function it still display the number.

Use the function zen_get_prid() around this value
This will return the only the products_id and strip off the unwanted bits

[CoolCarPartsOnline]

adding (int) in front of it also worked.

[haredo]

Just curious what is the final code to make the Product ID and Model number appear in the shopping cart?

[CoolCarPartsOnline]

For my application, I included within the attribute id so if product has attribute it will show within the list.

echo '<li>Part#' . TEXT_OPTION_DIVIDER . (int)($product['id']) . '</li>';
                  echo '<li>Mfg Part#' . TEXT_OPTION_DIVIDER . zen_products_lookup($product['id'], 'products_model') . '</li>';