Tek-Tips is the largest IT community on the Internet today!
Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!
-
Congratulations Chriss Miller on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
-
MYSQL Selection
I solved it. SELECT * FROM show_episodes, shows WHERE show_episodes.show_id=shows.id order by show_episodes.release_date desc limit 6 basically I just join the two tables and I just state what the bridge is between the two tables then go about my biz. thanks CLFLAVA, I wouldn't have gotten... -
MYSQL Selection
I'm not sure what type of error this is, but this is what I understand from what you showed me. 1) when I do select e.* - this means select from the database using the "e" as the first table in my list? 2) o.name - on the second line here - does this state the category I want to eventually get to? -
MYSQL Selection
#1064 - You have an error in your SQL syntax near 'on e.show_id = o.id order by e.release_date desc limit 6' at line 1 -
MYSQL Selection
Hi cLFlaVA, This is what I did, but its not working: select e.* , o.name from show_episodes e join shows o on e.show_id = o.show_id order by e.release_date desc limit 6; is there something I'm missing here? I tried a query and it didn't work? -
MYSQL Selection
thanks. I really appreciate it. so when I do the PHP, do I take the PHP item from table one or table two? -
MYSQL Selection
Thanks cLFlaVA! So basically I can join the two tables and take the ID# from table one and have it give me the show name it represents from table two. Is that how it would be written out? -
MYSQL Selection
Hi, I have a question on how I do a multiple selection from a database. Basically I have one table that is this: SELECT * FROM show_episodes ORDER BY show_episodes.release_date DESC LIMIT 6 but within this table is a (Show ID) number that represents the name of a show on another table within...
