Multiple update script works on one server but not another

[joesoaper]

I am moving my website to a new Service Provider. The script I use for multiple updating worked on the older server but not on the new one. It shows the information but does not update the records.

Any help would be greatly appreciated.

 

Old Server  : PHP 5.2.11    MYSQL: 5.0.92-community

New Server : PHP 5.2.17    MYSQL: 5.1.47-community

 

Script:

<?php 

 

include("head.php");

$host="localhost"; // Host name

$username="xxxxxxx"; // Mysql username

$password="xxxxxxx"; // Mysql password

$db_name="xxxxxxx"; // Database name

$tbl_name="xxxxxxx"; // Table name

 

// Connect to server and select databse.

mysql_connect("$host", "$username", "$password")or die("cannot connect");

mysql_select_db("$db_name")or die("cannot select DB");

 

$sql="SELECT * FROM $tbl_name limit 20";

$result=mysql_query($sql);

 

// Count table rows

$count=mysql_num_rows($result);

?>

<title>PowerMan South Africa</title>

<META HTTP-EQUIV="Pragma" CONTENT="no-cache">

<META HTTP-EQUIV="Expires" CONTENT="-1">

<meta http-equiv="Content-Type" content="text/html; charset=utf-8" />

<link rel="stylesheet" href="style.css" type="text/css" media="screen" />

<style type="text/css" media="screen,projection">

@import url(calendar.css);

</style>

 

 

</head>

<table width="500" border="0" cellspacing="1" cellpadding="0">

<form name="form1" method="post" action="">

<tr>

<td>

<table width="500" border="0" cellspacing="1" cellpadding="0">

 

 

<tr>

<td align="center"><strong>ID</strong></td>

<td align="center"><strong>Company</strong></td>

<td align="center"><strong>contact</strong></td>

<td align="center"><strong>Email</strong></td>

<td align="center"><strong>Telephone</strong></td>

<td align="center"><strong>Type</strong></td>

 

</tr>

<?php

while($rows=mysql_fetch_array($result)){

?>

<tr>

<td align="center"><? $id[]=$rows['id']; ?><? echo $rows['id']; ?></td>

<td align="center"><input name="company[]" type="text" id="company" value="<? echo $rows['company']; ?>"></td>

<td align="center"><input name="contact[]" type="text" id="contact" value="<? echo $rows['contact']; ?>"></td>

<td align="center"><input name="email[]" type="text" id="email" value="<? echo $rows['email']; ?>"></td>

<td align="center"><input name="telephone[]" type="text" id="telephone" value="<? echo $rows['telephone']; ?>"></td>

<td align="center"><input name="type[]" type="text" id="type" value="<? echo $rows['type']; ?>"></td>

</tr>

<?php

}

?>

<tr>

<td colspan="4" align="center"><input type="submit" name="Submit" value="Submit"></td>

</tr>

</table>

</td>

</tr>

</form>

</table>

<?php

// Check if button name "Submit" is active, do this

if($Submit){

for($i=0;$i<$count;$i++){

$sql1="UPDATE $tbl_name SET company='$company[$i]', contact='$contact[$i]', email='$email[$i]',type='$type[$i]', telephone='$telephone[$i]' WHERE id='$id[$i]'";

$result1=mysql_query($sql1);

}

}

 

if($result1){

header("location:update_multiple.php");

echo "<meta http-equiv=Refresh content=0;url=update_multiple.php>";

}

mysql_close();

?>