[grace1004]

d3iti:
On 000webhost.com server, I tested cron job file posted by NeilR on 07-12-2012
(subject: Cron not working for me). The cron job was to write something in a
txt file. When executed manually, the word "hello" was written in the txt file.
However, it didn't work through cron job.

When I tested a cron job with the same file on my Linux server installed in my PC,
it worked fine. That means NeiLR's code is nothing wrong.

[d3iti]

Originally Posted by grace1004

d3iti:
On 000webhost.com server, I tested cron job file posted by NeilR on 07-12-2012
(subject: Cron not working for me). The cron job was to write something in a
txt file. When executed manually, the word "hello" was written in the txt file.
However, it didn't work through cron job.

When I tested a cron job with the same file on my Linux server installed in my PC,
it worked fine. That means NeiLR's code is nothing wrong.

grace1004, thanks again for sharing your trials and experiences.

[caboose9792]

The txt files seem to be working fine within PHP. I use them for logging updates to the mysql database. That way if the MySQL server goes offline I can still operate the page and update the DB later. My code worked for a few updates over the last 36 hours, as I break up my sql use to try to keep from running afoul the 000's vague TOS. About three hours ago my last attempt (two back to back runs) and the first ran and the second attempt failed.

Attempts after that also failed but I can still access the DB and do other things with the DB just not run UPDATE commands. Also I noticed the other night after posting the HTML that is supposed to be on the bottom of the page is not turning up on pages when the query fails to complete and also the program does not loop. It is like the MySQL quire gets lost or blocked but no errors are shown. Is there limits on the SQL servers that differ from the main servers? The TOS and the help desk is clear as tar on the subject.

[caboose9792]

Not wanting to give up without knowing what has gone wrong I have been playing with a few more things. I got an interesting result from this code piece:

$road2 =PAL;
if ($road==$road2) { print "PAL is PAL <br>";} else {print "road is not PAL <br>";}

I inserted it ahead of the MySQL quirey posted earlier. What I found the string in the data PAL was not equal to PAL. SO there both the same letters both striped of white space and coded under UTF-8. It explains why the MySQL fails but out of ideas how to bring them into pairaty. The coding sometimes works but usually it doesn't and the same code used elsewhere works fine on the same sight different page.

Any thoughts?

[d3iti]

Hello,

You can try to put quotation marks to delimit character strings:

PHP Code:

$road2 ='PAL';
if ($road==$road2) { print "PAL is PAL <br>";} else {print "road is not PAL <br>";} 


[caboose9792]

Like this?

$road1 = "$road";

[d3iti]

Originally Posted by caboose9792

Like this?

$road1 = "$road";

No. Quotes are used when it is a character string (or character) but are not used when using two variables.