Anandlall12 Posted March 10, 2014 Share Posted March 10, 2014 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> Link to comment https://forums.phpfreaks.com/topic/286842-getmenu2-properties-assigning-value-from-mysql/ Share on other sites More sharing options...
Recommended Posts
Archived
This topic is now archived and is closed to further replies.