Makaleler
$query = mysqli_query("SELECT a.id as aid,u.avatar as uavatar,a.title as atitle,a.createdate as acreatedate,u.name as uname,u.surname as usurname,ur.title_tr as urtitle FROM article a,user u,user_role ur where lang='$LANG' and a.author_fk=u.id and u.role_fk=ur.id order by aid DESC"); while ($temp2 = mysqli_fetch_assoc($query)) { echo "
" . $temp2["atitle"] . "
(" . $temp2['urtitle'] . " " . $temp2['uname'] . " " .$temp2['usurname'].")\n"; echo " \n"; echo "\n"; } echo " \n"; echo "