I want to trace a disease with take from other table signs
table signs
+-----+-------------+
+ ID + Gejala +
+-----+-------------+
+ 1 + Bleeding +
+ 2 + Swollen +
+ 3 + Festering +
+-----+-------------+
in table usertraces add.ctp, I'm expect output here
<?php
echo $this->Form->control('NoUser', array('type' => 'text', 'value' => $sesuserID));
echo $this->Form->control('Nama', array('type' => 'text', 'value' => $sesusernama));
echo $this->Form->control('Gejala', array('type' => 'select', 'value' => //the value I'm take from other table signs column Gejala));
echo $this->Form->submit('TAMBAH');
?>
how genereate query in usertracesController,
thanx for anyone to help me,…