Advertisement
Guest User

Untitled

a guest
Jun 1st, 2012
56
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 0.54 KB | None | 0 0
  1. <select id="teamlist" onchange= "SBtoTB()" name="teamlist">
  2. <?php
  3.  
  4. $pdo = new PDO('mysql:host=localhost;dbname=clubresults', 'root', '12345678');
  5. #Set Error Mode to ERRMODE_EXCEPTION.
  6. $pdo->setAttribute( PDO::ATTR_ERRMODE, PDO::ERRMODE_EXCEPTION);
  7.  
  8.  
  9.  
  10. $stmt = $pdo->prepare('Select teamname, member_id from members');
  11. $stmt->execute();
  12.  
  13. while($row = $stmt->fetch(PDO::FETCH_ASSOC)) {
  14.  
  15. echo "<option value=\"" . $row['member_id'] . "\">".$row['teamname']."</option>";
  16. }
  17. ?>
  18. </select>
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement