WebSVN – phpLibraryV2 – Diff – /head/DBQuery.class.php

       }  // function doSQL
       public function run () {
          return $this->doSQL( );
+      }
+      /**
+       * returns an array of the first column for each row returned from query
+       *
+       * The query is run, then for each row returns, the first column
+       * is added to $return (an array). $return is then returned.
+       *
+       * Used to do things like get an array of keyfields, or something
+       * else.
+       *
+       * @param string $query Query to run
+       * @returns string[] Array of values
+       */
+      public function columnToArray( $query ) {
+         $return = array();
+         $result = $this->doSQL( $query );
+         foreach ( $result['returnData'] as $row ) {
+            $return[] = $row['id'];
+         }
+         return $return;
+      }
       /*
        * function will return one and only one row, NOT as an array of array
        * but as a single row array
        * if more than one row is returned by query, error is set and function
       // function returns the first column of the first row of data returned from query
       // or null no value returned
       public function getOneDBValue( $sql = null ) {
+         //print '<pre>' . $sql . '</pre>';
          if ( isset( $sql ) )
             $this->parameters[ 'query' ] = $sql;
          $save = $this->parameters['returntype'];
          $this->parameters['returntype'] = 'array';
          $this->run();

Subversion Repositories phpLibraryV2