Followed your instructions. When I try to test that page now I get this error:
Parse error: syntax error, unexpected ';' in C:\xampp\htdocs\serving\Untitled-2.php on line 16
And this is line 16:
$ServingQuery->bindParam("s", "".(isset($_GET['UserFirstName'])?$_GET['UserFirstName'];"") ."", "-1"); //paramFirstName
Here's the rest of the page after making the changes in case you need to see it.
<?php require_once('Connections/local_i.php'); ?>
<?php require_once('webassist/mysqli/rsobj.php'); ?>
<?php
$ServingQuery = new WA_MySQLi_RS("ServingQuery",$local_i,1);
$ServingQuery->setQuery("SELECT pcms2_users.UserID, pcms2_users.UserFirstName, pcms2_users.UserLastName, kids_program_shifts.kp_team_id, kids_program_shifts.kp_volunteer, cleaning_team_shifts.cleaning_team_id, cleaning_team_shifts.ct_volunteer, serving_team.* FROM pcms2_users INNER JOIN kids_program_shifts ON pcms2_users.UserID = kids_program_shifts.kp_volunteer INNER JOIN cleaning_team_shifts ON pcms2_users.UserID = cleaning_team_shifts.ct_volunteer INNER JOIN serving_team ON cleaning_team_shifts.cleaning_team_id = serving_team.id AND kids_program_shifts.kp_team_id = serving_team.id WHERE pcms2_users.UserFirstName = ? AND pcms2_users.UserLastName = ?");
$ServingQuery->bindParam("s", "".(isset($_GET['UserFirstName'])?$_GET['UserFirstName'];"") ."", "-1"); //paramFirstName
$ServingQuery->bindParam("s", "".(isset($_GET['UserLastName'])?$_GET['UserLastName'];"") ."", "-1"); //paramLastName
$ServingQuery->execute();
?>
<!doctype html>
<html>
<head>
<meta charset="utf-8">
<title>Untitled Document</title>
</head>
<body>
<form method="get">
<input type="search" name="UserFirstName" id="UserFirstName">
<input type="search" name="UserLastName" id="UserLastName">
<input type="submit" name="search" value="search">
<?php
while(!$ServingQuery->atEnd()) {
?>
<?php echo($ServingQuery->getColumnVal("UserFirstName")); ?>
<?php echo($ServingQuery->getColumnVal("UserLastName")); ?>
<?php echo($ServingQuery->getColumnVal("team")); ?>
<?php
$ServingQuery->moveNext();
}
$ServingQuery->moveFirst(); //return RS to first record
?>
</form>
</body>
</html>