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
|
