PHP commands, Crontab and mysql_connect
 

Has anyone run into this problem?

I have one machine that holds a database table with two attributes; one is for a message and the other is an email addres.

I then have a second machine that connects to the first machine using mysql_connect command in PHP, reads the row and sends of the message to the appropriate email address.

If I run the scriptfile manually (ex. php myscript.php) as root, it works well. When I put the command in crontab, nothing happens.

One quick note, if I remove only the mysql_connect string and just put in static data, Crontab works.

Does anyone know what's wrong?