Vistors stats

[Cordilo]

Great contrib, but if change to counter decs i got an mysql error

 

1064 - You have an error in your SQL syntax. Check the manual that corresponds to your MySQL server version for the right syntax to use near 'DESCcustomers_id' at line 1

 

select count(*) as total from visitors ORDER BY counter DESCcustomers_id

[reppy]

Great contrib, but if change to counter decs i got an mysql error

 

1064 - You have an error in your SQL syntax. Check the manual that corresponds to your MySQL server version for the right syntax to use near 'DESCcustomers_id' at line 1

 

select count(*) as total from visitors ORDER BY counter DESCcustomers_id

<{POST_SNAPBACK}>

 

 

 

In case anyone else is having this problem, I figured it out. At around line 192, look for:

 

switch ($listing) { 
     case "counter-asc": 
       $order .= "counter"; 
     break; 
     case "counter-desc": 
       $order .= "counter DESC";

 

After $order .= "counter DESC"; add:

 

break;