Hjælp med insert i tabel
hejsa, jeg har det her kode, som jakobdo, har hjulpet mig med.<!DOCTYPE HTML SYSTEM>
<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 id=table6>
<!-- MSTableType="layout" -->
<tr>
<td colspan="7" valign="top" height="150"><p>
<img border="0" src="testlogo.jpg" alt="Billedet er i øjeblikket slettet" width="1062" height="150"></p></td>
</tr>
<tr>
<td valign="top" bgcolor="#FFFFFF" background="bg.jpg" rowspan="2">
<!-- MSCellType="NavBody" -->
<p align="right">
<img border="0" alt="billedet er i øjeblikket slettet" 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" alt="billedet er i øjeblikket slettet" src="dit%20hold.jpg"></td>
<td> </td>
<td valign="top" height="30">
<img border="0" alt="billedet er i øjeblikket slettet" 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" -->
<?
session_start();
include("sql/db_ind.inc");
$navn = $_REQUEST['navn'];
$brugernavn = $_SESSION['s_navn'];
$result = mysql_query("SELECT * FROM klan WHERE navn='$navn'");
if (mysql_num_rows($result) == "1")
{
echo("klannavnet er optaget, vælg venligst et andet.");
}
else
{
if (isset($_POST['navn'])) {
if(empty($navn) || empty($kode) || empty($map)) {
echo "Udfyld venligst alle felterne";
}
else {
$row = mysql_fetch_array($result);
$header = $_POST['header'];
$navn = $_POST['navn'];
$kode = $_POST['kode'];
$map = $_POST['map'];
$tilfojet = date("j/n Y");
$leader = $_GET['leader'];
$klan = $navn;
$mig = $_SESSION[s_navn];
$klanid = mysql_insert_id();
$migid = $_SESSION[s_id];
$sql = "REPLACE INTO klanmedlemmer (klan,medlem,tilfojet) VALUES ('".$klanid."','".$migid."',NOW())";
mysql_query("INSERT INTO klan (navn, kode, map, leader) VALUES ('$navn','$kode','$map','$leader')") or die (mysql_error());
mysql_query($sql) or die(mysql_error());
mysql_query("UPDATE login4 set klan = '$klan' WHERE brugernavn='$brugernavn'") or die (mysql_error());
echo "<script language=javascript>document.URL='minklan.php?id=$migid';</script>";
}
} else {
?>
<form action="opretklan.php?leader=<? echo $_SESSION['s_navn']; ?>" method="post">
<? echo "<h2>Opret hold</h2>" ; ?>
- <b>Hold navn </b><input type="text" size="35" name="navn">Husk ingen mellemrum<br>
- <b>Hold kode </b><input type="password" size="35" name="kode">Skal udfyldes<br>
- <b>Hold map </b><input type="text" size="35" name="map"><br>
- <b>Leader: </b><? echo $_SESSION['s_navn']; ?><br>
<input type="submit" value="opret">
</form>
<?
}
}
?>
<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" bgcolor="#FFFFFF" background="bg.jpg" rowspan="3">
<!-- MSCellType="NavBody" -->
<img border="0" alt="billedet er i øjeblikket slettet" src="Image17.jpg" width="150" height="30"><p>
<!--webbot bot="HTMLMarkup" startspan --><?php
session_start();
?>
<?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>"; ?>
<?
}
?></font><!--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>
Men når jeg så opretter klan får klanen id 0, inde i klanmedlemmer, men ikke de andre steder, og jeg selv "medlem" får også id 0. håber nogle kan hjælpe mig.
