Problem with php plugin

[uktran]

I have an issue with a php list plugin button. It's an annoying issue as it is working for about half the users but failing for the others.

$db = JFactory::getDBO();
$user = JFactory::getUser();
$userid = $user->get('id');
$useremail = $user->get('email');
$ids = JRequest::getVar( 'ids', array(), 'method', 'array' );

foreach ($ids AS $id) {

$row = $model->getRow($id);
$filename = $row->table___File;
$fileid = $row->table___id;

$InsertQuery="INSERT INTO othertable (userid, filename, rawemail, fileid)
VALUES ('$userid','$filename','$useremail','$fileid')";
$db->setQuery($InsertQuery);
$db->query();
}

 

[uktran]

Turns out that an 'and' sign '&' in a field is the culprit.

I've found a workaround.