Zen Cart Logo

atributes stock help

Locked

Views: 653

Results 1 to 1 of 1
This thread is locked. New replies are disabled.
9 Nov 2008, 9:22 PM
#1
mrflonaldo avatar

mrflonaldo

New Zenner

Join Date:
Nov 2008
Posts:
2
Plugin Contributions:
0

atributes stock help

Hi all,

Im using the products with atributes stock. Ive added a bit of code in the display product page, that lists the diffrent versions of atributes and what stock they have, so people may see whats in stock.
My problem however is when i use multiple atributes on a product (eg both color and size) the number of all atribues id is stored in the database, only seperated by comma. Dont know how to break this down, so I hope for some help here. I usually make an search just for the number eg '333', but with multiple atribues the code changes to eg. '333,444,555'

Heres my code:

<?php $products_id= $_GET['products_id']; $sql_result = mysql_query("SELECT * FROM zen_products_with_attributes_stock where products_id=$products_id"); $num_links = mysql_num_rows($sql_result); if($num_links>0) { print("<table border=0 width=300><tr><td colspan=2><b><center>Lagerbeholdning:</center></b></td></tr>"); } for($i=0;$i<$num_links;$i++) { $myrow = mysql_fetch_array($sql_result); $stock_attributes = $myrow["stock_attributes"]; $quantity = $myrow["quantity"]; if($quantity < 1) { $quantity = "<font color=red>X</font> <small>Bestillingsvare (5-15 dager)</small>"; } $sql = mysql_query("SELECT * FROM zen_products_attributes where products_attributes_id=$stock_attributes"); $myrow2 = mysql_fetch_array($sql); $ovid = $myrow2["options_values_id"]; $sql = mysql_query("SELECT * FROM zen_products_options_values where products_options_values_id=$ovid AND language_id=2"); $myrow2 = mysql_fetch_array($sql); $attribute_name = $myrow2["products_options_values_name"]; $tekst = "<tr><td> $attribute_name </td><td> $quantity </td></tr>"; print($tekst); } if($num_links>0) { print("</table>"); } ?>

Hope somebody can help me alter this code to make it concider the possibility of multiple atributes.