SQL Query to return just single value

hmm, it depends on how you query your database and what framework (methods) you use. Using query/fetch returns a row set, thus the arrays. When you need a scalar you need to return the column:

e.g. something like

$query = $connection->query("Select [Group2] from Table where Name = 'Me'");
$rowset = $query->fetch();
$scalar = $rowset["Group2"];

Select allOpen in new window

Pls try this...

Array[0][group2]

or

$query = $connection->query("Select [Group2] from Table where Name = 'Me'");
$scalar = $query->fetchColumn();

Select allOpen in new window

Sorry i a bit at a loss how to add it in. This is the full code that i am using that returns the before mentioned array but needs to bring back just a Y to the String $checkaccess

admin.php - File
$checkaccess = $dh->getUserData('admin');

dbquery.php - File
// #################################################################################
// Database Querys
// #################################################################################
      public function select($query){
                  $stmt = sqlsrv_query($this->conn,$query);
                  $result = array();
                  while( $row = sqlsrv_fetch_array( $stmt, SQLSRV_FETCH_ASSOC) ) {
                        //echo "<pre>";print_r($row);exit;
                        $result[] = $row;
                  }
                  return $result;
      }
      public function query($query){
                  $stmt = sqlsrv_query($this->conn,$query);
                  return $stmt;
      }
// #################################################################################
// Access Check
// #################################################################################
      public function getUserData($type){
            $tpxid = "";
            $tpxid = trim(substr($_SERVER['AUTH_USER'], strrpos($_SERVER['AUTH_USER'], '\\') + 1));
            $query = "  Select [admin] from [Users] where TPXid = '$tpxid'";
            //echo $query;exit;
            $result = $this->select($query);
            echo "<pre>";print_r($result);exit;
            //echo $result;exit;
            if($result == "Y"){
                  //echo $result."<BR>";
                  echo "Result is Yes";exit;
                  return $result;      
            }
            else{
                  //echo "Result is No";Exit;
                  $_SESSION['error_msg'] = "You are not an $type";
                  return;
                  
            }