Hey det meget, coolt.. men der er et problem den vil ikke komme med den alert.
Her er min fulde kode lige pt.
<?php
mysql_connect("localhost","root","")or die(myqsl_error());
mysql_select_db("signupsystem");
if(!isset($_SESSION)){
session_start();
}
$urlId = $_REQUEST['id'];
$userSession = $_SESSION['MM_brugernavn'];
$sqlQuery = mysql_query("SELECT * FROM `users` WHERE b_navn='$userSession'")or die(mysql_error());
while($showQuery = mysql_fetch_assoc($sqlQuery)){
$getUserId = $showQuery['nick'];
$getNick = $showQuery['class'];
$getUser = $showQuery['id'];
$getLevel = $showQuery['level'];
$getRace = $showQuery['race'];
$actionSign = $_SERVER['PHP_SELF']."?id=$urlId";
$signstatus = $_POST['signstatus'];
$selectSql = mysql_query("SELECT * FROM `raidmemebers` WHERE raidnr='$urlId'")or die(mysql_error());
$rowSql = mysql_fetch_assoc($selectSql);
$query = mysql_query("SELECT * FROM raidmemebers WHERE raidnr='$urlId' AND brugerid='$getUser'")or die(mysql_error());
$QueryNum = mysql_num_rows($query);
if($QueryNum >= 1){
$error .= "Der er allerede oprette, en i dette raid med dette brugerId";
}
if($error){
echo "".$error;
}
elseif((isset($_GET['action']) == "sign")){
mysql_query("INSERT INTO `raidmemebers` (`brugerid`,`nick`,`class`,`raidnr`,`signstatus`,`level`,`race`) VALUES ('$getUser','$getUserId','$getNick','$urlId','$signstatus','$getLevel','$getRace')")or die(mysql_error());
}}
$getSign = mysql_query("SELECT * FROM `raidmemebers` WHERE raidnr='$urlId'")or die(mysql_error());
while($visSign = mysql_fetch_assoc($getSign)){
?>
<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "
http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd"><html xmlns="
http://www.w3.org/1999/xhtml"><head>
<meta http-equiv="Content-Type" content="text/html; charset=utf-8" />
<title>Showsigns</title>
<link rel="stylesheet" type="text/css" href="style.css">
</head>
<body>
<script language="text/javascript">
if(document.getelementbyid('optionalert').value == 0)
alert('Vælg gyldig option');
document.getelementbyid('optionalert').focus();
</script>
<form method="post" action="<?php echo $actionSign;?>&action=sign">
<select name="signstatus" onsubmit="return valider(this)">
<option value="0">---SELECT ONE---</option>
<option value="1">--Sign--</option>
<option value="2">--Sign Off--</option>
</select>
<input type="submit" value="Sign">
<script language="text/javascript">
function valider(f) {
if(f.signstatus.value == "0") {
alert("Vælg en gyldig option");
return false;
}
return true;
}
</script>
</form>
<table>
<tr class="head">
<td width="10%"><strong>Nr:</strong></td>
<td width="20%"><strong>Name:</strong></td>
<td width="15%"><strong>Class:</strong></td>
<td width="15%"><strong>Race:</strong></td>
<td width="10%"><strong>Level:</strong></td>
<td width="10%"><strong>Signstatus:</strong></td>
</tr>
<?php do { ?>
<tr>
<td><?php echo $visSign['id']; ?></td>
<td><?php echo $visSign['nick']; ?> </td>
<td><?php echo $visSign['class']; ?></td>
<td><?php echo $visSign['race']; ?></td>
<td><?php echo $visSign['level']; ?></td>
<td><?php if($visSign['signstatus'] == 1){ echo "Signed"; }
if($visSign['signstatus'] == 2){ echo "Signed off"; }?></td>
<td></td>
</tr>
<?php
} while($visSign = mysql_fetch_assoc($getSign));
exit;
}
?>
</table>
</div>
</body>
</html>
