Using MySql 3.23
Using Perl, I have a table that I feed data into. I then retrieve the
data and order it to write to arrays for use further on.
All works fine. Data remains in proper order (e.g. head[1] is in the
same array position as graf[1], etc.
The problem occurs now that I am trying to only retrieve a limited
number of days using
SELECT * from news_stories WHERE (TO_DAYS(NOW()) - TO_DAYS(date_pub) <
6) order by date desc, weight;
The data is now not matching up. When outputted, head[1] may be paired
with graf[4]. I cannot detect a pattern as to why the correct
correlation is no longer taking place.
Any help or directions to solution in docs would be appreciated.
MySQL, database, etc.
--
Greg Peretti
web developer
www.abqjournal.com
(505) 823-3888
-----------------------------------------------------------------
-----------------------------------------------------------------
"The web of our life is of a mingled yarn, good and ill together."
William Shakespeare, "All’s Well That Ends Well."
"The more I know, the less I understand."
Don Henley, "The Heart of the Matter."
---------------------------------------------------------------------
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
http://lists.mysql.com/ (the list archive)
To request this thread, e-mail <[EMAIL PROTECTED]>
To unsubscribe, e-mail <[EMAIL PROTECTED]>
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
