Jump to content

GetMenu2 Properties - Assigning value from mysql


Anandlall12

Recommended Posts

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>

Archived

This topic is now archived and is closed to further replies.

×
×
  • Create New...

Important Information

We have placed cookies on your device to help make this website better. You can adjust your cookie settings, otherwise we'll assume you're okay to continue.