I perfomed a test on UsersMachine RS. I placed data & made repeat region on it.
Results were correct with an error:
5 20 14 22 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
5 20 14 22 are correct.
I used this for above results:
<?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);
?>
<?php do { ?>
<?php echo $row_UsersMachines['EmpID'] ?>
<?php } while ($row_UsersMachines = mysql_fetch_assoc($UsersMachines)); ?>
But the error is cause of this Rs:
<?php
mysql_select_db($database_con1, $con1);
$query_Employees = "SELECT * FROM Users WHERE ID IN (".$row_UsersMachines['EmpID'].")";
$Employees = mysql_query($query_Employees, $con1) or die(mysql_error());
$row_Employees = mysql_fetch_assoc($Employees);
$totalRows_Employees = mysql_num_rows($Employees);
?>
Is the problem with Post value?
well if so then what is the other option available.
Basically its like a category to choose & then depending upon that categoryID data will be displayed.
I used post value from previous page here.
Any other solutions?