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 .