[PHPMyEdit-Discuss] Problem with drop down list.

[Steve B. <sb...@se...>]

I have several drop down lists running in PhpMyEdit  in several
different tables but have been having troubles with one that I cannot
solve.

 

Problem is that when I select a value and save the record,  then view
the record,  the value has been saved.  However when I reopen the record
to edit,  the value defaults to the first value in the list;

 

I am stumped.  Anybody have any ideas on what am doing wrong?

 

The code that calls the field is:

 

$opts['fdd']['classification1'] = array(

  'name'     => 'Classification1',

  'select'   => 'D',

  'values' => array('table' => 'Classifications',  'column' =>
'classification'),

  'maxlen'   => 60,

  'sort'     => true

);

 

 

 

Here's the structure of the drop down list table:

CREATE TABLE Classifications (
   id int(11) NOT NULL auto_increment,
   classification varchar(60),
   PRIMARY KEY (id),
   UNIQUE id (id)
);

 

 

 

This is the code I am using for a another drop down list (another table)
that is working properly

 

$opts['fdd']['Project'] = array(

  'name'     => 'Project',

'values' => array('table' => 'Activities',     'column'    =>
'ProjectName'),

 

  'select'   => 'T',

  'maxlen'   => 40,

  'sort'     => true

);

 

Steve Buser