Re: [PHP-DB] Broken query

2010-07-11 Thread Niel Archer
> > I am trying to write a query to select a trivia question, but I don't want > the trivia question category to be the same two days in a row so I added a > second "SELECT" syntax to find out what category was used yesterday. This > works when I test it "live", but doesn't work when it is part o

Re: [PHP-DB] Broken query

2010-07-11 Thread Patrick Price
How is the last mailing date variable set? Have you tried printing out the queries that are run when it is run manually and when it is run as a cron to find any differences? -patrick On Jul 11, 2010 8:23 AM, "Ron Piggott" wrote: I am trying to write a query to select a trivia question, but I d

[PHP-DB] Broken query

2010-07-11 Thread Ron Piggott
I am trying to write a query to select a trivia question, but I don't want the trivia question category to be the same two days in a row so I added a second "SELECT" syntax to find out what category was used yesterday. This works when I test it "live", but doesn't work when it is part of a cron j