Going crazy Pleae help SQL Query- Attribs Stock

[harmeetsandhu]

Hey guys,

This is my second project and i have done quite good with the FAQ's and other posts but this one i am pulling my hair out.

Please i will be so greatful if someone can help me.

I have installed the module "stock by attribute"

My site is clothes shop and i have created different attributes like

Small
Medium
Large
Extra Large

Now i need to assign quantity to each attribute i am able to do that with the module but i need for the product info page to display the quantities which i assing to the above attributes.

Till now i have tried to do this :

In "tpl_modules_attributes.php"

<div class="wrapperAttribsOptions">
<h4 class="optionName back"><?php echo $options_name[$i]; ?></h4>
<div class="back"><?php echo "\n" . $options_menu[$i]; ?></div>
<br class="clearBoth" />
</div>

I have added this query .

$quan_query = "SELECT quantity From products_with_attributes_stock where stock_id = '" . (int)$_GET['stock_id'] . "'";

$quan = $db->Execute($quan_query);

and then changed the above code to the below

<div class="back"><?php echo "\n" . $options_menu[$i] . $quan; ?></div>

I dunno what i am doing wrong but its not working i am just pulling my hair out now. Please need some help

I have attached a screen shot as well.

I am not even sure if this is the right thing to do or if there is any other way of doing this.

Easier way i mean :-)

Will really appreciate all your help.

Regards

Harmeet