Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- <?php
- $SQL = "SELECT m.MatchID AS id, t1.TeamName AS team1, t2.TeamName AS team2 , d1.GameStart AS gamestart , d2.GameEnd AS gameend
- FROM Matches m
- JOIN TeamTable t1 ON m.Team1 = t1.TeamID
- JOIN TeamTable t2 ON m.Team2 = t2.TeamID
- WHERE GameName = 2 , gameend < CURDATE()
- ORDER BY MatchID DESC
- LIMIT 10";
- //ORDER BY MatchID DESC";
- $r = mysql_query($SQL); ?>
- <div class="col-sm-2">
- <table class="table table-striped">
- <thead>
- <tr>
- <th>Team One</th>
- <th>Team Two</th>
- <th>Make a Bet!</th>
- </tr>
- </thead>
- <tbody>
- <?php while($match = mysql_fetch_assoc($r)): ?>
- <tr>
- <td><?php echo $match['team1']; ?></td>
- <td><?php echo $match['team2']; ?></td>
- <td><a class="btn btn-default" href="Usrbet2.php?match_id=<?php echo $match['id']?>">Bet!</a></td>
- </tr>
- <?php endwhile; ?>
- </tbody>
- </table>
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement