pulling enum values from DB to drop-down box

[kilbey1]

Someone set up a database with enum values, example:
field: price_range
enum: 'Less than $10','$10 - $25','$25 - 50','More than $50'

I hardcoded the drop-down box. Now, how can I make it SELECT the current value in the DB?

Current code (I've tried different variations of this):

$num = $frm->select("price_range","Price Range:");
if ($price_range=="Less than $10") $a='Yes';
else $frm->option("",'None',$num,$a);
$frm->option('Less than $10','Less than $10',$num,$a);
if ($price_range=="$10 - $25") $a='Yes';
else $frm->option("",'None',$num);
$frm->option('$10 - $25','$10 - 25',$num,$a);
if ($price_range=="$25 - $50") $a='Yes';
else $frm->option("",'None',$num);
$frm->option('$25 - $50','$25 - $50',$num,$a);
if ($price_range=="More than $50") $a='Yes';
else $frm->option("",'None',$num);
$frm->option('More than $50','More than $50',$num,$a);

It either adds SELECTED to all options, or to none!

Thanks.
[e-mail]

[archangel_617b]

Firstly, please remember to provide source in either

 or [code=php] tags.  Makes it much easier to read.

Er, since you're using an object to handle the form, I haven't a clue what any of the functions actually do, so you'll have to help me out a bit here.

What do select() and option() actually do?  

Eg what are their parameters and what is the expected output?
What are the 'else' statements for?

[kilbey1]

Apologies for the lack of

 tags.

Here are the select() and option() parameters and output:

Select:
[code=php]
function select($name,$label=null,$multiple=null){
	$element[type]		="select";
	$element[name]		=$name;
	$element[label]		=$label;
	$element[multiple]	=$multiple;
	return $this->addElement($element);
}

Option:

function option($value,$name,$element_num,$selected=null){
	$option[name]	=$name;
	$option[element]=$element_num;
	$option[value]	=$value;
	$option[selected] =$selected;
	array_push($this->select_options,$option);
}

As for the else statements...
I'm attempting to say is if the enum value from field price_range is '$10 - 25' (or whatever is selected in enum field price_range) then $a (or $selected=null) needs to have SELECTED turned on (ie. not null). Otherwise, keep it null.

Result: $10 - 25 would be selected in dropdown box.

Full source code is attached in zip file.

[archangel_617b]

Okay. I'm still not clear what option("", 'None', $num, $a) is supposed to do, but when doing the conditions, try just specifying 'true' if the condition is met and null if it is not rather then using the intermediate $a. Something like this:

$num = $frm->select("price_range","Price Range:");

if ($price_range=="Less than $10")
     $frm->option('Less than $10','Less than $10',$num,true);
else
     $frm->option('Less than $10','Less than $10',$num);

if ($price_range=="$10 - $25") 
    $frm->option('$10 - $25','$10 - 25',$num,true);
else
    $frm->option('$10 - $25','$10 - 25',$num);

if ($price_range=="$25 - $50") 
    $frm->option('$25 - $50','$25 - $50',$num, true);
else
    $frm->option('$25 - $50','$25 - $50',$num);

if ($price_range=="More than $50") 
    $frm->option('More than $50','More than $50',$num,true);
else
    $frm->option('More than $50','More than $50',$num);

This checks each range as it is being printed and if $price_range matches the current range it adds 'true' so it will be 'selected'.

[kilbey1]

Hi, thanks for your help.

I tried what you suggested, and after playing with the code, I find that it doesn't choose anything as selected. So I still don't know what might be wrong.

One interesting note that may solve a mystery. There is a function built into the code known as SQLSELECT, which takes these parameters:

$frm->sqlselect('name',['label'],'sql','blank','selected');
#default label = null
# sql should select 2 fields, id and name
# blank leaves a blank entry at the top of the list
# selected is the id of the selected entry

I tested it using this code below:

$frm->sqlselect("price_range","Price Range:","SELECT restaurant_id,price_range FROM dining_restaurants ORDER BY price_range",'blank','$_GET[price_range]');

And I pull up a dropdown list with values:
None
$10 - $25
$25 - 50

But you'll notice, no 'Less than $25' or 'More than $50'.

I was curious if enum doesn't allow certain things, so I tried it using values '< $25' and '> $50' in the database. Still no luck, however.

• Eve