array(2) {
[0]=>
string(815) "
select r.*,
rc.info,
t.title as threadtitle,
u.username as username,
u.anonymous as useranonymous,
`f`.`value` AS `flairvalue`,
`ft`.`name` AS `flairname`,
`ft`.`colour` AS `flaircolour`,
`ft`.`icon` AS `flairicon`
from reply as r
join thread as t on t.id = r.threadid
join replycontent as rc on rc.replyid = r.id
join user as u on u.id = r.userid
left join `flair` `f` on `f`.`userid` = `u`.`id` and `f`.`categoryid` = `t`.`categoryid`
left join `flairoption` `ft` on `ft`.`id` = `f`.`flairoptionid`
where r.businessid = :businessId
and r.threadid = :threadId
group by r.id
order by r.utcdated desc
limit 0,50
"
[1]=>
array(2) {
["businessId"]=>
int(1)
["threadId"]=>
int(312)
}
}

Years ago
FIBA Site
I think the site is great, but prob not as functional on older PCs.
With scores/info just keep in mind that you need to select the certain 'area' - oceania, americas etc for info on relevant countries.
I suppose this wont matter once Olympics is on as all will be under the same topic.
The Buzzer is great, had a few 'time not valid' errors to start with but sorted themselves out.
Liked the instant update the other night when Aust vs China where it popped up showing 'Heal just received 5th foul'... [evil laugh]
