Retrive The Field Info

[ForumsMods]

Originally Posted by 3amalah

(nothing), (nothing), (nothing)

But When I Make It Like That

$getrepx = $db->query_read("SELECT * FROM " . TABLE_PREFIX . "user ORDER BY posts DESC LIMIT 0, $adet");
while ($getrep = $db->fetch_array($getrepx))
{ 
$sonuclaryaz .= "<a href=\"member.php?u=".$getrep['userid']."\">".$getrep['username']."</a> (".$getrep['posts']."), ";
}

The Posts Appears Instead Of Reputation And Everything Going Fine

Now Why It Cant Import Data From The userfield Table

Is There's Somethign Wrong In This Code ?

$getrepx = $db->query_read("SELECT * FROM " . TABLE_PREFIX . "userfield ORDER BY field8 DESC LIMIT 0, $adet");
while ($getrep = $db->fetch_array($getrepx))
{ 
$sonuclaryaz .= "<a href=\"member.php?u=".$getrep['userid']."\">".$getrep['username']."</a> (".$getrep['field8']."), ";
}

Take a not taht you have to join user table to get username.
Also LIMIT 0 is not necessary.
And what is $adet?