根据它们是否为0或1来制作两个表

essentially I want to have two tables one with everyone with Confirmed = 1 and the other with Confirmed = 0.

I have this sql query at the moment

 $result = mysqli_query($con,"SELECT * FROM tbl_booking WHERE $row[Confirmed] = 1");

but I keep getting

Notice: Undefined variable: row in C:\xampp\htdocs\test.php on line 19

Warning: mysqli_fetch_array() expects parameter 1 to be mysqli_result, boolean given in

rest of the code for that page

echo "<table border='1'>
<tr>
<th>ID</th>
<th>BookID</th>
<th>date</th>
<th>time</th>
<th>confirmed?</th>
</tr>";


while($row = mysqli_fetch_array($result) )
  { ?>
   <tr>
   <td> <?php echo $row['tbl_mem_id']; ?> </td>
   <td> <?php echo $row['BookID']; ?> </td>
   <td> <?php echo $row['date']; ?> </td>
   <td> <?php echo $row['time']; ?> </td>
   <td> <?php echo $row['Confirmed']; ?> </td>
   <td> <a href=delete.php?BookID=<?php echo $row['BookID']; ?> </a> Delete </td>
   <td> 
       <?php
       if ($row['Confirmed'] == 0) { ?>
       <a href=confirm.php?BookID=<?php echo $row['BookID']; ?> </a> Confirm </td> <?php } else { ?>
       <a href=deny.php?BookID=<?php echo $row['BookID']; ?> </a> Deny </td> <?php
       } ?>
   </tr> <?php
  } ?>
</table>

Are you really trying to put the value in $row['Confirmed'] in the query, or are you just trying to query a field named Confirmed? if its the latter try this:

$result = mysqli_query($con,"SELECT * FROM tbl_booking WHERE Confirmed= 1");

but since also you seem to differentiate the table in php with if ($row['Confirmed'] == 0) you probably need to get all data in one query with this:

$result = mysqli_query($con,"SELECT * FROM tbl_booking");

this won't give you 2 tables as you initially asked for though.

you can create 2 html tables with this:

<?php
$result = mysqli_query($con,"SELECT * FROM tbl_booking WHERE Confirmed = 1");
echo "<table border='1'>
<tr>
<th>ID</th>
<th>BookID</th>
<th>date</th>
<th>time</th>
<th>confirmed?</th>
</tr>";


while($row = mysqli_fetch_array($result) )
  { ?>
   <tr>
   <td> <?php echo $row['tbl_mem_id']; ?> </td>
   <td> <?php echo $row['BookID']; ?> </td>
   <td> <?php echo $row['date']; ?> </td>
   <td> <?php echo $row['time']; ?> </td>
   <td> <?php echo $row['Confirmed']; ?> </td>
   <td> <a href=delete.php?BookID=<?php echo $row['BookID']; ?> </a> Delete </td>
   <td> 

       <a href=deny.php?BookID=<?php echo $row['BookID']; ?> </a> Deny </td>

   </tr> <?php
  } ?>
</table>
<?php
echo "<table border='1'>
<tr>
<th>ID</th>
<th>BookID</th>
<th>date</th>
<th>time</th>
<th>confirmed?</th>
</tr>";

$result = mysqli_query($con,"SELECT * FROM tbl_booking WHERE Confirmed = 0 ");    
while($row = mysqli_fetch_array($result) )
  { ?>
   <tr>
   <td> <?php echo $row['tbl_mem_id']; ?> </td>
   <td> <?php echo $row['BookID']; ?> </td>
   <td> <?php echo $row['date']; ?> </td>
   <td> <?php echo $row['time']; ?> </td>
   <td> <?php echo $row['Confirmed']; ?> </td>
   <td> <a href=delete.php?BookID=<?php echo $row['BookID']; ?> </a> Delete </td>
   <td> 
       <a href=confirm.php?BookID=<?php echo $row['BookID']; ?> </a> Confirm </td>
   </tr> <?php
  } ?>
</table>