[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 job.

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 ron.pigg...@actsministries.org wrote: I am trying to write a query to

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 of a cron