I am having some issues assigning values from MySQL to GetMenu2 properties. I am trying to select a option by default, it works if I put a static number in but I would like it to load a value from MySQL column. php code: $employee=$rs->GetMenu2('sm_employee','2',null,null,null,'class="selmenu-noborders" onchange="this.form.submit()"'); $smarty->assign('employee', $employee); so basically what's going on here is I've assigned a class and java onChange to the GetMenu2 properties. everything works well but I would like it to "Select" a value from the list by default, which currently is "1" and it does select it, but I need it to get that value from MySQL table. Can anyone help with this? I've spent many hours on it but nothing.. This is the output in html: < select name="sm_employee" class="selmenu-noborders" onchange="this.form.submit()"> < option value='1'>Sam</option> < option selected='selected' value='2'>Nick</option> < option value='3'>James</option> < /select>