[TYPO3-mvc] Extbase and individual select queries

Kerstin Eitner eitner.kerstin at googlemail.com
Mon Sep 20 14:12:32 CEST 2010


Hi everybody,

I read that it is possible to use the API of TYPO3 4.x to do sql queries 
within the repository.
e.g. $GLOBALS['TYPO3_DB]->exec_SELECT_query

I need that, because i just want to get some data from the tt_news table.

So I did something like that:
$res = $GLOBALS['TYPO3_DB']->exec_SELECT_query(
			'tt_news.uid',
			'tt_news',
			'uid = 1'
		);
if ($res) {
	$row = $GLOBALS['TYPO3_DB']->sql_fetch_assoc($res);
}

but I get the following error "Call to undefined method 
t3lib_DB::exec_SELECT_query()".


What am I doing wrong? Can someone please give me a hint?

Thanks in advance,
Kerstin Eitner


More information about the TYPO3-project-typo3v4mvc mailing list