ajax update() i tagwall

<?php

include "top.php";

?>

<div class="headline">Tagwall</div>

<div class="text">

<?php

if (session_is_registered("brugernavn") AND ("kode")) {

if(isset($submit)){

if($_POST[besked] == ""){

echo "Du skal skrive en besked!";

}else{

$dato = date("d/m/y H:i:s");

mysql_query("INSERT INTO tagwall (brugernavn, dato, besked) VALUES ('$_POST[brugernavn]', '$dato', '$_POST[besked]')");

echo "Din besked er nu tilføjet!";

}

}

?>

<?php

if($_GET[side] == "slet_tag"){

mysql_query("DELETE FROM tagwall WHERE id = '$_GET[id]'");

echo 'Beskeden er nu slettet!';

}

$limit = 20;

if (!$_GET[start_nr] OR $_GET[start_nr] < 0) {

$start_nr = 0;

} else {

$start_nr = $_GET[start_nr];

}

?>

<form action="tagwall.php" method="post">

<input type="hidden" name="brugernavn" value="<?php echo $_SESSION['brugernavn']; ?>">

<input type="text" name="besked" class="input">

<input type="submit" name="submit" value="Send" class="submit">

<input type="button" value="Opdatér" onclick="location='tagwall.php'" class="submit">

</form>

<hr style="height: 2px; background-color: #4683A0; border: 0px; margin-top: 0px;"><br><br>

<?php

$db = mysql_query("SELECT * FROM tagwall ORDER BY id DESC");

while($row = mysql_fetch_array($db)){

echo '<b><a href="profil.php?brugernavn=' . $row[brugernavn] . '">' . $row[brugernavn] . '</a> - ' . $row[dato] . '</b> - ';

$select = mysql_query("SELECT * FROM brugere WHERE brugernavn = '$_SESSION[brugernavn]'");

$vis = mysql_fetch_array($select);

if($vis[stilling] == "DJ"){

echo '<a href="?side=slet_tag&id=' .$row[id]. '">Slet tag</a>';

}

echo "<br>";

echo $row[besked] . '<hr>';

}

$count = mysql_query("select * from tagwall");

$antal = mysql_num_rows($count);

if ($start_nr > 0 && ($start_nr - $limit) < $antal) {

$forrige_start_nr = $start_nr - $limit;

echo "<div align='center'><- <a href='?start_nr=$forrige_start_nr'>Forrige side</a>";

} else {

echo "<div align='center'>Forrige side ";

}echo " | ";

$antalsider = $antal / $limit;

$aktueltsidenummer = ($_GET[start_nr] / $limit) + 1;

$a_a = $aktueltsidenummer - 5;

$a_b = $aktueltsidenummer - 4;

$a_c = $aktueltsidenummer - 3;

$a_d = $aktueltsidenummer - 2;

$a_e = $aktueltsidenummer - 1;

$a_f = $aktueltsidenummer + 1;

$a_g = $aktueltsidenummer + 2;

$a_h = $aktueltsidenummer + 3;

$a_i = $aktueltsidenummer + 4;

$a_j = $aktueltsidenummer + 5;

$naestesidea = $_GET[start_nr] - (5 * $limit);

$naestesideb = $_GET[start_nr] - (4 * $limit);

$naestesidec = $_GET[start_nr] - (3 * $limit);

$naestesided = $_GET[start_nr] - (2 * $limit);

$naestesidee = $_GET[start_nr] - (1 * $limit);

$naestesidef = $_GET[start_nr] + (1 * $limit);

$naestesideg = $_GET[start_nr] + (2 * $limit);

$naestesideh = $_GET[start_nr] + (3 * $limit);

$naestesidei = $_GET[start_nr] + (4 * $limit);

$naestesidej = $_GET[start_nr] + (5 * $limit);

if($a_a > 0) { echo "<a href='?start_nr=".$naestesidea."'>".$a_a."</a>, "; }

if($a_b > 0) { echo "<a href='?start_nr=".$naestesideb."'>".$a_b."</a>, "; }

if($a_c > 0) { echo "<a href='?start_nr=".$naestesidec."'>".$a_c."</a>, "; }

if($a_d > 0) { echo "<a href='?start_nr=".$naestesided."'>".$a_d."</a>, "; }

if($a_e > 0) { echo "<a href='?start_nr=".$naestesidee."'>".$a_e."</a>, "; }

if($aktueltsidenummer > 0) { echo "<a href='?start_nr=".$_GET[start_nr]."'><b>".$aktueltsidenummer."</b></a>"; } if(($aktueltsidenummer + 0) < $antalsider) { echo', '; }

if($a_f > 0 AND $a_f < ($antalsider + 1)) { echo "<a href='?start_nr=".$naestesidef."'>".$a_f."</a>"; } if(($a_f + 0) < $antalsider) { echo', '; }

if($a_g > 0 AND $a_g < ($antalsider + 1)) { echo "<a href='?start_nr=".$naestesideg."'>".$a_g."</a>"; } if(($a_g + 0) < $antalsider) { echo', '; }

if($a_h > 0 AND $a_h < ($antalsider + 1)) { echo "<a href='?start_nr=".$naestesideh."'>".$a_h."</a>"; } if(($a_h + 0) < $antalsider) { echo', '; }

if($a_i > 0 AND $a_i < ($antalsider + 1)) { echo "<a href='?start_nr=".$naestesidei."'>".$a_i."</a>"; } if(($a_i + 0) < $antalsider) { echo', '; }

if($a_j > 0 AND $a_j < ($antalsider + 1)) { echo "<a href='?start_nr=".$naestesidej."'>".$a_j."</a>"; }

echo " | ";

if ($antal > ($start_nr + $limit)) {

$naeste_start_nr = $start_nr + $limit;

echo "<a href='?start_nr=$naeste_start_nr'>Næste side</a>";

} else {

echo "Næste side";

}

echo "</div>";

}else{

echo "Du er ikke logget ind!";

}

include "bund.php";

?>