/ Published in: PHP
Expand |
Embed | Plain Text
Copy this code and paste it in your HTML
<?php include ('connect.php'); $fid = $_GET['id']; $query = "SELECT Distinct enrollment.className, users.name FROM enrollment INNER JOIN users ON enrollment.fid = users.fid INNER JOIN class ON enrollment.className = class.className where users.fid ='".$fid."'"; //$query = "SELECT FROM enrollment w fid ='".$fid."'"; $title = 0; { if($title == 0) { echo "<h1>".$row['name']."'s Classes!</h1>"; echo "<ol>"; $title++; } echo "<li>".$row['className']."</li>"; } echo "</ol>"; ?>