[TYPO3] problem with sql query
Ries van Twisk
typo3 at rvt.dds.nl
Sun Feb 12 14:00:41 CET 2006
Daniel Pötzinger wrote:
>>i'm sure it is a stupid thing, however it drives me crazy.
>>i have the following sql query in my t3-extension:
>>$query = 'SELECT storage_pid FROM pages WHERE uid = '.$GLOBALS['TSFE']->id;
>>$storagePid = mysql(TYPO3_db, $query);
>>therewith i would like to receive the storage pid of the page, where my
>>extension is used in order to save the form entries in the corresponding
>It would be better to use the DBAL (see t3lib/class.t3lib_db.php)
>$row = $GLOBALS['TYPO3_DB']->sql_fetch_assoc($res)
>2.) There is no need for this select, T3 FE did already select these values:
Yes... NEVER EVER EVER NEVER EVER use direct mysql calls :) better use DBAL.
However the above is also the wrong way to get the storage PID.
$pids = $GLOBALS["TSFE"]->*getStorageSiterootPids*()
$pids can be a comma seperated list of ID's
More information about the TYPO3-english