Altså dette er hele min side nu:
<?php
require "db.php";
$alle = mysql_result(mysql_query("SELECT COUNT(*) FROM bixen_vrag_msg WHERE replyto='$id'"),0) or die(mysql_error());
$antal = mysql_result($alle, 0);
mysql_free_result($alle);
$pr_side = 6;
if($antal > 0) {
$pr_side = 6;
$vis_fra = (isset($_GET["visfra"]) && is_numeric($_GET["visfra"]) && $_GET["visfra"] <
$antal) ? $_GET["visfra"] : 0;
$res = mysql_query ("SELECT * FROM bixen_vrag_msg WHERE replyto='$id' ORDER BY id DESC limit $vis_fra, $pr_side") or die(mysql_error());
if(isset($_POST['submit'])) {
require 'db.php';
$sql1 = mysql_query("SELECT id, replyto FROM bixen_vrag_msg");
if($row=mysql_fetch_array($sql1)) {
$godkendt = $_POST['godkendt'];
$id = $row['id'];
$replyto = $row['replyto'];
}
mysql_query("UPDATE bixen_vrag_msg SET godkendt='$godkendt' WHERE replyto ='$id'") or die(mysql_error());
echo "<div align=\"center\" class=\"tekst_linkThin\">Kommentar opdagteret</div>";
}
if(mysql_result($antal, 0) !=0) {
if (mysql_num_rows($res)== '0') {
print "<center>Der er ingen kommentare skrevet!<br><br><input type=button value=\"Tilbage\" class=\"input\" onClick=\"java script: history.go(-1)\"></center>";
} else {
echo"<table width=\"100%\" border=\"0\" cellpadding=\"0\" cellspacing=\"0\">
<tr bgcolor=\"5175A5\">
<td width=\"31%\"><span class=\"bil\">Model:</span></td>
<td width=\"19%\"><span class=\"bil\">Navn:</span></td>
<td width=\"36%\"><span class=\"bil\">Kommentar:</span></td>
<td width=\"14%\"><span class=\"bil\">Godkendt:</span></td>
</tr>";
while($row = mysql_fetch_array($res)) {
$replyto = $row['replyto'];
echo "<tr>
<td>";
$sql = "SELECT model FROM bixen_vrag WHERE id ='$replyto'";
$model = mysql_query($sql);
if (mysql_num_rows($model) < '0') {
echo " "; } else {
echo mysql_result($model, '$row[model]' );
}
echo"</td>
<td>";
if (!isset($row['navn'])) { echo " "; } else {
echo $row['navn'];
}
echo "</td>
<td>";
if (!isset($row['besked'])) { echo " "; } else {
$besked = explode(" ", $row["besked"]);
$besked = array_slice($besked, 0, 30);
$besked = implode(" ", $besked);
echo $besked;
}
echo "</td>
<td valign=\"top\">";
if (!isset($row['godkendt'])) { echo " "; } else {
echo "<form action=\"valgtvrag.php?id=$id\" name=\"godkendt\" method=\"POST\">";
$sql2 = mysql_query("SELECT godkendt FROM bixen_vrag_msg");
$godkendt = $row['godkendt'];
if($row=mysql_fetch_array($sql2)) {
echo "<select size=\"1\" name=\"godkendt\">";
if ($godkendt =="NEJ") print('<option value="NEJ" selected>Nej</option>');
else print('<option value="NEJ">Nej</option>');
if ($godkendt =="JA") print('<option value="JA" selected>Ja</option>');
else print('<option value="JA">Ja</option>');
}
echo "</select>";
echo "<input type=\"submit\" name=\"submit\" value=\"Opdagter\"></form>";
}
echo"</td>
</tr>";
echo "<tr>
<td> </td>
<td> </td>
<td> </td>
<td> </td>
</tr>";
}
echo "</table>";
?>
<?
if ($antal > $pr_side)
{
echo "<hr noshade color=\"#00000\" size=\"1\">\n";
$sql3 = mysql_query ("SELECT id FROM bixen_vrag WHERE id='$id'") or die(mysql_error());
while($row = mysql_fetch_array($sql3)) {
if ($vis_fra > 0) {
$back= $vis_fra - $pr_side;
echo "<a href='$_SERVER[PHP_SELF]?id=$row[id]&visfra=$back'>Forrige</a> ";
}
$page = 1;
for ($start = 0; $antal > $start; $start = $start + $pr_side) {
if($vis_fra != $page * $pr_side - $pr_side) {
echo "<a href='$_SERVER[PHP_SELF]?id=$row[id]&visfra=$start'>$page</a> ";
} else {
echo $page." ";
}
$page++;
}
if ($vis_fra < $antal - $pr_side) {
$next = $vis_fra + $pr_side;
echo " <a href='$_SERVER[PHP_SELF]?id=$row[id]&visfra=$next'>Næste</a>";
}
}
}
}
}
}
?>
<? include "slut.php"; ?>
men jeg får skæld ud her:
$antal = mysql_result($alle, 0);
mysql_free_result($alle);
hehe .. der skriver den:
Warning: mysql_result(): supplied argument is not a valid MySQL result resource in
Warning: mysql_free_result(): supplied argument is not a valid MySQL result resource in
