her er koden så. som du kan se prøver jeg at hente Callsign fra "users" tabellen men den returnere bare brugers ID Nummer.
<?
include BASEDIR."admin/incfunctions.php";
$host="********";
$user="********";
$password="********";
$database="********";
//connect and open db
$conn = mysql_connect($host, $user, $password)
or die("Unable to connect to MySQL");
$selecteddb = mysql_select_db($database,$conn)
or die("Could not select database");
//run query
$reports=mysql_query("SELECT `Date`,`player`,`points`,`description` FROM `reports` order by date Desc");
$reportsrowcount=mysql_numrows($reports);
$sql = mysql_query("SELECT `callsign` FROM `users` WHERE ID=$player");
?>
<head>
<meta http-equiv="Content-Language" content="da">
<style type="text/css">
.ms-color1-main {
border: 1.5pt solid teal;
}
.ms-color1-tl {
font-weight: bold;
color: white;
border-style: none;
background-color: black;
}
.ms-color1-top {
font-weight: bold;
color: white;
border-style: none;
background-color: black;
}
.style2 {
text-align: center;
}
.style5 {
border: 1px solid teal;
}
.style6 {
font-weight: bold;
color: white;
border: 1px solid #000000;
background-color: black;
text-align: center;
}
</style>
</head>
<p class="style2">
<img alt="" src="
http://www.silentsharksnavy.com/images/globemaster.jpg" width="340" height="226"></p>
<table style="height: 29px;" class="style5" align="center">
<!-- fpstyle: 8,011111100 -->
<tr>
<td class="style6" style="width: 100px">date</td>
<td class="style6" style="width: 80px">Name</td>
<td class="style6" style="width: 100px">point</td>
<td class="style6" style="width: 180px">description</td>
</tr>
<?
//display all rows of data, formatted to match
$counter=0;
while ($counter < $reportsrowcount)
{
$date = mysql_result($reports,$counter,"date");
$player = mysql_result($reports,$counter,"player");
$points = mysql_result($reports,$counter,"points");
$description = mysql_result($reports,$counter,"description");
echo "<tr>";
echo "<td width='30' class='ms-color1-even'>";
echo "<p align='center'><b>";
echo $date;
echo "</b></td>";
echo "<td width='50' class='ms-color1-even'>";
echo "<p align='center'><b>";
echo $player;
echo "</b></td>";
echo "<td width='50' class='ms-color1-even'>";
echo "<p align='center'><b>";
echo $points;
echo "</b></td>";
echo "<td width='60' class='ms-color1-even'>";
echo "<p align='center'><b>";
echo $description;
echo "</b></td>";
echo "<td class='ms-color1-even'><b>";
echo "</td>";
echo "</tr>";
$counter++;
}
?>
</table>
Håber at kunne få lidt hjælp :)
Ny bruger
Nybegynder
Opret
Preview
