over9k

Thanks Premiso Working Cron line: */5 * * * * php /home/me/public_html/extra/weatherGet.php

*/5 * * * * /home/me/public_html/extra/weatherGet.php Thanks Premiso I plan on making it run less frequently when I get it working, Running it every 5 min for now. Permissions on weatherGet.php are 775

The Line in Question is: <?php $weatherApi = implode('', file('http://www.google.com/ig/api?weather=65459')); ... Cron is returning: /home/me/public_html/extra/weatherGet.php: line 1: ?php: No such file or directory /home/me/public_html/extra/weatherGet.php: line 2: syntax error near unexpected token `(' /home/me/public_html/extra/weatherGet.php: line 2: ` $weatherApi = implode('', file('http://www.google.com/ig/api?weather=46802'));' I have a lot of code that relies on the contents of $weatherApi to be the output of: http://www.google.com/ig/api?weather=65459 It works fine if I run the script by entering the URL into the browser but fails when scheduled by Cron. Any help is greatly appreciated, thanks

Thanks PFMaBiSmAd, it worked perfectly I just found the mySQL date functions. I have a second question: Is there any problem with using datetime type as a primary key if the only precision needed is to the minute?

SELECT * FROM `schedule` WHERE `date`='2010-01-01' also tried: SELECT * FROM `schedule` WHERE `date`='2010-01-01 *' SELECT * FROM `schedule` WHERE `date`='2010-01-01 *:*:*' I'm trying to get all records from a certain day disregarding the time portion but the above code is only returning one record when there are many records for a particular day A record looks something like: [pre] id date 0000 0000-00-00 00:00:00 [/pre] The date field is type datetime MySQL server version -- 5.1.30