MySQLi recordset changes sporadically
I have a page that contains multiple recordsets (one of which is WADApcms2_users), but for some reason when I make changes or edit any recordest on the page other than WADApcms2_users the code of WADApcms2_users changes and give me an error.
The working code is:
<?php
$ParamUserID_WADApcms2_users = "-1";
if (isset($_GET['UserID'])) {
$ParamUserID_WADApcms2_users = $_GET['UserID'];
}
mysql_select_db($database_local, $local);
$query_WADApcms2_users = sprintf("SELECT UserID, UserEmail, UserFirstName, UserLastName, UserCity, UserState, UserZip, UserPhone, UserCountry, UserGender, UserAddress, UserAddress2, UserDOB, SmallGroup FROM pcms2_users WHERE UserID = %s", GetSQLValueString($ParamUserID_WADApcms2_users, "int"));
$WADApcms2_users = mysql_query($query_WADApcms2_users, $local) or die(mysql_error());
$row_WADApcms2_users = mysql_fetch_assoc($WADApcms2_users);
$totalRows_WADApcms2_users = mysql_num_rows($WADApcms2_users);$ParamUserID_WADApcms2_users = "-1";
if (isset($_GET['UserID'])) {
$ParamUserID_WADApcms2_users = $_GET['UserID'];
}
mysql_select_db($database_local, $local);
$query_WADApcms2_users = sprintf("SELECT UserID, UserEmail, UserFirstName, UserLastName, UserCity, UserState, UserZip, UserPhone, UserCountry, UserGender, UserAddress, UserAddress2, UserDOB, SmallGroup FROM pcms2_users WHERE UserID = %s", GetSQLValueString($ParamUserID_WADApcms2_users, "int"));
$WADApcms2_users = mysql_query($query_WADApcms2_users, $local) or die(mysql_error());
$row_WADApcms2_users = mysql_fetch_assoc($WADApcms2_users);
$totalRows_WADApcms2_users = mysql_num_rows($WADApcms2_users);?>
The error code that it changes to is:
<?php
$ParamUserID_WADApcms2_users = "-1";
if (isset($_GET['UserID'])) {
$ParamUserID_WADApcms2_users = $_GET['UserID'];
}
mysql_select_db($database_local, $local);
$query_WADApcms2_users = sprintf("SELECT UserID, UserEmail, UserFirstName, UserLastName, UserCity, UserState, UserZip, UserPhone, UserCountry, UserGender, UserAddress, UserAddress2, UserDOB, SmallGroup FROM pcms2_users WHERE UserID = %s", GetSQLValueString($ParamUserID_WADApcms2_users, "int"));
$WADApcms2_users = mysql_query($query_WADApcms2_users, $local) or die(mysql_error());
$row_WADApcms2_users = mysql_fetch_assoc($WADApcms2_users);
$totalRows_WADApcms2_users = "-1";
if (isset($_GET['UserID'])) {
$totalRows_WADApcms2_users = $_GET['UserID'];
}
$ParamUserID_WADApcms2_users = "-1";
if (isset()) {
$ParamUserID_WADApcms2_users = ;
}
mysql_select_db($database_local, $local);
$query_WADApcms2_users = sprintf("SELECT UserID, UserEmail, UserFirstName, UserLastName, UserCity, UserState, UserZip, UserPhone, UserCountry, UserGender, UserAddress, UserAddress2, UserDOB, SmallGroup FROM pcms2_users WHERE UserID = %s", GetSQLValueString($ParamUserID_WADApcms2_users, "int"));
$WADApcms2_users = mysql_query($query_WADApcms2_users, $local) or die(mysql_error());
$row_WADApcms2_users = mysql_fetch_assoc($WADApcms2_users);
$totalRows_WADApcms2_users = mysql_num_rows($WADApcms2_users);?>
What is causing this and how can I fix it, other than pasting the working code back into the page? The page is attached to this message also.