Quote:
Originally Posted by Kaeliah
That sounds cool! I'd totally go for a mod like that! :D
Maybe also do the ten newest adopted? ^.^ Just an idea.
|
Ten newest adopted isn't so hard!
just use this query:
PHP Code:
$query = "SELECT * FROM ".$prefix."owned_adoptables ORDER BY aid DESC LIMIT 10";
That's actually the query to fetch the top 10 adoptables all I did was change the "ORDER BY totalclicks" to "ORDER BY aid" and it will fetch 10 newest adopted pets