echo "spval.php.......";

try {
                    setlocale(LC_MONETARY, 'en_US.UTF-8'); #format as US Currency
                    #1 $sqlCmd = "SELECT * FROM fidelity ORDER BY fidId DESC ";
                    #1 $stmt = $pdo->prepare($sqlCmd);
                    #1 $stmt->execute();
                    $sqlCmd = "SELECT * FROM fidelity ORDER BY fidId DESC LIMIT :limitRows";
                    $sqlCmd="SELECT `fidId`,`fidTot`,`fidIndiv`,`fidPer`, `fidProMan`, `fidSep`,`fidCurDate`, `fidComment` FROM `fidelity`  ORDER BY :orderBy :order LIMIT :limitRows";
                    $sqlCmd="SELECT `fidId`,`fidTot`,`fidIndiv`,`fidPer`, `fidProMan`, `fidSep`,`fidCurDate`, `fidComment` FROM `fidelity`  ORDER BY fidId DESC LIMIT :limitRows";


                    #Works $sqlCmd="SELECT `fidId`,`fidTot`,`fidIndiv`,`fidPer`, `fidProMan`, `fidSep`,`fidCurDate`, `fidComment` FROM `fidelity`  ORDER BY $orderBy DESC LIMIT :limitRows;";
                    $sqlCmd="SELECT `fidId`,`fidTot`,`fidIndiv`,`fidPer`, `fidProMan`, `fidSep`,`fidCurDate`, `fidComment`,  `at420`,`ai163`,`ar091`,`as551`,`mi866`,`mi543`,`mt592`  FROM `fidelity`  ORDER BY $orderBy DESC LIMIT :limitRows;";
                    if ( !empty($sp))  {
                      #TEST $sqlCmd="CALL getToday('2018-04-12')";
                      #TEST $sqlCmd="CALL getToday(:searchVal);";
                      #TEST $sqlCmd="CALL getDate('2018-04-12', '@output')";
                      #TEST $sqlCmd="CALL getWeek(:searchVal);";
                      $viewName="sp:$sp  $spVal  View Order: $orderBy Limit Records to: $limitRows";
                      if ($sp === 'getDate') {
                        $sqlCmd="CALL $sp(:searchVal);";
	                      $params=array( ":searchVal" => $spVal);
                      } else if ($sp === 'getMonth') {
                        $sqlCmd="CALL $sp(:searchVal, :searchVal2);";
                        $params=array( ":searchVal" => $spVal, ":searchVal2" => $spVal2);
                        $orderBy="ORDER BY fidelity.fidCurDate DESC";
                        $viewName="sp:$sp :  ($spVal, $spVal2)  View Order: $orderBy ";#Limit Records to: $limitRows";
                      } else if ($sp === 'getYear') {
                        $sqlCmd="CALL $sp(:searchVal);";
	                      $params=array( ":searchVal" => $spVal);
                        $orderBy="ORDER BY fidelity.fidCurDate DESC";
                        $viewName="sp:$sp  ($spVal, $spVal2)  View Order: $orderBy Limit"; # Records to: $limitRows";
                      }  else if ($sp === 'getWeek') {
                        $sqlCmd="CALL $sp(:searchVal, :searchVal2);";
                        ##NOT WORKING $params=array( ":searchVal" => \\"$spVal\\", ":searchVal2" => \\"$spVal2\\");
                        $params=array( ":searchVal" => $spVal, ":searchVal2" => $spVal2);
                        $orderBy="ORDER BY fidelity.fidCurDate DESC";
                        $viewName="spWEEK:$sp  ($spVal, $spVal2)  View Order: $orderBy ";#Limit Records to: $limitRows";
                      } else if ($sp === 'fidDayTotal') {
                        $sqlCmd="CALL $sp(:searchVal);";
                        $sqlCmd="CALL $sp();";
                        unset($params);  #NO ARGUMENTS TO SP
                        $ordery="ORDER BY fidelity.fidCurDate DESC";
                        $viewName="X sp:$sp  ($spVal)  View Order: $orderBy Limit"; # Records to: $limitRows";
                        ##NOT WORKING $params=array( ":searchVal" => \\"$spVal\\", ":searchVal2" => \\"$spVal2\\");
                      } else {
                        //NEVER GET HERE  INBALID SP 
#alert('error no sp known: '. $sp);
                      }
  #if SP
                    } else {
                      $sqlCmd="SELECT `fidId`,`fidTot`,`fidIndiv`,`fidPer`, `fidProMan`, `fidSep`,`fidCurDate`, `fidComment`,  `at420`,`ai163`,`ar091`,`as551`,`mi866`,`mi543`,`mt592`  FROM `fidelity`  ORDER BY $orderBy DESC LIMIT :limitRows;";

                      #WORKS $sqlCmd="SELECT `fidId`,`fidTot`,`fidIndiv`,`fidPer`, `fidProMan`, `fidSep`,`fidCurDate`, `fidComment` FROM `fidelity`  ORDER BY fidId DESC LIMIT :limitRows;";
	                    #WORKS $params=array( ":limitRows" => $limitRows);
	                    #$params=array( ":limitRows" => $limitRows, ":orderBy" => "fidId");
	                    $params=array( ":limitRows" => $limitRows);

                      $placeHolders = array (':limitRows');
                      $debugParams = array ($limitRows);
                    }
$newSqlCmd= pdoDebug($sqlCmd,$placeHolders, $debugParams);
#echo "**** ORIG: " . $sqlCmd. PHP_EOL;
#echo "**** CORRECTED: " . $newSqlCmd. PHP_EOL;
                    $stmt = $pdo->prepare($sqlCmd);
                    if (!empty($params) ) {
	                    $stmt->execute($params);
                    } else {
	                    $stmt->execute();
                    }
#$stmt->bind_param($limitRows);
                    #xxxx
	###$stmt->execute(array( "fidId" => $fidId));
                    $results = $stmt->fetchAll(PDO::FETCH_ASSOC);
                    if ( !empty($sp))  {
                      #SP COMMAND CALLED
                      #XXX DEBUG echo "<tr><td>SQLCMD=".$sqlCmd;
                      #XXX DEBUG #print_r( $results);
                      #XXX DEBUG echo "</td></tr>";
                    } else {
                      #REGULAR SQL COMMAND
                    }
                    $sqlCmd="SELECT `fidId`,`fidTot`,`fidIndiv`,`fidPer`, `fidProMan`, `fidSep`,`fidCurDate`, `fidComment` FROM `fidelity`  ORDER BY ? DESC LIMIT ?";
$stmt = $pdo->prepare($sqlCmd);
    $stmt -> execute(array("`fidMod`","9"));
    $row_count = $stmt->rowCount();
echo "</table>
echo "</div> <!-- /table-responsive -->";
echo "<pre>";
echo "COUNT=" $row_count;
    $results = $stmt->fetchAll(PDO::FETCH_ASSOC);
print_r($results);
echo "</pre>";
    exit;
#var_dump($results);
*/
} catch (Exception $e) {
  #DEBUG echo('error: Exception - catch');
    $error[] = $e->getMessage();
    $resp['error'][]=$error;
    $status=false;
    $msg= '<p class="alert alert-danger">' . 'ERROR DELETE: DELETE Something weird happened</p>'; //something a user can understand
    $debug='<p class="alert alert-danger">' . "DEBUG: ERROR DELETE: " . $e->getMessage().'</p>';
      $resp = array("valid"=>false, "msg"=>$msg, "data"=>$data, "error"=>$e->getMessage(), "debug"=>"$debug : fid=$fidId info");
      #DEBUG echo "<pre>";
      #DEBUG print_r($resp);
      #DEBUG echo "</pre>";

	  error_log($e->getMessage()); //In production
		echo '<p class="alert alert-danger">' . "YXX ERROR : " . $e->getMessage().'</p>';
    if ($debugFlg)
		  echo '<p class="alert alert-danger">' . "ERROR : " . $e->getMessage().'</p>';
	  exit('<p class="alert alert-danger">' . 'ERROR : Something weird happened</p>'); //something a user can understand
}
                    $rowCount=count($results);
                        if ($rowCount === 0 )
                          echo "NO RECORDS FOUND!!!!";
                     #XXXX 
    echo '<div class="col-md-6 "><div class="text-centered">Current View: <span id="viewTitle" class="text-white bg-primary">'. $viewName .'</div></div>';
    echo '<div class="col-md-4"><span class="float-right">Records Found: <span id="rowCnt">'. $rowCount.' </span></span></div>';
  echo '</div><!-- /row --> </div> <!-- /container -->';

                    // If you need to fetch them now, put it in a while loop just like below:
                    if($rowCount>0) {
                       for ($i=0; $i< $rowCount; $i++) {
                         $data = $results[$i];
                    ?>
                    <tr id="fidId">
                    <td class="col1"></td>