Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- <?php
- error_reporting(E_ALL);
- ini_set('display_errors' , '1');
- $studentssn = "0";
- /*echo "sth"*/
- $db = new PDO("dblib:Server=localhost;Database=dec3h" , "SA" , "mssqlR00T");
- $stmt = $db -> prepare("USE dec3h");
- $stmt->execute();
- $stmt = $db -> prepare("GO");
- $stmt->execute();
- $stmt = $db -> prepare("SELECT * FROM Clubs WHERE name IN (SELECT club_name FROM Clubs_Joined_By_Enrolled_Student WHERE enrolled_ssn = $studentssn"));
- $stmt->execute();
- while($row = $stmt->fetch())
- {
- echo "<tr>";
- echo "<td>3</td>";
- $count = 0;
- while($count < 2)
- {
- echo "<td>";
- echo $row[$count];
- echo "</td>";
- $count = $count + 1;
- }
- echo "</tr>";
- }
- ?>
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement