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(23566)
}
}

Years ago
Townsville Crocs iPhone App - out now
Awesome work Rod, as usual doing more than your fair share to try and boost the profile of the league and your Crocodiles!
For those of us who dont really know what you actually do...can you give a brief outline of your position with the Crocs is and what you actualy do? Are you an employee or are you just one of those amazing people who does all the work for the love of the game/club?

Years ago
Great stuff,
So when will you be offering your services out to all NBL clubs ;)
Look forward to seeing some continued improvements RSS and live scores.
