Hjælp til brugerliste.

lige en ting til.!

Nogle der kan se hvad fejlen i linie 10 er.!
Den viser fejlbillede

if($_GET[vis] == "") { $_GET[vis] = 0; }
if($_GET[vis2] == "") { $_GET[vis2] = 0; }

$antal = mysql_num_rows(mysql_query("SELECT id FROM ALS_signup")) ;
$pages = ceil($antal / $pagelimit) ;
$page = ceil(($_GET[vis] + 1) / $pagelimit) ;

echo "<b>Vis side: <b> " ;

for ($i = 1 ; $i <= $pages ; $i++) {           

if ($i == $page) {
echo "<b> " . $i . " </b>" ;
    }

else {
echo "<a href='$PHP_SELF?vis=" . (($i * $pagelimit) - $pagelimit)  . "'>" . $i . "</a>" ;

}
}



$henter = mysql_query("SELECT * FROM ALS_signup ORDER BY actnum DESC LIMIT $_GET[vis], $pagelimit");

while ($row = mysql_fetch_array($henter))
{
print("".$row['username']." -        ");
print("Level ".$row['userlevel']."</br>");
echo ("<img src='$user_current_Level'>");
}

How husk lige :

mysql_connect("localhost","xxx","xxx");
mysql_select_db("xxx");

Sorry jeg blander mig, men har lige prøvet det. Og jeg kan ikk få det til at virke :(

Får disse fejl:

Warning: Division by zero in /customers/kack.dk/kack.dk/httpd.www/newsite/main/brugerliste.php on line 14

Warning: Division by zero in /customers/kack.dk/kack.dk/httpd.www/newsite/main/brugerliste.php on line 15
Vis side:
Warning: mysql_fetch_array(): supplied argument is not a valid MySQL result resource in /customers/kack.dk/kack.dk/httpd.www/newsite/main/brugerliste.php on line 35

Og dette er min kode:

<?php
include ("config.php");
?>
<table>
<tr>
<td><h1>Brugerliste</h1></td>
</tr>
</table>
<?
if($_GET[vis] == "") { $_GET[vis] = 0; }
if($_GET[vis2] == "") { $_GET[vis2] = 0; }

$antal = mysql_num_rows(mysql_query("SELECT id FROM com_brugere"));
$pages = ceil($antal / $pagelimit) ;
$page = ceil(($_GET[vis] + 1) / $pagelimit) ;

echo "<b>Vis side: <b> " ;

for ($i = 1 ; $i <= $pages ; $i++) {

if ($i == $page) {
echo "<b> " . $i . " </b>" ;
    }

else {
echo "<a href='$PHP_SELF?vis=" . (($i * $pagelimit) - $pagelimit)  . "'>" . $i . "</a>" ;

}
}



$henter = mysql_query("SELECT * FROM com_brugere ORDER BY brugernavn DESC LIMIT $_GET[vis], $pagelimit");

while ($row = mysql_fetch_array($henter))
{
print("".$row['brugernavn']." -        ");
print("Køn ".$row['kon']."</br>");
}
?>

Bruger selv disse:

<?php

function make_link($getvar, $tx, $filnavn="", $class="") {
if(empty($filnavn)) {
$filename = $_SERVER["PHP_SELF"];
}else{
$filename = $filnavn;
}
return "<a href=\"". $filename . $getvar ."\" class=\"". $class ."\">". htmlentities($tx) ."</a>";
}

function make_sublinks($antalviste, $ialt, $getvar, $qstring="") {

if($ialt > $antalviste) {

if(isset($_GET[$getvar]) && $_GET[$getvar] >= $ialt) {
return;
}

if(!empty($qstring)) {
$qlink = $qstring ."&amp;". $getvar ."=";
}else{
$qlink = "?". $getvar ."=";
}

    if(!isset($_GET[$getvar]) || !is_numeric($_GET[$getvar]) || $_GET[$getvar] < 0) {
    $back = "&nbsp;";
    $next = make_link($qlink . $antalviste, "næste") ." &nbsp; ". make_link($qlink . ($ialt-$antalviste), ">>");
    $info = "1 - ". $antalviste ." af ". $ialt;
    }else{
    $info = ($_GET[$getvar]+1) ." - ". ($_GET[$getvar]+$antalviste) ." af ". $ialt;

        if($_GET[$getvar] <= $antalviste) {
        $linket = $qstring;
        }elseif($_GET[$getvar] >= $ialt) {
        $linket = $qlink . ($ialt-$antalviste);
        }else{
        $linket = $qlink . ($_GET[$getvar]-$antalviste);
        }
        $back = make_link($qstring, "<<") ." &nbsp; ". make_link($linket, "forrige");

        if(($_GET[$getvar]+$antalviste) >= $ialt) {
        $next = "&nbsp;";
        $info = ($_GET[$getvar]+1) ." - ". $ialt ." af ". $ialt;
        }else{
        $next = make_link($qlink . ($_GET[$getvar]+$antalviste), "næste");
            if($_GET[$getvar] < ($ialt-$antalviste)) {
            $next = $next ." &nbsp; ". make_link($qlink . ($ialt-$antalviste), ">>");
            }
        }
    }

echo"<table width=\"400\" border=\"0\" align=\"center\"><tr>\n";
echo"    <td width=\"33%\" class=\"small\">". $back ."</td>\n";
echo"    <td width=\"34%\" class=\"small\" align=\"center\">". $info ."</td>\n";
echo"    <td width=\"33%\" class=\"small\" align=\"right\">". $next ."</td>\n";
echo"</tr></table>";
    }
}

mysql_connect("localhost","xxx","xxx");
mysql_select_db("xxx");
$all = mysql_query("SELECT COUNT(username) as total FROM ALS_signup") or die (mysql_error());
$antal = mysql_result($all, 0);

$viste = 10; // Hvor mange pr. side?

if(!isset($_GET["vis"]) || !is_numeric($_GET["vis"])) {
$start = 0;
}else{
    if($_GET["vis"] >= $antal) {
    $start = $antal-1;
    }else{
    $start = $_GET["vis"];
    }
}


$henter = mysql_query("SELECT * FROM ALS_signup ORDER BY actnum DESC LIMIT ". $start .", ". $viste ."") or die (mysql_error());

while ($row = mysql_fetch_array($henter))
{
print($row["username"]." -        ");
print("Level ".$row["userlevel"]."<br />\n");
echo ("<img src=". $user_current_Level .">");
}

make_sublinks($viste, $antal, "vis");
?>

<?php
mysql_connect("localhost","xxx","xxx");
mysql_select_db("xxx");

    // Næste funktion
    if (!isset($page)) $page = 0;
    $antal = 7; // Antal af posts pr side
    $total = $page * $antal;
    $bla = 10 + 10 * $page;
    $af = $num3 / $antal;
    $side = $page + 1;
    $num = ; // Antal brugere ialt

$henter = mysql_query("SELECT * FROM ALS_signup ORDER BY actnum DESC LIMIT $total, $antal");

        if ($page > 0) {
            echo "<a href=\"cmd.php?do=tagwall&&page=" . ($page - 1) . "\" class=hyper>$font1 &#60&#60</a>";
        } else {
            echo "$font1 &#60&#60";
        }
        echo"$font1 $side af ";
        echo ceil($af);

            if ($num > $bla) {
            echo "<a href=\"cmd.php?do=tagwall&&page=" . ($page + 1) . "\" class=hyper>$font1 &#62&#62</a>";
        } else {
            echo "$font1 &#62&#62";
        }

while ($row = mysql_fetch_array($henter))
{
print("".$row['username']." -        ");
print("Level ".$row['userlevel']."</br>");
echo ("<img src='$user_current_Level'>");
}

?>

Ups, lavede en fejl.. sæt dette script op og det virker med garanti =)

<?php
mysql_connect("localhost","xxx","xxx");
mysql_select_db("xxx");

$henter1 = mysql_query("SELECT * FROM ALS_signup");
$num = mysql_num_rows($henter1);

    // Næste funktion
    if (!isset($page)) $page = 0;
    $antal = 7; // Antal af posts pr side
    $total = $page * $antal;
    $bla = 10 + 10 * $page;
    $af = $num3 / $antal;
    $side = $page + 1;

$henter = mysql_query("SELECT * FROM ALS_signup ORDER BY actnum DESC LIMIT $total, $antal");

        if ($page > 0) {
            echo "<a href=\"cmd.php?do=tagwall&&page=" . ($page - 1) . "\" class=hyper>$font1 &#60&#60</a>";
        } else {
            echo "$font1 &#60&#60";
        }
        echo"$font1 $side af ";
        echo ceil($af);

            if ($num > $bla) {
            echo "<a href=\"cmd.php?do=tagwall&&page=" . ($page + 1) . "\" class=hyper>$font1 &#62&#62</a>";
        } else {
            echo "$font1 &#62&#62";
        }

while ($row = mysql_fetch_array($henter))
{
print("".$row['username']." -        ");
print("Level ".$row['userlevel']."</br>");
echo ("<img src='$user_current_Level'>");
}

?>

Igen her..!

Nu stopper du snart jm0.:-)
Tak fordi at du gør Eksperten værd at være på

Det var så lidt, jeg nyder bare at kunne hjælpe andre :)

Og tak for points!