Search results for query: *

Hi, I'm having trouble with the User privileges in phpmyadmin. Is there a way to reset it? or allow me full privileges. I set up the phpmyadmin myself. Thanks!

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...

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?

#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

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?

thanks. I really appreciate it. so when I do the PHP, do I take the PHP item from table one or table two?

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?

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...