View Single Post
06-04-2012, 04:20 PM
#9
Village Genius is offline Village Genius
Village Genius's Avatar
Status: Geek
Join date: Apr 2006
Location: Denver, CO
Expertise: Software
Software: Chrome, Notepad++
 
Posts: 6,894
iTrader: 18 / 100%
 

Village Genius will become famous soon enough

  Old

I'd name the columns then, something like the following but with more descriptive names

Code:
SELECT topics.field1 AS name1, users.field2 AS name2, [ect]
FROM `forum topics` topics
LEFT JOIN users ON users.id=topics.author
WHERE slug=[$slug]

Thanked by:
Dan (06-04-2012)