CyJobes

I have an app that connects to a source safe server to perform a command via shell_exec(). I had used exec(), but shell_exec seems to work better since I am on Linux. The command connects to the server and tells it to promote a file to the next level. On Windows this ran without a hitch, but on Linux I gat an error that reads: I am told that the reason for this error is that PHP broke the connection to the server before the server completed the job and was able to shutdown properly. The only way I have found around this is to place a sleep(3) to the script. This is really not ideal since that means that there is at least 3 seconds between each command, which can really extend the time it takes to perform if there are numerous files. If PHP breaks the connection before the program can close it will leave the program open and PHP cannot perform any more commands to the server since it is stuck on the last command. If too many are given the machine will lock up due to resources being eaten up. I'm wanting to know if there is a way to tell PHP to not let go of a connection so quickly. I tried "nohup", but that does not help. I am new to Linux and am at a loss of what my options are beyond the sleep() method. I really feel that there has to be a better way or setting that can be manipulated to fix this issue altogether. Thanks in advance for any help. Cy

I have two tables that are identical in fields. rate_info_stndby - used to edit site in an admin before going live rate_info - live table used on site I need a fast and easy way to compare the tables and find out what is different between the two. This way I can create a list of inserts, updates or deletes. Once table are in sync they are, of course, identical in data. However, the rate_info_stndby table is accessed only by the admin and can change in data entry, new rows or deleted rows. Finding these differences is what I need to alert the admin that the tables are no longer in sync, and to use the info to create the SYNC script. I've worked with MySQL for a while, but not very deep. I just finished a "MySQL for Developers" course, but joins went way over my head. Any help would be appreciated. Thanks, Cy