cracker1

Hi Barand, I got it to work. I added the database name to the database table in the query. It fixed the problem. Will that cause any security issues do you think? The actual error message was "Error in update query" followed by the details of the first record I was trying to update. As far as I could see, the code started to run through the loop and started to update the first record and then quit and died. I'm still not sure why it runs on my local copy with the complete reference to the specific table and the remote copy needs it like this.. $query = "UPDATE dbName.tbl_OrderDetails SET OrderNumber = '$OrderNumber', OrderDate = '$OrderDate', RequiredDate = '$RequiredDate',....etc

My code is working (ie updating the database) on my local site using MAMP however, it is not updating in my remote site. Can anyone understand why? I have copied my local files up to my remote and have not changed anything. The code runs through the mysql query and display the error message. The code starts going through the loop then stops at the end of the first record in the recordset and spits out the error message. I don't understand why it works okay on local and not on remote. Would it be something on the remote server side? Please help urgently. Thanks. Regards. cracker1 <?php $size = count($_POST['OrderNumber']); $i = 0; while ($i < $size) { $OrderNumber= $_POST['OrderNumber'][$i]; $OrderDate= $_POST['OrderDate'][$i]; $RequiredDate= $_POST['RequiredDate'][$i]; $fk_TrophyCode= $_POST['fk_TrophyCode'][$i]; $Customer= $_POST['Customer'][$i]; $PartCode= $_POST['PartCode'][$i]; $PartDescription= $_POST['PartDescription'][$i]; $PartQty= $_POST['PartQty'][$i]; $Freight= $_POST['Freight'][$i]; $Supplier= $_POST['Supplier'][$i]; $OrderDetailID = $_POST['OrderDetailID'][$i]; $query = "UPDATE tbl_OrderDetails SET OrderNumber = '$OrderNumber', OrderDate = '$OrderDate', RequiredDate = '$RequiredDate', fk_TrophyCode = '$fk_TrophyCode', Customer = '$Customer', PartCode = '$PartCode', PartDescription = '$PartDescription', PartQty = '$PartQty', Freight = '$Freight', Supplier = '$Supplier' WHERE OrderDetailID = '$OrderDetailID'"; mysql_query($query) or die ("Error in update query: $query"); ++$i; } ?>