View Single Post
09-21-2012, 11:24 PM
#11
Dan is offline Dan
Dan's Avatar
Status: Request a custom title
Join date: Feb 2005
Location:
Expertise:
Software:
 
Posts: 3,164
iTrader: 15 / 86%
 

Dan is an unknown quantity at this point

  Old

Nailed the code into a single query.

PHP Code:
SELECT `ft`.`slug`, `ft`.`titleFROM `forum topics` AS `ftWHERE `ft`.`themeIN(SELECT `t`.`idFROM `users themes` AS `utLEFT JOIN `themes` AS `tON `ut`.`themeid` = `t`.`idWHERE `ut`.`userid` = '{$user->id}'ORDER BY `ft`.`dateASC 

Reply With Quote