<?php
$loc="localhost";
$username="sj";
$password="";
$database="sj_xbl";
$link = mysql_connect($loc,$username,$password);
mysql_select_db($database) or die( "Unable to select database");

$id = mysql_real_escape_string($id);

$query = "SELECT * FROM matches LIMIT 4";
$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();

echo "
                                <li>
                                    <div class=\"lm_box_date\">
                                    $date
                                  </div>
                                    <div class=\"lm_box_team\">
                                        <a href=\"matches.php?id=$id\">$wteam vs $lteam</a>
                                    </div>
                                    <div class=\"lm_box_results\">
                                        <span class=\"win\">$win</span> - <span class=\"loss\">$loss</span>
                                    </div>
                                    <div class=\"right_col_box_devider\"></div>
                                </li>
                            ";


?>