need help displaying mysql data

[Butcherman]

I need to display information from one row of data in my MySQL table. Everything that I can find online shows me how to display specific columns for all rows but not to identify one entry.

I am building a database and php page for my movie collection. I have two tables, table 1 has columns: ID, Name, CoverLocal, Location, Genra. Table 2 has columns: ID, Table1ID, Rating, Year, DateAdded.

The first page queries all of my movies and displays the cover of all my movies. If one is clicked on it goes to a second page and carries the ID of the movie with it (all this is working). On the second page I want it to display all the information about that movie. I cannot figure out how to get the MySQL data for that one entry.

If someone has a better way to lay out my tables as well let me know.

[dagon]

look at the WHERE clause for the SELECT function

[Butcherman]

Thank you.

Is there any benifit to using multiple tables or should I just stick to one table for everything?

[bradgrafelman]

Butcherman wrote:

Is there any benifit to using multiple table

Without a doubt, yes, there often is an advantage. You should really read some articles on basic database design as well as database normalization; it's not a field you can jump into or even completely learn in a week.