hjælp med kode, og update.
hejsa, jeg har det her kode. og det kan ikke tjekke om koden er rigtig eller ej , og den kan heller ikke update klan i login4, hvorfor kan den ikke det??<?php
session_start();
?>
<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.01//EN" "http://www.w3.org/TR/html4/strict.dtd">
<html>
<head>
<meta http-equiv="Content-Language" content="da">
<meta http-equiv="Content-Type" content="text/html; charset=windows-1252">
<title>Klaner</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" alt="billede kunne ikke visese"></td>
</tr>
<tr>
<td valign="top" style="background-color=#FFFFFF; background-image:url('bg.jpg');" rowspan="2">
<!-- MSCellType="NavBody" -->
<p align="right">
<img border="0" src="hovedmenu.jpg" width="150" height="30" alt="kunne ikke vises"></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" alt="kunne ikke vises"></td>
<td> </td>
<td valign="top" height="30">
<img border="0" src="sponsorer.jpg" width="154" height="30" alt="kunne ikke vises"></td>
</tr>
<tr>
<td> </td>
<td valign="top" bgcolor="#800080" style="background-image:url('bg.jpg');" rowspan="6" colspan="3">
<!-- MSCellType="ContentBody" -->
<!--webbot bot="HTMLMarkup" startspan -->
<?php
include("sql/db_ind.inc");
if(isset($_POST['submitKode']) && is_numeric($_GET['id']))
{
$kode = htmlentities(strip_tags($_POST['kode']));
$id = intval($_GET['id']);
$brugernavn = $_SESSION[s_navn];
//echo "DEBUG : " . $kode . "<br >";
$query = mysql_query("SELECT * FROM klan WHERE id = '".$id."' AND kode = '".$kode."' LIMIT 1");
if(mysql_num_rows($query)>0)
$r4 = mysql_fetch_assoc($query);
$klan = $r4[navn];
{
$sql = "REPLACE INTO klanmedlemmer (klan,medlem,tilfojet) VALUES ('".$id."','".$_SESSION['s_id']."',NOW())";
mysql_query("UPDATE login4 set klan = '$klan' WHERE brugernavn='$brugernavn'") or die (mysql_error());
mysql_query($sql) or die(mysql_error());
echo "Du er nu tilføjet<br>";
}
}
if(isset($_GET['id']) && is_numeric($_GET['id']))
{
$id = intval($_GET['id']);
$r = array();
$nyhed = mysql_query("SELECT * FROM klan WHERE id = '".$id."' LIMIT 1") or die (mysql_error());
$r = mysql_fetch_assoc($nyhed);
$antal2 = mysql_num_rows($nyhed);
$klanen = $r['navn'];
//Printer valgte nyhed ud
echo "<h1><b>Profil for hold " .$r['navn'];
echo "</b></h1><b>Hold Leader: </b>".$r['Leader'];
echo "<br><b>Hold map: </b>".$r['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 />";
}
}
?><hr>
<form action="<?php echo $SERVER[PHP_SELF]; ?>" method="post">
Hvis du vil meldes ind i denne klan, skal du skrive klanens kode i nedenstående felt, hvis kode er korrekt bliver du tilføjet, hvis ikke skal du prøve igen.<br>
Holdets kode:<input type="text" size="51" name="kode"><br>
<br><input type="submit" name="submitKode" value="Gem Oplysninger">
</form>
<!--webbot bot="HTMLMarkup" endspan --></td>
<td height="284"> </td>
<td valign="top" style="background-image:url('bg.jpg');" rowspan="4">
<a href="pe.php">
<img border="0" src="pe.jpg" alt="billede kunne ikke visese"></a><table border="0" width="100%" id="table9" cellspacing="0" cellpadding="0">
<tr>
<td><a href="tra.php"><img border="0" src="tra.jpg" alt="billede kunne ikke visese"></a></td>
</tr>
</table>
</td>
</tr>
<tr>
<td></td>
<td></td>
<td height="5"></td>
</tr>
<tr>
<td valign="top" style="border-color=#FFFFFF; background-image:url('bg.jpg');" bgcolor="#FFFFFF" rowspan="3">
<!-- MSCellType="NavBody" -->
<img border="0" src="Image17.jpg" width="150" height="30" alt="billede kunne ikke visese"><p>
<!--webbot bot="HTMLMarkup" startspan --><?php
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
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 --></font></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>
