Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- <?php
- $id=$_GET['id'];
- $loc="localhost";
- $username="sj";
- $password="blargh";
- $database="sj_xbl";
- $link = mysql_connect($loc,$username,$password);
- mysql_select_db($database) or die( "Unable to select database");
- $query = "SELECT * FROM matches WHERE id='$id' LIMIT 1";
- $result = mysql_query($query);
- if(mysql_numrows($result) !== 1){
- echo "Error";
- }
- $date = mysql_result($result, 0, "date");
- $id = mysql_result($result, 0, "id");
- $lteam = mysql_result($result, 0, "lteam");
- $wteam = mysql_result($result, 0, "wteam");
- $win = mysql_result($result, 0, "win");
- $loss = mysql_result($result, 0, "loss");
- mysql_close();
- ?>
- <?php require("includes/header1.inc"); ?>
- <title>Syndicate Jailers - Matches</title>
- <?php require("includes/header2.inc"); ?>
- <body>
- <?php require("includes/header3.inc"); ?>
- <div class="main_news_con">
- <div class="main_news_post">
- <div class="main_news_post_img">
- <img src="images/news_post_img.jpg
- </div>
- <div class="main_news_post_text_con">
- <div class="main_news_post_text_details">
- <div class="main_news_post_text_title">
- <a href="#">sJ Match List</a></div>
- <div class="main_news_post_text_date">
- </div>
- <div class="main_news_post_text_comments">
- Posted by Alex</div>
- <div class="clr"></div>
- </div>
- <div class="main_news_post_text">
- <p>
- <b>Below is the automated list system of all matches. </b>
- <br />
- <?php
- echo "
- Match ID: $id <br />
- Match Date: $date <br />
- Winning Team: $wteam <br />
- Losing Team: $lteam <br />
- Score: $wteam - $win | $lteam - $loss <br />
- ";
- ?> </p>
- </div>
- </div>
- <div class="clr"></div>
- </div>
- </div>
- </div>
- <?php require("includes/sidebar.inc"); ?>
- </div>
- <div class="clr"></div>
- </div>
- <?php require("includes/footer.inc"); ?>
- <div class="clr"></div>
- </div>
- </div>
- </div>
- </div>
- </body>
- </html>
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement