https://www.youtube.com/watch?v=NJZBl5K ... e&index=13
Jeg er lidt usikker på hvor fejlen er og håber at der er en der kan hjælpe mig lidt.
Warning: mysqli_fetch_array() expects parameter 1 to be mysqli_result, null given in /home2/flyingj/public_html/index.php on line 6
Kode: Vælg alt
<?php
include_once("php_includes/check_login_status.php");
$sql = "SELECT username, avatar FROM users WHERE avatar IS NOT NULL AND activated='1' ORDER BY RAND() LIMIT 32";
$sql = mysqli_query($db_conx, $sql);
$userlist ="";
while ($row = mysqli_fetch_array($query, MYSQLI_ASSOC)) {
$u = $row["username"];
$avatar = $row["avatar"];
$profile_pic = 'user/'.$u.'/'.$avatar;
$userlist .= '<a href="user.php?u='.$u.'" title="'.$u.'"><img src="'.$profile_pic.'" alt="'.$u.' style="width:100px; height:100px; margin:10px;"></a';
}
$sql = "SELECT COUNT(id) FROM users WHERE activated='1'";
$query = mysqli_query($db_conx, $sql);
$row = mysqli_fetch_row($query);
$usercount = $row[0];
?>
