TalkPHP - View Single Post

sketchMedia · 12-15-2007, 12:16 PM

yea a join would do it:

mysql Code:

SELECT games.title, catagory.name
FROM games
JOIN catagory ON ( games.id = catagory.games ) 
WHERE catagory.name =  'pogo'

or something to that effect

12-15-2007, 12:16 PM	#2 (permalink)
sketchMedia The Prestige Join Date: Oct 2007 Location: Manchester, UK Posts: 854 Thanks: 32	yea a join would do it: mysql Code: SELECT games.title, catagory.name FROM games JOIN catagory ON ( games.id = catagory.games ) WHERE catagory.name = 'pogo' or something to that effect __________________ mysql> SELECT * FROM `users` WHERE `users`.`clue` > 0; Empty set (0.00 sec)