I am having some trouble updating multiple rows at once. Below is the code. Any help is greatly appreciated.
<?php
$host="12.34.56.78"; // Host name
$username="username"; // Mysql username
$password="password"; // Mysql password
$db_name="arcola399"; // Database name
$tbl_name="availability"; // 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";
$result=mysql_query($sql);
// Count table rows
$count=mysql_num_rows($result);
?>
<br /><br />
<form name="form1" method="post" action="">
<table cellspacing="0" cellpadding="0" class="chart" align="center">
<tr class="row_head">
<td>ID</td>
<td>Suite No.</td>
<td>Level</td>
<td>Square Ft.</td>
<td>Availabilty</td>
<td>Extras</td>
</tr>
<?php
while($rows=mysql_fetch_array($result)){
?>
<tr class="row">
<td><? $id[]=$rows['ID']; ?><? echo $rows['ID']; ?></td>
<td><? echo $rows['Suite']; ?></td>
<td><input name="Level[]" type="text" id="Level" value="<? echo $rows['Level']; ?>"></td>
<td><input name="Sqft[]" type="text" id="Sqft" value="<? echo $rows['Sqft']; ?>"></td>
<td><input name="Available[]" type="text" id="Available" value="<? echo $rows['Available']; ?>"></td>
<td><input name="Extras[]" type="text" id="Extras" value="<? echo $rows['Extras']; ?>"></td>
</tr>
<?php
}
?>
</table><br /><br />
<div class="align-center"><input type="submit" name="Submit" value="Submit"></div>
</form>
<?php
// Check if button name "Submit" is active, do this
if($Submit){
for($i=0;$i<$count;$i++){
$sql1="UPDATE $tbl_name SET Level='$Level[$i]', Sqft='$Sqft[$i]', Available='$Available[$i]', Extras='$Extras[$i]' WHERE ID='$id[$i]'";
$result1=mysql_query($sql1) or die("Cannot Update");
}
}
if($result1){
header("location:index.php");
}
mysql_close();
?>