Could someone help this newbie please?
My web host has PHP in Apache module I can run a cron with a basic PHP script. Adding mySQL is the issue. Running a PHP page that has mysql_fetch_assoc will not run with cron but it will with Telnet.
I can Telnet the following. PHP mysql_fetch_assoc and Sendmail work perfectly so we are close.
(The following is is all in one line).
lynx -dump http://www.texashuntinglease.com/hp/match_email14.php
However, when the same is scheduled into my web hosts cron scheduling page exactly the same way it will not run. Why will it work perfectly in Telnet but not cron?
Any ideas?
Changing the PHP page to add
#!/usr/local/bin and trying it the other way will not run in cron either. It also will not run in Telnet
Here is the Telnet error- when running
/usr/local/php /home/www/texashuntinglease/hp/match_email15.php
fuchsia:~$ /usr/local/php /home/www/texashuntinglease/hp/match_email15.php
Content-type: text/html
<br>
<b>Fatal error</b>: Call to unsupported or undefined function mysql_fetch_assoc
() in <b>/home/www/texashuntinglease/hp/match_email15.php</b> on line <b>15</b><
br>
fuchsia:~$
line 15 is
$row_selectemail = mysql_fetch_assoc($selectemail);
it gets by six mysql things and stops on mysql_fetch_assoc
We have worked on this for seven months and are very close to having it work. Any help would be greatly appreciated.
Someone hinted of a BASH scrip but I have no ided what they ment or how to do it to run lynx on a scheduled time each day when cron does not work with lynx.
