Kan ikke vise siden. Bare helt hvid skærm
Hej...Jeg har skrevet denne side, men når jeg åbner den kommer der bare en hvis skærm... Alt hvad jeg skriver bliver væk...
Håber nogen af jer kan se en fejl....
Alle de andre sider på min server køre fint..
Her er koden:
<?php require_once('../Connections/db.php'); ?>
<?php
function GetSQLValueString($theValue, $theType, $theDefinedValue = "", $theNotDefinedValue = "")
{
$theValue = (!get_magic_quotes_gpc()) ? addslashes($theValue) : $theValue;
switch ($theType) {
case "text":
$theValue = ($theValue != "") ? "'" . $theValue . "'" : "NULL";
break;
case "long":
case "int":
$theValue = ($theValue != "") ? intval($theValue) : "NULL";
break;
case "double":
$theValue = ($theValue != "") ? "'" . doubleval($theValue) . "'" : "NULL";
break;
case "date":
$theValue = ($theValue != "") ? "'" . $theValue . "'" : "NULL";
break;
case "defined":
$theValue = ($theValue != "") ? $theDefinedValue : $theNotDefinedValue;
break;
}
return $theValue;
}
$editFormAction = $_SERVER['PHP_SELF'];
if (isset($_SERVER['QUERY_STRING'])) {
$editFormAction .= "?" . htmlentities($_SERVER['QUERY_STRING']);
}
if ((isset($_POST["MM_update"])) && ($_POST["MM_update"] == "form1")) {
$updateSQL = sprintf("UPDATE personale SET Navn=%s, Alder=%s, Nationalitet=%s, Klub=%s, Job=%s WHERE ID=%s",
GetSQLValueString($_POST['Navn'], "text"),
GetSQLValueString($_POST['Alder'], "int"),
GetSQLValueString($_POST['Nationalitet'], "text"),
GetSQLValueString($_POST['Klub'], "text"),
GetSQLValueString($_POST['Job'], "text"),
GetSQLValueString($_POST['ID'], "int"));
mysql_select_db($database_db, $db);
$Result1 = mysql_query($updateSQL, $db) or die(mysql_error());
$updateGoTo = "personalesogret.php";
if (isset($_SERVER['QUERY_STRING'])) {
$updateGoTo .= (strpos($updateGoTo, '?')) ? "&" : "?";
$updateGoTo .= $_SERVER['QUERY_STRING'];
}
header(sprintf("Location: %s", $updateGoTo));
}
mysql_select_db($database_db, $db);
$query_personale = "SELECT * FROM personale";
$personale = mysql_query($query_personale, $db) or die(mysql_error());
$row_personale = mysql_fetch_assoc($personale);
$totalRows_personale = mysql_num_rows($personale);
mysql_select_db($database_db, $db);
$query_job = "SELECT * FROM job ORDER BY ID ASC";
$job = mysql_query($query_job, $db) or die(mysql_error());
$row_job = mysql_fetch_assoc($job);
$totalRows_job = mysql_num_rows($job);
mysql_select_db($database_db, $db);
$query_kommentar = "SELECT * FROM kommentarpersonale WHERE personalenr = $_GET['ID'] ORDER BY tid DESC";
$kommentar = mysql_query($query_kommentar, $db) or die(mysql_error());
$row_kommentar = mysql_fetch_assoc($kommentar);
$totalRows_kommentar = mysql_num_rows($kommentar);
?>
<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN" "http://www.w3.org/TR/html4/loose.dtd">
<html>
<head>
<title>Personale Ret</title>
<meta http-equiv="Content-Type" content="text/html; charset=iso-8859-1">
<style type="text/css">
<!--
.style1 {font-size: 20px}
-->
</style>
</head>
<body>
adfljhfjalfjhaljkf
<h1 align="center" class="style1">Ret Personale</h1>
<form method="post" name="form1" action="<?php echo $editFormAction; ?>">
<table align="center">
<tr valign="baseline">
<td nowrap align="right">Navn:</td>
<td><input type="text" name="Navn" value="<?php echo $row_personale['Navn']; ?>" size="32"></td>
</tr>
<tr valign="baseline">
<td nowrap align="right">Alder:</td>
<td><input type="text" name="Alder" value="<?php echo $row_personale['Alder']; ?>" size="32"></td>
</tr>
<tr valign="baseline">
<td nowrap align="right">Nationalitet:</td>
<td><input type="text" name="Nationalitet" value="<?php echo $row_personale['Nationalitet']; ?>" size="32"></td>
</tr>
<tr valign="baseline">
<td nowrap align="right">Klub:</td>
<td><input type="text" name="Klub" value="<?php echo $row_personale['Klub']; ?>" size="32"></td>
</tr>
<tr valign="baseline">
<td nowrap align="right">Job:</td>
<td>
<select name="Job">
<?php
do {
?>
<option value="<?php echo $row_job['job']?>" <?php if (!(strcmp($row_job['job'], "$row_personale['Job']"))) {echo "SELECTED";} ?>><?php echo $row_job['job']?></option>
<?php
} while ($row_job = mysql_fetch_assoc($job));
?>
</select>
</td>
<tr>
<tr valign="baseline">
<td nowrap align="right"> </td>
<td><input type="submit" value="Ret"></td>
</tr>
</table>
<input type="hidden" name="MM_update" value="form1">
<input type="hidden" name="ID" value="<?php echo $row_personale['ID']; ?>">
</form>
<p> </p>
<p align="center"> </p>
</body>
</html>
<?php
mysql_free_result($personale);
mysql_free_result($job);
mysql_free_result($kommentar);
?>
