No more syntax error, but it's returning a blank result in the "team" column.
<?php require_once('Connections/local_i.php'); ?>
<?php require_once('webassist/mysqli/rsobj.php'); ?>
<?php
$ServingQuery = new WA_MySQLi_RS("ServingQuery",$local_i,0);
$ServingQuery->setQuery("SELECT pcms2_users.UserID, pcms2_users.UserFirstName, pcms2_users.UserLastName FROM pcms2_users WHERE (pcms2_users.UserFirstName = ? OR ? = -1) AND (pcms2_users.UserLastName = ? OR ? = -1)");
$ServingQuery->bindParam("s", "".(isset($_GET['UserFirstName'])?$_GET['UserFirstName']:"") ."", "-1"); //paramFirstName1
$ServingQuery->bindParam("s", "".(isset($_GET['UserFirstName'])?$_GET['UserFirstName']:"") ."", "-1"); //paramFirstName2
$ServingQuery->bindParam("s", "".(isset($_GET['UserLastName'])?$_GET['UserLastName']:"") ."", "-1"); //paramLastName1
$ServingQuery->bindParam("s", "".(isset($_GET['UserLastName'])?$_GET['UserLastName']:"") ."", "-1"); //paramLastName2
$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 if((isset($_GET['UserFirstName']) && $_GET['UserFirstName'] != "") OR (isset($_GET['UserLastName']) && $_GET['UserLastName'] != "")) { ?>
<?php
while(!$ServingQuery->atEnd()) {
$userId = $ServingQuery->getColumnVal("UserID");
?>
<table width="50%" border="1">
<tbody>
<tr>
<td align="center">First Name</td>
<td align="center">Last Name</td>
<td align="center">Serving Areas</td>
</tr>
<tr>
<td><?php echo($ServingQuery->getColumnVal("UserFirstName")); ?></td>
<td><?php echo($ServingQuery->getColumnVal("UserLastName")); ?></td>
<?php
$nestedsandor = new WA_MySQLi_RS("nestedsandor",$local_i,1);
$nestedsandor->setQuery("SELECT serving_team.*, cleaning_team_shifts.*, clerical_team_shifts.*, it_team_shifts.id, it_team_shifts.it_team_id, it_team_shifts.it_volunteer, youth_program_shifts.* FROM serving_team INNER JOIN cleaning_team_shifts ON serving_team.id = cleaning_team_shifts.cleaning_team_id INNER JOIN clerical_team_shifts ON serving_team.id = clerical_team_shifts.id INNER JOIN it_team_shifts ON serving_team.id = it_team_shifts.id INNER JOIN youth_program_shifts ON serving_team.id = youth_program_shifts.id WHERE youth_program_shifts.yp_volunteer = ?");
$nestedsandor->bindParam("s", "".(isset($_GET['UserID'])?$_GET['UserID']:"") ."", "-1"); //WAQB_Param1
$nestedsandor->execute();
?>
<td><?php echo($nestedsandor->getColumnVal("team")); ?></td>
</tr>
</tbody>
</table>
<?php
$ServingQuery->moveNext();
}
$ServingQuery->moveFirst(); //return RS to first record
?>
<?php } ?>
</form>
</body>
</html>
