Originally Posted by teamzr1
I figured it out, you used lowercase and it has to be ADMIN_LOG
but I found I needed was SELECT * FROM ubbt_REFERER_LOG
was the data I wanted but, kinda a pain since as mentioned I would have to copy paste that data to my PC


my bad, i have a doze box (local wamp) that i didn't maintain upper case on.. glad you caught that.

Originally Posted by teamzr1
1,"1183780091","http://www.ls1tech.com/forums/showthread.php?t=743763"


1st field is date/time...

use: FROM_UNIXTIME(REFERRER_DATE ,'%M %e, %Y - %h:%i %p') AS Time

for that field wink

Code
SELECT FROM_UNIXTIME(REFERER_DATE ,'%M %e, %Y - %h:%i %p')
 AS Time, REFERER_URL 
FROM `ubbt_REFERER_LOG`