Would someone be able to check my code and tell me what I'm missing? The query runs fine and it does what it's supposed to, but it doesn't finish properly. Essentially it keeps processing and eventually I get a PHP timeout error.
global $conn;
$strSQLSelect1 = "SELECT READERID, PANELID FROM dbo.Reader2";
$rsSelect1 = db_query($strSQLSelect1,$conn);
WHILE ($fetchdata1 = db_fetch_array($rsSelect1))
{
$strSQLSelect2 = "SELECT READERID, PANELID FROM dbo.READER WHERE READERID = ".$fetchdata1["READERID"]." AND PANELID = ".$fetchdata1["PANELID"]."";
$rsSelect2 = db_query($strSQLSelect2,$conn);
WHILE ($fetchdata2 = db_fetch_array($rsSelect2))
{
IF ($fetchdata2["READERID"] == '' AND $fetchdata2["PANELID"] == '')
{
$strSQLUpdate = "UPDATE dbo.Reader2 SET Active = 0 WHERE READERID = ".$fetchdata1["READERID"]." AND PANELID = ".$fetchdata1["PANELID"]."";
$rsUpdate = db_query($strSQLUpdate,$conn);
}
ELSE
{
$strSQLUpdate = "UPDATE dbo.Reader2 SET Active = 1 WHERE READERID = ".$fetchdata1["READERID"]." AND PANELID = ".$fetchdata1["PANELID"]."";
$rsUpdate = db_query($strSQLUpdate,$conn);
}
}
}