Thread: Programmers, how hard would this be?
View Single Post
Old 01-31-2008, 01:37 AM  
Dynamix
G F Y not
 
Industry Role:
Join Date: Jan 2004
Location: MN
Posts: 2,910
Quote:
Originally Posted by Jace View Post
that is randomizing them every time it pulls the rss page up

http://lyrics.gamesandlyrics.com/rss.php
Right, because your date column is fucked up :/

Run this SQL query:

UPDATE lyrics set submit_date = '2008-01-30' where 0=0;

To set all dates to yesterday
__________________

TGPFactory Full TGP Design & Installation Services
ICQ 250 142 484 · AIM TGPDynamix · Email: patrick (at) tgpfactory (dot) com
See who I am at AdultWhosWho.com!
Dynamix is offline   Share thread on Digg Share thread on Twitter Share thread on Reddit Share thread on Facebook Reply With Quote