Hello and welcome to our community! Is this your first visit?
Register
Enjoy an ad free experience by logging in. Not a member yet? Register.
Results 1 to 3 of 3
  1. #1
    New to the CF scene
    Join Date
    Aug 2011
    Posts
    1
    Thanks
    0
    Thanked 0 Times in 0 Posts

    problem with php and tables

    Hi guys,

    I have a problem with three tables i have. There are 3 tables, which contains a person name and its id, other tables contains a movie title, id for the movie and a person_id which is for director of the movie and relates to the first table, and the third table is for movie_id and the person_id that specifies which person of the first table plays in the film of the second table.

    My big problem is that i can show the list of movies, but when it comes to search for the director it just show the director of the first movies and other field are blank. I got problem in resetting the fetch_assoc, for the first movie it searches for the director in the first table by using the person_id of second table, but after that it won't reset and so other fields will be blank.

    this is my code:

    <?php

    require 'connect.php';

    $mares = mysql_query ("
    SELECT * FROM movie_actor
    ");

    $mdres = mysql_query ("
    SELECT * FROM movie
    ");
    $pres = mysql_query ("
    SELECT * FROM person
    ");

    ?>
    <!doctype html>
    <html>
    <head>

    <title>Show Details</title>

    </head>
    <body>

    <table>
    <tr>
    <td width="40%">Film Title</td>
    <td width="25%">Director Title</td>
    <td width="25%">Actor Title</td>
    <td width="25%">Role in the Movie</td>
    </tr>

    <?php while ($mdrow = mysql_fetch_assoc($mdres)) { ?>

    <tr>

    <td width="40%"><?php echo $mdrow['movie_title']; ?></td>
    <?php while ($prow = mysql_fetch_assoc($pres)) { ?>
    <td width="25%"><?php if ($mdrow['movie_person_id'] == $prow['person_id']) { ?>
    <?php echo $prow['person_title']; ?>
    <?php } ?></td>

    </tr>
    <?php } ?>
    <?php } ?>


    </table>

    </body>
    </html>

    I'm at a total loss.
    Could anyone please help me?

  • #2
    m1l
    m1l is offline
    New to the CF scene
    Join Date
    Aug 2011
    Posts
    8
    Thanks
    0
    Thanked 1 Time in 1 Post
    I'd personally say you would be better doing this in SQL, I don't know your exact field links, so I couldn't give you some SQL but I think doing it in SQL is the way to go.

  • #3
    God Emperor Fou-Lu's Avatar
    Join Date
    Sep 2002
    Location
    Saskatoon, Saskatchewan
    Posts
    16,980
    Thanks
    4
    Thanked 2,659 Times in 2,628 Posts
    This is a task mostly dependent on SQL with a minor variation in PHP for the looping to display depending on what you want the output to look like. These descriptions are too vague, run a DESC movie_actor; DESC movie; DESC person and show us the structure of the database tables.

  • Users who have thanked Fou-Lu for this post:

    CodeGeek83 (09-01-2011)


  •  

    Posting Permissions

    • You may not post new threads
    • You may not post replies
    • You may not post attachments
    • You may not edit your posts
    •