Index: t3lib/class.t3lib_db.php =================================================================== --- t3lib/class.t3lib_db.php (revision 6888) +++ t3lib/class.t3lib_db.php (working copy) @@ -363,6 +363,32 @@ } return $output; } + + /** + * Creates and executes a SELECT SQL-statement AND traverses result set and returns the specified field + * + * @param string See exec_SELECTquery() + * @param string See exec_SELECTquery() + * @param string See exec_SELECTquery() + * @param string See exec_SELECTquery() + * @param string See exec_SELECTquery() + * @param int from which row the field has to be returned + * @return string Value of specified field + */ + function exec_SELECTgetField($select_field, $from_table, $where_clause, $groupBy = '', $orderBy = '', $offset = 0) { + $res = $this->exec_SELECTquery($select_field, $from_table, $where_clause, $groupBy, $orderBy, intval($offset) . ', 1'); + if ($this->debugOutput) { + $this->debug('exec_SELECTquery'); + } + if (!$this->sql_error()) { + while($tempRow[] = $this->sql_fetch_assoc($res)); + $this->sql_free_result($res); + if (isset($tempRow[0][$select_field])) { + return $tempRow[0][$select_field]; + } + } + return false; + } /** * Counts the number of rows in a table.