Mysidia Adoptables Support Forum  

Home Community Mys-Script Creative Off-Topic
Go Back   Mysidia Adoptables Support Forum > Mysidia Adoptables > Questions and Supports

Notices

 
 
Thread Tools Display Modes
Prev Previous Post   Next Post Next
  #1  
Old 02-25-2017, 10:49 AM
Dinocanid's Avatar
Dinocanid Dinocanid is offline
Member
 
Join Date: Aug 2016
Location: Maryland, USA
Posts: 516
Gender: Unknown/Other
Credits: 93,871
Dinocanid is on a distinguished road
Default Problem with adopt with most clicks

I've run into an odd problem where the adoptable with the most clicks will pick my adoptable, when it shouldn't be. Like this:

PHP Code:
$topclicks $mysidia->db->select("owned_adoptables", array("totalclicks"), "Type='{$species}'""1 ORDER BY totalclicks DESC LIMIT 1")->fetchColumn();
    
$topadopt $mysidia->db->select("owned_adoptables", array("name"), "Type='{$species}'""1 ORDER BY totalclicks DESC LIMIT 1")->fetchColumn();
    
$topadoptowner $mysidia->db->select("owned_adoptables", array("owner"), "Type='{$species}'""1 ORDER BY totalclicks DESC LIMIT 1")->fetchColumn(); 
(The code that's showing my pet)
This should get the information of the adoptable with the most clicks, but it seems to only pick my adoptable, which doesn't have the most clicks. What's weird about it is that there's other identical code in the script that works correctly, but this one strangely does not. Maybe I need another pair of eyes to spot the difference, if there is one:
PHP Code:
$topclicks $mysidia->db->select("owned_adoptables", array("totalclicks"), "Type='{$species}'""1 ORDER BY totalclicks DESC LIMIT 1")->fetchColumn();
    
$topadopt $mysidia->db->select("owned_adoptables", array("name"), "Type='{$species}'""1 ORDER BY totalclicks DESC LIMIT 1")->fetchColumn();
    
$topadoptowner $mysidia->db->select("owned_adoptables", array("owner"), "Type='{$species}'""1 ORDER BY totalclicks DESC LIMIT 1")->fetchColumn(); 
(The code that works)
__________________
Reply With Quote
 


Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is On
HTML code is Off

Forum Jump


All times are GMT -5. The time now is 10:18 AM.

Currently Active Users: 3714 (0 members and 3714 guests)
Threads: 4,081, Posts: 32,032, Members: 2,016
Welcome to our newest members, jolob.
BETA





What's New?

What's Hot?

What's Popular?


Powered by vBulletin® Version 3.8.11
Copyright ©2000 - 2025, vBulletin Solutions Inc.
vBCommerce I v2.0.0 Gold ©2010, PixelFX Studios
vBCredits I v2.0.0 Gold ©2010, PixelFX Studios
Emoticons by darkmoon3636