php - 将不同的数据插入两个表中

Question

我正在尝试将一些数据插入到一个表中，成功后我希望更新另一个表中的一个字段。我的代码如下:

 <?php

$room = $_REQUEST['room'];
$date = $_REQUEST['date'];
$time = $_REQUEST['time'];
$id = $_GET['meeting_id'];

$con = mysql_connect("******","****","****");
if (!$con)
  {
  die('Could not connect: ' . mysql_error());
  }

mysql_select_db('mdb_hj942', $con);

$sql="INSERT INTO Rooms (room, date, time, meeting_id) VALUES ('$room','$date', '$time','$id')";
$sql2="UPDATE Meetings SET action = 'success'";

if (!mysql_query($sql,$con,$sql2))
  {
        die('Error: ' . mysql_error());
  }
  else 
  {
      echo '<h2>Room & Time Has Now Been Updated</h2>';

  }
?>

这可能吗？如果是这样，当我收到以下错误消息时，我应该进行哪些更改:

'Warning: Wrong parameter count for mysql_query() in E:\webareas\hj942\conference\Secretary\bookedsuccessfully.php on line 80
Error: '

Answer 1

if (!mysql_query($sql, $con)){
  die('Error: ' . mysql_error());
} else {
  if (!mysql_query($sql2, $con)){
    die('Error: ' . mysql_error());
  } else {
    echo '<h2>Room & Time Has Now Been Updated</h2>';
  }
}