25. november 2002 - 22:07
#4
Her er koden ! jeg er i tvivl omkring denne kodelinie
!
mysql_select_db("nivaaherr")or die(mysql_error());//
<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN">
<?php
mysql_connect("localhost", "username", "password")or die(mysql_error());//her indsætter du de data du har fået oplyst hos din udbyder
mysql_select_db("nivaaherr")or die(mysql_error());//samme her
if($_POST["navn"] && $_POST["email"] && $_POST["medlemsnr"] && $_POST["spisning"] && $_POST["spille"]) {
$navn = $_POST["navn"];
$email = $_POST["email"];
$medlemsnr = $_POST["medlemsnr"];
$spisning = $_POST["spisning"];
$spille = $_POST["spille"];
mysql_query("insert into arrangement (navn, email, medlemsnr, spisning, spille) values ('$navn', '$email', '$medlemsnr', '$spisning', '$spille')");
}
?>
<body background="background.gif">
<p align="center"><b><font size="2" face="Verdana, Arial, Helvetica, sans-serif" color="#FFFFFF">Se
her hvem der har tilmeldt sig</font></b></p>
<table border="1" cellspacing="1" cellpadding="1" align="center">
<tr>
<td><font color="#FFFFFF"><b><font size="2" face="Verdana, Arial, Helvetica, sans-serif">Navn</font></b></font></td>
<td><font color="#FFFFFF"><b><font size="2" face="Verdana, Arial, Helvetica, sans-serif">E-mail</font></b></font></td>
<td><font color="#FFFFFF"><b><font size="2" face="Verdana, Arial, Helvetica, sans-serif">Medlemsnr.</font></b></font></td>
<td><font color="#FFFFFF"><b><font size="2" face="Verdana, Arial, Helvetica, sans-serif">Spisning</font></b></font></td>
<td><font color="#FFFFFF"><b><font size="2" face="Verdana, Arial, Helvetica, sans-serif">Spiller
med</font></b></font></td>
</tr>
<?
$res = mysql_query("select * from arrangement");
while($kommer = mysql_fetch_array($res)) {
echo "<tr>";
echo "<td>$kommer[navn]</td>";
echo "<td><a href='mailto:$kommer[email]'>$kommer[email]</a></td>";
echo "<td>$kommer[medlemsnr]</td>";
echo "<td>$kommer[spisning]</td>";
echo "<td>$kommer[spille]</td>";
echo "</tr>";
}
?>
</table>
<font color="#FFFFFF"><b><font size="2" face="Verdana, Arial, Helvetica, sans-serif"><br>
</font> </b> </font>
<div align="center">
<form method=post action="<? echo $_SERVER["PHP_SELF"];?>">
<table border="0">
<tr>
<td><font color="#FFFFFF"><b><font size="2" face="Verdana, Arial, Helvetica, sans-serif">Navn:</font></b></font></td>
<td><font color="#FFFFFF"><b><font size="2" face="Verdana, Arial, Helvetica, sans-serif">
<input type="text" name="navn">
</font></b></font></td>
</tr>
<tr>
<td><font color="#FFFFFF"><b><font size="2" face="Verdana, Arial, Helvetica, sans-serif">Email:</font></b></font></td>
<td><font color="#FFFFFF"><b><font size="2" face="Verdana, Arial, Helvetica, sans-serif">
<input type="text" name="email">
</font></b></font></td>
</tr>
<tr>
<td><font color="#FFFFFF"><b><font size="2" face="Verdana, Arial, Helvetica, sans-serif">Medlemsnr:</font></b></font></td>
<td><font color="#FFFFFF"><b><font size="2" face="Verdana, Arial, Helvetica, sans-serif">
<input type="text" name="medlemsnr">
</font></b></font></td>
</tr>
<tr>
<td><font color="#FFFFFF"><b><font size="2" face="Verdana, Arial, Helvetica, sans-serif">Spisning</font></b></font></td>
<td><font color="#FFFFFF"><b><font size="2" face="Verdana, Arial, Helvetica, sans-serif">
<select name="spisning">
<option selected>Vil du spise med</option>
<option value="Ja">Ja</option>
<option value="Nej">Nej</option>
</select>
</font></b></font></td>
</tr>
<tr>
<td><font color="#FFFFFF"><b><font size="2" face="Verdana, Arial, Helvetica, sans-serif">Spil</font></b></font></td>
<td><font color="#FFFFFF"><b><font size="2" face="Verdana, Arial, Helvetica, sans-serif">
<select name="spille">
<option>Vil du spille</option>
<option value="Ja">Ja</option>
<option value="Nej">Nej</option>
</select>
</font></b></font></td>
</tr>
<tr>
<td><font color="#FFFFFF"><b><font size="2" face="Verdana, Arial, Helvetica, sans-serif">
<input type="submit" name="s1" value="Tilmeld">
</font></b></font></td>
<td><font color="#FFFFFF"><b><font size="2" face="Verdana, Arial, Helvetica, sans-serif">
<input type="reset" name="r1" value="Ryd form">
</font></b> </font>
</tr>
</table>
</form>
</div>