Displaying data from a linked table and displaying it as a list with HTML/PHP/MySQL

Posted by user1672694 on Stack Overflow See other posts from Stack Overflow or by user1672694
Published on 2012-11-03T04:39:57Z Indexed on 2012/11/03 5:00 UTC
Read the original article Hit count: 252

Filed under:
|
|

I have three tables.

students
studentID | FirstName | LastName | Email | Form  

course
CCode | Title  

courseenrolement
courseenrolementid | studentID | ccode | complete | scode

With the website, I have a page where I can view all the current enrolements and I wish to be able to view the list displaying the first name, surname and course title. I know I could do it with the following SQL (for the names):

SELECT FirstName, LastName FROM student, courseenrolement 
WHERE courseenrolement.studentID = student.studentID

But I am unsure how to get this to work using HTML/PHP. At present I only know how to display the studentID and CCode from the courseenrolement table using the following code:

<ul>
  <?php foreach ($courseenrolements as $ce): ?>
    <li>
      <form action="" method="post">
        <div>
          <?php htmlout($ce['studentID']); ?>
          <?php htmlout($ce['CCode']); ?>
          <input type="hidden" name="courseenrolementid" value="<?php
              echo $ce['courseenrolementid']; ?>">
          <input type="submit" name="action" value="Edit">
          <input type="submit" name="action" value="Delete">
        </div>
      </form>
    </li>
  <?php endforeach; ?>
</ul>

which displays this:

output

But I would like the names and course title. I managed to get it to show the names etc in the dropdown on the 'Add new' form, so I would assume it will be similar, but just unsure on how exactly. Thanks in advance

© Stack Overflow or respective owner

Related posts about php

Related posts about html