Problem med ansluningen till databasen");
// efter submit
if ($edit_news && $action=="add") {
$sql="insert into news (date, name, header, summary, content) values (\"$date\", \"$name\", \"$header\", \"$summary\", \"$content\")";
$rs=mysql_query($sql, $conn);
}
//om man har valt modify
if($edit_news && $action=="modify") {
$sql ="update news set date=\"$date\" where id=\"$newsid\"\n";
$sql .="update news set name=\"$name\" where id=\"$newsid\"\n";
$sql .="update news set header=\"$header\" where id=\"$newsid\"\n";
$sql .="update news set summary=\"$summary\" where id=\"$newsid\"\n";
$sql .="update news set content=\"$content\" where id=\"$newsid\"\n";
$rs=mysql_query($sql, $conn);
}
if(!$edit_news && $action=="modify") {
$sql="select * from news where id=$newsid";
$rs=mysql_query($sql, $conn);
while($row=mysql_fetch_array($rs)) {
$tmp_date=$row["date"];
$tmp_name=$row["name"];
$tmp_header=$row["header"];
$tmp_summary=$row["summary"];
$tmp_content=$row["content"];
}
}
//om man har valt att ta bort en nyhet
if ($action=="delete") {
$sql="delete from news where id=$newsid";
$rs=mysql_query($sql, $conn);
}
//vilka vill man visa
if($posts_to_show) {
$limit=$posts_to_show;
}
else {
$limit="0,9";
}
//visa de senaste tio (eller vad man kan tänkas välja med min specialfunktion)
$sql="select * from news order by date desc limit $limit";
$rs=mysql_query($sql, $conn);
while($row=mysql_fetch_array($rs)) {
echo("".$row["date"]."
");
echo("
".$row["header"]."
");
echo("
".$row["summary"]."
");
echo("
".$row["content"]."
");
echo("
Ta bort
RedigeraVisa senaste:
1-10
11-20
21-30
31-40
41-50
51-60
61-70
71-80