Det enda som hände var att den skrev ut
Före if
Efter if
Längs upp
Jag kanske har lagt den galet
Jag har iof testat att flytta min if-sats men, det gillade den inte
<?php
include "conn.php";
if(isset($_POST['spara'])) { // om knappens namn är spara
$sql = "
UPDATE eva_spelningar
SET tony = '1',
ulf = '1',
carina = '1',
anders = '1',
magnus = '1'
WHERE id = {$_POST['id']}
";
echo($sql);
exit;
mysql_query($sql) or die(mysql_error());
header("Location: form.php?id=".$_POST['id']);
exit;
}
?>
<!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" dir="ltr" lang="sv">
<head>
<meta http-equiv="Content-Type" content="text/html; charset=iso-8859-1"/>
<title>Eva Evenemang</title>
<style type="text/css">
<!--
body {
font-family: Arial;
font-size: 11px;
background: #FFFFFF;
fontcolor="#003366"
}
a {text-decoration: none}
.intro {
color: red;
}
form {
width: 50%;
align: center;
background: #F5F5F5;
border: 1px solid #E4E4E4;
}
#form {
width: 50%;
align: center;
background: #F5F5F5;
border: 1px solid #E4E4E4;
padding: 5px;
}
.padding {
padding: 5px;
}
table.gridtable {
font-family: verdana,arial,sans-serif;
font-size:11px;
color:#333333;
border-width: 0px;
border-color: #666666;
border-collapse: collapse;
width: 180%;
}
table.gridtable th {
border-width: 0px;
text-align:left;
padding: 4px;
border-style: solid;
border-color: #666666;
background-color: #dedede;
}
table.gridtable td {
border-width: 0px;
padding: 4px;
border-style: solid;
border-color: #666666;
background-color: #ffffff;
}
table.gridtable tr {
border-width: 0px;
padding: 4px;
border-style: solid;
border-color: #666666;
background-color: #d4e3e5;
}
.datum {
width: 80px;
}
.tid {
width: 10px;
}
.plats {
width: 400px;
}
.namn {
width: 90px;
}
img { border: 0px; }
.red { color: #ff0000;"}
-->
</style>
</head>
<body>
<div id="form">
<form id="form1" method="post" action="write.php" enctype="multipart/form-data" class="padding">
<input type="hidden" name="MAX_FILE_SIZE" value="3000" />
<fieldset>
<label>Tid <span class="red">(ex. 13:00)</span><br />
<input type="text" name="tid" style="width: 160px;" /></label><br />
<label>Datum <span class="red">(Y-M-D)</span>:<br />
<input type="text" name="datum" style="width: 160px;" /></label><br />
<label>Var:<br />
<input type="text" name="plats" style="width: 160px;" /></label><br />
<label>Detaljerad beskrivning:<br />
<textarea name="beskrivning" cols="35" rows="6"></textarea></label><br />
<br />
<input type="file" name="karta" /> <input type="submit" name="klar" value="Skicka" />
</fieldset>
</form>
</div>
<h2>Alla evenemang</h2>
<?php
$sql = mysql_query("SELECT * FROM eva_spelningar ORDER BY id DESC");
if (mysql_num_rows($sql) == 0) {
echo "För tillfället finns inga evenemang";
}
while ($rad = mysql_fetch_array($sql)) {
$id = $rad['id'];
$tid = $rad['tid'];
$datum = $rad['datum'];
$plats = $rad['plats'];
echo("<form method=\"post\" action=\"{$_SERVER['PHP_SELF']}\">");
echo("<input type=\"hidden\" name=\"id\" value=\"{$rad['id']}\" />");
echo('<table class="gridtable">');
echo("<tr>");
echo('<th class="datum">Datum</th>');
echo('<th class="tid">Tid</th>');
echo('<th class="plats">Plats</th>');
echo('<th class="namn">Tony</th>');
echo('<th class="namn">Ulf</th>');
echo('<th class="namn">Carina</th>');
echo('<th class="namn">Anders</th>');
echo('<th class="namn">Magnus</th>');
echo("<td><a href=\"delete.php?id={$rad['id']}\" onclick=\"javascript:return confirm('Säkert att du vill radera ?');\"><img src=\"delete.gif\" alt=\"Image\" /></a></td>");
echo("<td> </td>");
echo("<td><a href=\"beskrivning.php?id={$rad['id']}\">Läs mer!</a></td>");
echo("</tr>");
echo("<tr>");
echo("<td>");
echo($rad["datum"]);
echo("</td>");
echo("<td>");
echo($rad["tid"]);
echo("</td>");
echo("<td>");
echo($rad["plats"]);
echo("</td>");
echo('<td> <input type="checkbox" name="tony" value="tony" /> </td>');
echo('<td> <input type="checkbox" name="ulf" value="ulf" /> </td>');
echo('<td> <input type="checkbox" name="carina" value="carina" /> </td>');
echo('<td> <input type="checkbox" name="anders" value="anders" /> </td>');
echo('<td> <input type="checkbox" name="magnus" value="magnus" /> </td>');
echo('<td> <input type="submit" value="Spara" name="Spara" /> </td>');
echo("</tr>");
echo("</table>");
echo('</form>');
}
?>
</body>
</html>
