læs fra databasen.
hejsa jeg har fået en masse hjælp fra jakobdo til at lave det her, men jeg kan ikke lige få den til og vise medlemmer, nogle som kan se hvad fejlen er? :<html>
<head>
<meta http-equiv="Content-Language" content="da">
<meta http-equiv="Content-Type" content="text/html; charset=windows-1252">
<title>Ny side 1</title>
</head>
<body bgcolor="#000000" link="#FFFFFF" vlink="#FFFFFF" alink="#FFFFFF" text="#FFFFFF">
<p>
</p>
<table border="0" cellpadding="0" cellspacing="0" width="1062" height="927" id="table6">
<!-- MSTableType="layout" -->
<tr>
<td colspan="7" valign="top" height="150">
<img border="0" src="testlogo.jpg" width="1062" height="150"></td>
</tr>
<tr>
<td valign="top" bordercolor="#FFFFFF" bgcolor="#FFFFFF" background="bg.jpg" rowspan="2">
<!-- MSCellType="NavBody" -->
<p align="right">
<img border="0" src="hovedmenu.jpg" width="150" height="30"></p>
<table border="0" width="100%" id="table7" cellspacing="0" cellpadding="0">
<tr>
<td><font color="#FFFFFF" face="Tahoma" size="2">
<a href="index.php"><span style="text-decoration: none">Forside</span></a></font></td>
</tr>
<tr>
<td><font color="#FFFFFF" face="Tahoma" size="2">
<a href="historie.php"><span style="text-decoration: none">
Historie</span></a></font></td>
</tr>
<tr>
<td><font color="#FFFFFF" face="Tahoma" size="2">
<a href="information.php"><span style="text-decoration: none">
Information</span></a></font></td>
</tr>
<tr>
<td><font color="#FFFFFF" face="Tahoma" size="2">
<a href="tilmelding.php"><span style="text-decoration: none">
Tilmelding</span></a></font></td>
</tr>
<tr>
<td><font color="#FFFFFF" face="Tahoma" size="2">
<a href="regler.php"><span style="text-decoration: none">Regler</span></a></font></td>
</tr>
<tr>
<td><font color="#FFFFFF" face="Tahoma" size="2">
<a href="kontakt.php"><span style="text-decoration: none">
Kontakt</span></a></font></td>
</tr>
</table>
<p align="right"> </td>
<td> </td>
<td valign="top" colspan="3">
<!-- MSCellType="ContentBody" -->
<img border="0" src="dit%20hold.jpg"></td>
<td> </td>
<td valign="top" height="30">
<img border="0" src="sponsorer.jpg" width="154" height="30"></td>
</tr>
<tr>
<td> </td>
<td valign="top" bgcolor="#800080" background="bg.jpg" rowspan="6" colspan="3">
<!-- MSCellType="ContentBody" -->
<!--webbot bot="HTMLMarkup" startspan --><?php
session_start();
if (isset($_SESSION["s_navn"]))
{
$id = intval($_GET['id']);
include("sql/db_ind.inc");
if (isset($_GET['mode']) && $_GET['mode'] == "ret") {
$brugernavn = $_POST['fornavn'];
$alder = $_POST['alder'];
$password = $_POST['password'];
$scooter = $_POST['scooter'];
$opsætning = $_POST['opsætning'];
mysql_query ("UPDATE login4 SET alder ='$brugernavn', emne = '$alder' , land ='$land' , password ='$password' WHERE id='$id'");
echo "<script language=javascript>document.URL='minprofil.php?id=$_SESSION[s_id]';</script>";
} else {
$nyhed = mysql_query("SELECT klan FROM login4 WHERE id = '$id'");
$r = mysql_fetch_array($nyhed);
$klannavn = $r['klan'];
$nyhed2 = mysql_query("SELECT * FROM klan WHERE navn = '$klannavn'");
if (mysql_num_rows($nyhed2) != 0) {
$row = mysql_fetch_array($nyhed2);
echo "<h2>Information for $klannavn</h2>";
echo "<b>Hold leder:</b>"." $row[Leader]";
echo "<br><b>Hold kode:</b>"." $row[kode]";
echo "<br><b>Hold id:</b>"." $row[id]";
echo "<br><b>Hold map:</b>"." $row[map]";
echo "<br><b>Medlemmer:</b><br>";
$nyhed3 = mysql_query("SELECT l.brugernavn FROM login4 AS l INNER JOIN klanmedlemmer AS k ON l.id = k.medlem WHERE k.klan = '".$id."'") or die (mysql_error());
while ($r2 = mysql_fetch_array($nyhed3))
{
echo $r2['brugernavn'] . "<br />";
}
}
else {
echo "Du er ikke tilmeldt nogen klan, hvad vil du?";
echo "<br><a href=opretklan.php?id=$id>(Opret klan)</a>";
echo "<br><a href=klanliste.php>(Find klan)</a>";
}
?>
<!--webbot bot="HTMLMarkup" endspan --></td>
<td height="284"> </td>
<td valign="top" background="bg.jpg" rowspan="4">
<a href="pe.php">
<img border="0" src="pe.jpg"></a><table border="0" width="100%" id="table9" cellspacing="0" cellpadding="0">
<tr>
<td><a href="tra.php"><img border="0" src="tra.jpg"></a></td>
</tr>
</table>
</td>
</tr>
<tr>
<td></td>
<td></td>
<td height="5"></td>
</tr>
<tr>
<td valign="top" bordercolor="#FFFFFF" bgcolor="#FFFFFF" background="bg.jpg" rowspan="3">
<!-- MSCellType="NavBody" -->
<img border="0" src="Image17.jpg" width="150" height="30"><p>
<!--webbot bot="HTMLMarkup" startspan --><?php
session_start();
?>
<html>
<head>
</head>
<body bgcolor="#EFEDED">
<?php
session_start();
if (isset($_SESSION["s_navn"]))
{
$id = $_SESSION[s_id];
?>
<? echo "<a href='minprofil.php?id=$id'><span style='text-decoration: none'>Min Profil</span></a>
<br><a href='mineoplysninger.php?id=$id'><span style='text-decoration: none'>Mine Oplysninger</span></a>
<br><a href='minklan.php?id=$id'><span style='text-decoration: none'>Mit Hold</span></a>
<br><a href='index.php'><span style='text-decoration: none'>Logud</span></a>"; ?>
<?
}
?>
<font size="2" face="Tahoma"><?php
session_start();
if (isset($_SESSION['s_rang']) && $_SESSION['s_rang'] == "admin")
{
?>
<? echo "<br><br><a href='add_news.php'><span style='text-decoration: none'>Tilføj nyhed</span></a>"; ?>
<? echo "<br><a href='del_news.php'><span style='text-decoration: none'>Slet nyhed</span></a>"; ?>
<?
}
}
}
?><!--webbot bot="HTMLMarkup" endspan --></td>
<td> </td>
<td height="30"> </td>
</tr>
<tr>
<td> </td>
<td height="144"> </td>
</tr>
<tr>
<td></td>
<td></td>
<td height="5"></td>
</tr>
<tr>
<td> </td>
<td> </td>
<td> </td>
<td height="156"> </td>
</tr>
<tr>
<td width="150"> </td>
<td width="9"> </td>
<td width="368"> </td>
<td width="13"> </td>
<td width="358"> </td>
<td width="10"> </td>
<td height="123" width="154"> </td>
</tr>
</table>
</body>
</html>
