[bi11i]

Originally Posted by Hawkbizkit

oh dummy me i read your error wrong sorry well i would say try this code

Find: (should be around line 307ish in affiliates.php)

PHP Code:

            $faffiliate=$db->query_read("SELECT affiliate_id,sitename,siteurl,buttonurl,name,id,sitedesc,clicksout,clicksin,totalrating,totalvotes 
                                        FROM " . TABLE_PREFIX . "affiliates AS affiliates LEFT JOIN " . TABLE_PREFIX . "affiliates_types  AS affiliates_type
                                        ON " . TABLE_PREFIX . "affiliates.type = " . TABLE_PREFIX . "affiliates_types.id 
                                        WHERE active='1' AND approved='1' 
                                        ORDER BY $by $in 
                                        LIMIT $limitvalue,$perpage"
                                        ); 


Replace with:

PHP Code:

            $faffiliate=$db->query_read("SELECT affiliate_id,sitename,siteurl,buttonurl,name,id,sitedesc,clicksout,clicksin,totalrating,totalvotes 
                                        FROM " . TABLE_PREFIX . "affiliates LEFT JOIN " . TABLE_PREFIX . "affiliates_types 
                                        ON " . TABLE_PREFIX . "affiliates.type = " . TABLE_PREFIX . "affiliates_types.id 
                                        WHERE active='1' AND approved='1' 
                                        ORDER BY $by $in 
                                        LIMIT $limitvalue,$perpage"
                                        ); 


Thats how i have my code setup and it is working just fine and when i tried it your way it doesn't work...

I've got this with your new modification:

Database error in vBulletin 3.5.0 Release Candidate 3:

Invalid SQL:
SELECT affiliate_id,sitename,siteurl,buttonurl,name,id,si tedesc,clicksout,clicksin,tota lrating,totalvotes
FROM opio_affiliates LEFT JOIN opio_affiliates_types
ON opio_affiliates.type = opio_affiliates_types.id
WHERE active='1' AND approved='1'
ORDER BY sitename DESC
LIMIT 0,5;

MySQL Error : Unknown column 'tota' in 'field list'
Error Number : 1054
Date : Wednesday, September 28th 2005 @ 02:17:58 PM
Script : http://forum.opiophile.org/affiliate...listaffiliates
Referrer : http://forum.opiophile.org/affiliate.php
IP Address : 192.168.0.110
Username : bi11i
Classname : vB_Database_MySQLi