Well, I tried it 2 ways... First I tried the method where I add this line of text to the top of my PHP document.
#!.:/usr/local/lib/php
That didn't work..
I also tried it these ways...
#!./usr/local/lib/php
#!/usr/local/lib/php
#!usr/local/lib/php
Still nothing.
Then I tried using the lynx command instead (I don't have a wgets command or a links command). The lynx command worked perfectly, but then I got an email from someone saying that I was killing the server. Since it wasn't from my web hosts tech-support address, I didn't think much of it. I did turn off the crontab by using crontab -r, and deleted the crontab txt file and the php file just to be safe.
A few hours later, another email came from the same person, again saying that I was putting too much load on the server. Well, it couldn't be me because I shut it all off.
Then this morning I got an email from the tech-support guy at my webhost (phpwebhosting.com). Here what his email...
"A script of yours (which apparently runs lynx) is out of control. We have disabled your use of lynx until you find a solution to this. Basically, your script appears to not be closing it's sessions. The more it runs the more open lynx processes it leaves on the server."
So now I do not have lynx anymore, untill I can figure out what the problem is.
Here is my PHP script...
// Mail The Database to greydigger@voyager.net
mysql_connect('localhost','macstore','camelfilters');
$email = "Videos\n------\n\n";
$temp = mysql_db_query('phpHoo','select * from videos');
while ($row = mysql_fetch_array($temp)):
$email = $email . "INSERT INTO videos ";
$email = $email . "(ID,title,series,price,info1,info2,info3,info4,info5,info6,info7,info8,nudeRate,nudeInfo,langRate,langInfo,violRate,violInfo,situRate,situInfo,rentDate,rentLength,rentStatus) VALUES";
$email = $email . " ('$row[ID]','$row[title]','$row[series]','$row[length]','$row[price]','$row[info1]','$row[info2]','$row[info3]','$row[info4]','$row[info5]','$row[info6]','$row[info7]','$row[info8]','$row[nudeRate]','$row[nudeInfo]','$row[langRate]','$row[langInfo]','$row[violRate]','$row[violInfo]','$row[situRate]','$row[situInfo]','$row[rentDate]','$row[rentLength]','$row[rentStatus]');\n\n";
endwhile;
$email = $email . "\n\n\nAccounts\n------\n\n";
$temp = mysql_db_query('phpHoo','select * from accounts');
while ($row = mysql_fetch_array($temp)):
$email = $email . "INSERT INTO accounts ";
$email = $email . "(ID,first,last,birth,first2,birth2,first3,birth3,first4,birth4,phone,email,address,city,state,zip,driverID,allow16,halfOff,lateFee,rentals) VALUES";
$email = $email . " ('$row[ID]','$row[first]','$row[last]','$row[birth]','$row[first2]','$row[birth2]','$row[first3]','$row[birth3]','$row[first4]','$row[birth4]','$row[phone]','$row[email]','$row[address]','$row[city]','$row[state]','$row[zip]','$row[driverID]','$row[allow16]','$row[halfOff]','$row[lateFee]','$row[rentals]');\n\n";
endwhile;
mail('greydigger@mac.com','Database Email',$email);
Could it be that the mysql connections are the problem? I don't think that is it because I have done many mysql connections before this and no-one have complained about that. It was only after I used the lynx command that they started bitching, as if I know how to fix this. They are the tech-support guys, they should have a better understanding of this than I do.
