<?PHP
	require_once('db.php');

	if($_POST[action] == "save")
	{
		if($_POST[id] != "")
		{
			$query = "update newsletters set title='$_POST[title]', headline='$_POST[headline]', ingress='$_POST[ingress]', body='$_POST[message_body]' where id='$_POST[id]'";
		}
		else
		{
			$query = "insert into newsletters values('','$_POST[title]','$_POST[date]','$_POST[headline]','$_POST[ingress]','$_POST[message_body]')";
		}
		mysql_query($query);
	}
	elseif($_POST[action] == "edit")
	{
		$date = $_POST[date];
		$title = $_POST[title];
		$ingress = $_POST[ingress];
		$headline = $_POST[headline];
		$message_body = $_POST[message_body];
	}
	elseif($_GET[action] == "edit" && $_GET[id] != "")
	{
		$query = "select * from newsletters where id='$_GET[id]'";
		$result = mysql_query($query);
		$line = mysql_fetch_array($result);
		$id = $line[id];
		$title = $line[title];
		$ingress = $line[ingress];
		$headline = $line[headline];
		$message_body = $line[body];
	}
	elseif($_GET[action] == "delete" && $_GET[id] != "")
	{
		$query = "delete from newsletters where id='$_GET[id]'";
		mysql_query($query);
	}
PHP?>

<html>
<head>
<title>Kontiki nyhetsbrev</title>
</head>

<body>

<form action="mall.php" method="post">
<input type="hidden" name="date" value="<?PHP echo $date; PHP?>">
<input type="hidden" name="id" value="<?PHP echo $id; PHP?>">
<table border=0 cellpadding=0 cellspacing=0>
<tr>
<td width=100>Titel:</td>
<td><input type="text" name="title" value="<?PHP echo $title; PHP?>" style="width:425px;"></td>
</tr>
<tr>
<td width=100>Rubrik:</td>
<td><input type="text" name="headline" value="<?PHP echo $headline; PHP?>" style="width:425px;"></td>
</tr>
<tr>
<td width=100>Ingress:</td>
<td><textarea name="ingress" rows=10 cols=50><?PHP echo $ingress; PHP?></textarea></td>
</tr>
<tr>
<td width=100>Text:</td>
<td><textarea name="message_body" rows=20 cols=50><?PHP echo $message_body; PHP?></textarea></td>
</tr>
<tr>
<td colspan=2><input type="submit" value="preview"></td>
</tr>
</table>
</form>

<table border=0 cellpadding=0 cellspacing=0 width=600>
<tr>
<td colspan=3><b><center>Gamla nyhetsbrev:</center></b></td>
</tr>
<?PHP
	$query = "select id, date, title from newsletters";
	$result = mysql_query($query);
	while($line = mysql_fetch_array($result))
	{
		echo "<tr>\n<td>$line[date] - $line[title]</td>\n";
		echo "<td><a href=\"mall.php?id=$line[id]\">visa nyhetsbrevet</a></td>\n";
		echo "<td><a href=\"$_SERVER[PHP_SELF]?action=edit&id=$line[id]\">edit</a> <a href=\"$_SERVER[PHP_SELF]?action=delete&id=$line[id]\">delete</a></td>\n</tr>";
	}
PHP?>
</table>

</body>
</html>
