Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- <select id="teamlist" onchange= "SBtoTB()" name="teamlist">
- <?php
- $pdo = new PDO('mysql:host=localhost;dbname=clubresults', 'root', '12345678');
- #Set Error Mode to ERRMODE_EXCEPTION.
- $pdo->setAttribute( PDO::ATTR_ERRMODE, PDO::ERRMODE_EXCEPTION);
- $stmt = $pdo->prepare('Select teamname, member_id from members');
- $stmt->execute();
- while($row = $stmt->fetch(PDO::FETCH_ASSOC)) {
- echo "<option value=\"" . $row['member_id'] . "\">".$row['teamname']."</option>";
- }
- ?>
- </select>
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement