[php]<?php
$sql = “SELECT
p.id,
p.pid,
p.title,
p.text,
p.main_text,
p.views,
p.date,
c.,
l.,
u.username
FROM
posts
INNER JOIN
comments c ON p.id = c.pid
INNER JOIN
likes l ON p.id = l.pid
INNER JOIN
username u ON p.pid = u.id
ORDER BY date DESC”;
$result = $conn->query($sql);
while($row = $result->fetch_assoc()) {
echo"
<div class='background'>
<div class='title'><b>". $row['title'] ."</b></div>
<div style='margin:auto;width:700px;'>
<div class='text'>". $row['text'] ."</div>
<a href='topic.php?id=$row[id]' class='view'>View</a>
</div>
<div style='padding-top:30px; padding-left: 20px;padding-right:10px;'>
<div class='poster'><b><i class='fa fa-eye'></i> ". $row['views'] ." Views</b></div>
<div class='poster'><b>Posted by</b> $dbusername</div>
<div class='poster'><b><i class='fa fa-thumbs-up'></i> $likes</b></div>
<div class='poster'><b><i class='fa fa-comments-o'></i> $comments</b></div>
<div class='poster' style='float:right;'><b>". $row['date'] ."</b></div>
</div>
</div>";}
?>[/php]
Fatal error: Call to a member function fetch_assoc() on a non-object in C:\xampp\htdocs\GrabPoints2\profile.php on line 44
Line 44: [php]while($row = $result->fetch_assoc()) {[/php]