更新多个MySql条目

I've been working on creating an internal site for our company. I haven't had many issues until now. I have been able to retrieve and insert data into my database, but now for some reason when I try to UPDATE an entry, the database can't be selected for some strange reason. I've attached a copy of my code thus far. I don't know what I am missing. Thank you!

This is my code for looking up the information in the database:

   <?php
session_start();

$transport = mysqli_connect("localhost", "user", "pw", "db_name");

if (mysqli_connect_errno()) 
    {
        echo "Failed to connect to MySQL: " . mysqli_connect_error();
    }
?>

<?php

$raw_date = $_POST['appt_date'];
$date = date("Y-m-d", strtotime($raw_date));


if ($raw_date == '') {
    echo "Please go back and pick a date";
    exit;
}

$sql = "SELECT * FROM appointments WHERE date = '".$date."' ORDER BY appttime";

$result = mysqli_query($transport, $sql);

$i=0;

echo "<h2 align='center'>Schedule for $raw_date</h2>";

echo "<table border='2' style='width: 100%; margin: auto; border-width: 1px'><tr><th>Resident Name</th><th>APT #</th><th>Appt. Time</th><th>Location Phone</th><th>Location Name</th><th>Address</th><th>City</th><th>Zip</th><th>Bus or Car</th><th>Escort Name</th><th>Transfer</th><th>Comments</th><th>Dparting Times</th></tr>";

echo "<form name='update_times' method='post' action='depart.php'>
";
while($row = mysqli_fetch_array($result))
  {
  echo "<input type='hidden' name='id[$i]' value=" . $row['id'] . "";
  echo "<tr>";

  echo "<td align='center'>" . $row['r_name'] . "</td>";
  echo "<td align='center'>" . $row['room'] . "</td>";
  echo "<td align='center'>" . date("g:i A", strtotime($row['appttime'])) . "</td>";  
  echo "<td align='center'>" . $row['apptphone'] . "</td>";
  echo "<td align='center'>" . $row['l_name'] . "</td>";
  echo "<td align='center'>" . $row['address'] . "</td>";
  echo "<td align='center'>" . $row['city'] . "</td>";
  echo "<td align='center'>" . $row['zip'] . "</td>";
  echo "<td align='center'>" . $row['buscar'] . "</td>";
  echo "<td align='center'>" . $row['escort_name'] . "</td>";
  echo "<td align='center'>" . $row['transfer'] . "</td>";
  echo "<td align='center'>" . $row['comments'] . "</td>";
  echo "<td align='center'><input name='out[$i]' style='width: 70px' type='text' value='" . date("g:i A", strtotime($row['depart'])) . "' /></td>";
  echo "</tr>";
  ++$i;  
  }

echo "<input type='submit' value='Set Depart Times'>";
echo "</form>";
echo "</table>";

$_SESSION['sessionVar'] = $raw_date;


?>

This is the update code:

<?php
session_start();

$transport = mysqli_connect('localhost', 'user', 'pw', 'db_name');

if (mysqli_connect_errno()) 
    {
        echo "Failed to connect to MySQL: " . mysqli_connect_error();
    }
?>

<?php
$size = count($_POST['out']);

$i=0;
while ($i < $size)
{
    $departing = $_POST['out'][$i];
    $departing = date("H:i:s:u",strtotime($departing));
    $id = $_POST['id'][$i];

    $sql = "UPDATE transport.appointments SET depart = $departing WHERE id = $id";
    mysqli_query($transport, $sql) or die ("Error in query: $sql");
    echo "Depart times updated!";
    ++$i;

}

mysql_close($transport);
?>

For some reason the update code doesn't want to select my database. Thank you again!

The MySQL UPDATE syntax is:

UPDATE table_name SET column1=value1,column2=value2,... WHERE some_column=some_value;

It looks like you've tried to reference your database and your table in the UPDATE query: transport.appointments. I might be wrong, but I can't find anything on the internet saying that is valid syntax.

Try just referencing the table:

$sql = "UPDATE appointments SET depart = $departing WHERE id = $id";