problem med INSERT INTO
Hej jeg har et problem når jeg vil indsætte noget i MySQL... Den indsætter nemlig 2 af det sammeHer er noget kode:
-------------------------------
//----------------------------------------------------------------------------------------------------------------------
// SQL: Tilføj
//----------------------------------------------------------------------------------------------------------------------
if ($action == 'add')
{
if ($grupper == 1)
{
$gruppe = $gruppe1;
}
elseif ($grupper == 2)
{
$gruppe = $gruppe2;
}
mysql_query("INSERT INTO `$session_logon` SET navn='$navn', gruppe='$gruppe', alias='$alias', tlf='$tlf', mobil='$mobil', adresse='$adresse', postnr='$postnr', sted='$sted', email='$email', icq='$icq'");
header('location: adressebog.php');
}
//----------------------------------------------------------------------------------------------------------------------
require('req/top.req');
?>
<script language="javascript">
function valg(i)
{
if (i == 1)
{
liste.grupper[0].checked = true;
}
else
{
liste.grupper[1].checked = true;
}
}
</script>
<form name="liste" method="post" action="add.php">
<input type="hidden" name="action" value="add">
<div align="center">
<table cellpadding="0" cellspacing="2">
<tr class="celle">
<td align="center">Navn</td>
<td align="center">Gruppe</td>
<td align="center">Alias</td>
<td align="center">Tlf</td>
<td align="center">Mobil</td>
<td align="center">Adresse</td>
<td align="center">Postnr</td>
<td align="center">By</td>
<td align="center">E-mail</td>
<td align="center">ICQ</td>
</tr>
<tr class="celle">
<td class="list_blue"><input type="text" name="navn" maxlength="<? echo $record_navn; ?>" size="10"></td>
<td class="list_blue"><input class="none" checked type="radio" name="grupper"> <select size="1" name="gruppe1" onClick="valg(1);">
<?
$get = mysql_query("SELECT gruppe FROM `$session_logon` GROUP BY gruppe");
while ($grupper = mysql_fetch_row($get))
{
echo '<option>'.ucfirst($grupper[0]).'</option>';
}
?>
</select><br>
<input class="none" type="radio" name="grupper"> <input type="text" name="gruppe2" maxlength="<? echo $record_gruppe; ?>" size="10" onClick="valg(2);"></td>
<td class="list_blue"><input type="text" name="alias" maxlength="<? echo $record_alias; ?>" size="10"></td>
<td class="list_blue"><input type="text" name="tlf" maxlength="<? echo $record_tlf; ?>" size="7"></td>
<td class="list_blue"><input type="text" name="mobil" maxlength="<? echo $record_mobil; ?>" size="7"></td>
<td class="list_blue"><input type="text" name="adresse" maxlength="<? echo $record_adresse; ?>" size="10"></td>
<td class="list_blue"><input type="text" name="postnr" maxlength="<? echo $record_postnr; ?>" size="2"></td>
<td class="list_blue"><input type="text" name="sted" maxlength="<? echo $record_sted; ?>" size="10"></td>
<td class="list_blue"><input type="text" name="email" maxlength="<? echo $record_email; ?>" size="10"></td>
<td class="list_blue"><input type="text" name="icq" maxlength="<? echo $record_icq; ?>" size="9"></td>
</tr>
<tr>
<td colspan="<? if ($edit == 'ret') echo 9; else echo 10; ?>" align="right"><input type="image" src="img/button_add.gif" onClick="document.liste.submit();"></td>
</tr>
</table>
</div>
</form>
