Posted by Mike
2014-06-03

Hi Tom,

Thanks for returning to me.
In regards to your answer below, no error message appears.

The following is my dropdown listbox:
web/config/config.selection.inc.php

define( 'SEL_AD_COLOR', "
S1001=Blue
S1002=Green
S1003=Yellow
" );

The following is a printing of $sql, located in web/cn/cn.php
Note, I have added 'age' and 'color' in the function getCellTxt($ad_id)

SELECT cell_id, image_w, image_h, pic, url_link, age, color FROM tbl_cell WHERE ( active= 'Y' ) AND ( ad_id='FS01' ) LIMIT 1;

When echo $rs['ad_type'] ,I get: S1001

How can get the related value for this key (i.e. Blue)?
Please could you provide any help,

Thanks a lot,