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> Quote Link to comment https://forums.phpfreaks.com/topic/286842-getmenu2-properties-assigning-value-from-mysql/ Share on other sites More sharing options...
Recommended Posts
Join the conversation
You can post now and register later. If you have an account, sign in now to post with your account.