View Single Post
06-04-2012, 11:55 AM
#3
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

Yeah it's one table. Is this method better than actually joining the two tables?

Here's what I had:

SELECT * FROM `forum topics` t join `users` u on `u.id` = 't.author' WHERE `t.slug` = '{$slug}' ORDER BY `t.id` LIMIT 1

Reply With Quote