[TYPO3] SQL Query

[Peter Russ]

Felipe Knaesel Koch schrieb:
> Hi list,
> 
>  
> 
> Anyway of doing this: “SELECT re.uid reid, re.rid roid, ro.title room,
> re.event event, re.user user, co.date date, co.hid hour
> 
> FROM `tx_fkkcrr_reservations` AS re, `tx_fkkcrr_reservations_content` AS co,
> `tx_fkkcrr_rooms` AS ro
> 
> WHERE co.reid = re.uid
> 
> AND re.rid = ro.uid;” with $GLOBALS[‘TYPO3_DB’]? (except of course sql_query
> method).
> 
> Thanks
> _____________________________
> Felipe Knaesel Koch
> Auxiliar em Assuntos de Informática
> Laboratório de Computação Científica - CCT
> Universidade de Blumenau - FURB
> Fone: (47)3321-6073
> E-mail: felipek at furb.br
> 
>  
> 
$GLOBALS['TYPO3_DB']->exec_SELECTquery(
	're.uid reid, re.rid roid, ro.title room,re.event event, re.user user, 
co.date date, co.hid hour',
'`tx_fkkcrr_reservations` AS re, `tx_fkkcrr_reservations_content` AS 
co,`tx_fkkcrr_rooms` AS ro',
'co.reid = re.uid AND re.rid = ro.uid'
);


Should do it.

Regs. Peter.

-- 
Fiat lux!
Docendo discimus.
_____________________________
4Many® Services
openBC: http://www.openbc.com/go/invuid/Peter_Russ