Urgent help required with a db query

[xtinexoop]

Hi

 

I have managed to add an Availability column to my product listing and to get it to list the product_availability_id - but this is just a number - I need to get it to translate that number into the text...

 

I have in my code:

 

$lc_text = tep_db_query("select products_availability_name from " . TABLE_PRODUCTS_AVAILABILITY . " where products_availability_id = '" . (int)$HTTP_GET_VARS['products_availability_id'] . "' and language_id = '" . (int)$language_id . "'");

 

 

Can anyone tell me what I should have instead... I am getting a different thing for each product all saying Resource id #XX

 

 

Christine

[Aziz]

Why do you want to add that??????

 

its already built in the system!!!

 

The product count when adding the product, setting it inactive?

 

Salam,

[xtinexoop]

Sorry, been away for a while.

 

I want it because I want to indicate availability of products that are not in stock.

 

e.g. some things are definitely available because my supplier always has them - or I know they have a lot of them and are unlikely to run out - so availability is 'Good'

 

Other products are 'limited' - because the supplier has only made a few of a particular print for example and therefore I wish to indicate to my customer that I may/may not be able to do a special order on it - and they need to check first before ordering.

 

 

So as far as I am aware the system does not do this 'out of the box'

 

Christine