Prøv med:
if( $navn && $tag )
{
$qry_check = "SELECT `tag` FROM databasenavn WHERE `navn`='$navn'";
$chkres = mysql_query($qry_check);
if(1 == mysql_num_rows($chkres))
{
$reschk = mysql_fetch_row($chkres);
if($tag == $reschk)
{
echo "Du er allerede tilmeldt!";
} else {
$tid = date("d/m Y - H:i");
$navn = addslashes($navn);
$tag = addslashes($tag);
$email = addslashes($email);
$query = "
INSERT INTO
texas_scramble_match
(
navn,
tag,
email,
ip,
dato
)
VALUES
(
'$navn',
'$tag',
'$email',
'$REMOTE_ADDR',
'$tid'
)
";
mysql_query($query);
}
?>
<form method=post>
<table border=0 cellspacing=0 cellpadding=0>
<tr>
<td width=50><b>Navn :</td>
<td><input type=text size=30 name=navn></td>
</tr>
<tr>
<td width=72><b>Medlems nr. : </td>
<td><input type=text size=10 name=email></td>
</tr>
<tr>
<td width=50><b>Spisning :</td>
<td><select size=1 name=tag>
<option value=Ja>Ja</option>
<option value=Nej>Nej</option>
</select>
</td>
</tr>
<tr>
<td width=50><b> </td>
<td><INPUT NAME="name" TYPE="image" SRC="billeder/golf_ball8.jpg" VALUE="Send">
</td>
</tr>
</table>
<br>
</form>
<br>
Der er<b>
<?
$result = mysql_result(mysql_query("SELECT Count(id) FROM databasenavn"),0);
echo $result;
?>
</b> tilmeldt matchen til d. 27. Maj 2004
<br><br>
<table width=432 border=0 CELLSPACING=0 bgcolor=black style="border-bottom : #000000 1px solid;">
<tr>
<td bgcolor=white width=232><b> Navn</td>
<td align=right bgcolor=white width=50><b>Medlem</td>
<td align=center bgcolor=white width=50><b>Spisning</td>
</tr>
</table>
<table width=432 border=0 CELLSPACING=0 bgcolor=black>
<?
$result = mysql_query("select * from databasenavn order by id asc");
while($row = mysql_fetch_array($result))
{
$email = $row[email];
$navn = $row[navn];
$tag = $row[tag];
$dato = $row[dato];
$tag = stripslashes($tag);
$navn = stripslashes($navn);
$tag = htmlentities($tag);
$navn = htmlentities($navn);
$email = htmlentities($email);
echo "<tr>";
echo "<td bgcolor=\"white\">";
echo "</td>";
echo "</tr>";
echo "</table>";
echo "<table width=\"432\" border=\"0\" CELLSPACING=\"0\" bgcolor=\"black\" style=\"border-bottom : #8DA7D6 1px solid;\">";
echo "<tr>";
echo "<td bgcolor=\"white\" width=\"232\">";
echo "<b> $navn</b></a>";
echo "</td>";
echo "<td ALIGN=\"right\" bgcolor=\"white\" width=\"50\">";
echo "<b>$email </b>";
echo "</td>";
echo "<td ALIGN=\"center\" bgcolor=\"white\" width=\"50\">";
echo "<b>$tag</b>";
echo "</td>";
echo "</tr>";
echo "</table>";
echo "<table width=\"432\" border=\"0\" CELLSPACING=\"0\" bgcolor=\"black\">";
echo "<tr>";
echo "<td bgcolor=\"white\" align=\"right\">";
echo "</td>";
echo "</tr>";
}
?>
</table>
<?
}
mysql_close();
?>
Ny bruger
Nybegynder
Opret
Preview
