Forums

Hey,

I'm trying to add multiple dorpdown lists with multiple array.

When I'm only use 1 array (=selection joomla user group), it works.
But when a second array name is defined, I'm getting following error:

Error: 1064 - You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '' at line 3 SQL=SELECT `id`,`title` FROM `psygp_usergroups` WHERE `id` =

Hi brononius,

I can't tell much from here. It looks as though the problem is the where clause - WHERE `id` =

You need to check what is being set for the id there.

Bob

Found it...😉

I had some custom code in my 'submit' section that calls the usergroup stuff (see this forum ticket).

$myArray = explode(',', $form->data['functie']);
$form->actions_config[28]["new_usertype"] = $myArray;

After this code, I had the 'handle array'.
This needed to be in front of it...

Hi brononius,

. . . or you could leave out the explode() row which undoes the Handle Array implosion.

Bob