Operand should contain 1 column(s)

Wierd error: Operand should contain 1 column(s)
This is appearing after i added

AND UserGroupID = (2,11)

<?php
mysql_select_db($database_con1, $con1);
$query_Employees = "SELECT * FROM Users WHERE ID IN (".$row_UsersMachines['EmpID'].") AND UserGroupID = (2,11)";
$Employees = mysql_query($query_Employees, $con1) or die(mysql_error());
$row_Employees = mysql_fetch_assoc($Employees);
$totalRows_Employees = mysql_num_rows($Employees);
?>

The results of these are not shown. When i remove AND UserGroupID = (2,11) results are shown. But i need this filter that UserGroupID must be 2 or 11.

File attached.

That should be: AND UserGroupID IN (2,11)

AND UserGroup IN (2,11)?

U mean AND UserGroupID?

I tried both .. didnt work..

If i do UserGroup says wrong column & UserGroupID then



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 1

Under User Table there is :

Name, Email, UserGroupID

Yes UserGroupID.... you can't pass multiple values with an '=' comparison... you need to use IN if you want to pass more than one value comma separated.

Getting this error : 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 1

Write your SQL statement to the page and see what it looks like:

$query_Employees = "SELECT * FROM Users WHERE ID IN (".$row_UsersMachines['EmpID'].") AND UserGroupID IN (2,11)";
die($query_Employees);

My guess is that the UsersMachines Recordset isn't returning a result.

FYI the RS is within repeat region of UsersMachine.
I tried as above. Error :


SELECT * FROM Users WHERE ID IN (6) AND UserGroupID IN (2,11)


UserMachine RS:

<?php

$colname_UsersMachines = "-1";
if (isset($_POST['validation-classic-machine'])) {
  $colname_UsersMachines = $_POST['validation-classic-machine'];
}
mysql_select_db($database_con1, $con1);
$query_UsersMachines = sprintf("SELECT * FROM UsersMachines WHERE MachineID = %s", GetSQLValueString($colname_UsersMachines, "int"));
$UsersMachines = mysql_query($query_UsersMachines, $con1) or die(mysql_error());
$row_UsersMachines = mysql_fetch_assoc($UsersMachines);
$totalRows_UsersMachines = mysql_num_rows($UsersMachines);
?>

It is using form post to filter with MachineID.. UserMachine is a relational-table of .

That looks like a good SQL statement to me. I'm not sure why it would error. Is it possible a different recordset is throwing the error?

Try cutting and pasting that SQL statement into phpMyAdmin and see if it works.

But a if (isset($_POST['validation-classic-machine'])) {
post value is required. There are 2 RS.

File attached