what do errors mean

1Tsme1941

Member
Would someone here please explain the errors with this code. It worked earlier but?
----------------------------------------
the code:
<?php
// including the database connection file
include_once("config.php");
?>
<?php
//getting id from url
$id = $_GET['id'];

//selecting data associated with this particular id
$result = mysqli_query($mysqli, "SELECT * FROM certtnl WHERE id=$id");

while($res = mysqli_fetch_array($result))// line 12
{
$unit = $res['unit'];
$tenant = $res['tenant'];
$effectdate = $res['effectdate'];
$expdate = $res['expdate'];
$moveindate = $res['moveindate'];
$removaldate = $res['removaldate'];
$daysleft = $res['daysleft'];
$date90 = $res['date90'];
$date60 = $res['date60'];
$date30 = $res['date30'];
}

?>
<html>
<head>
<title>Edit Data</title>
</head>

<body>
<a href="certup.php">Home</a>
<br><br>

<form name="form1" method="post" action="editprocess.php">
<table border="0">
<tr>
<td>Unit</td>
<td><input type="text" name="unit" value="<?php echo $unit;?>"></td>
</tr>
<tr>
<td>Tenant</td>
<td><input type="text" name="tenant" value="<?php echo $tenant;?>"></td>
</tr>
<tr>
<td>Effectdate</td>
<td><input type="text" name="effectdate" value="<?php echo $effectdate;?>"></td>
</tr>
<tr>
<td>expdate</td>
<td><input type="text" name="expdate" value="<?php echo $expdate;?>"></td>
</tr>
<tr>
<td>moveindate</td>
<td><input type="text" name="moveindate" value="<?php echo $moveindate;?>"></td>
</tr>
<tr>
<td>removaldate</td>
<td><input type="text" name="removaldate" value="<?php echo $removaldate;?>"></td>
</tr>
<tr>
<td>daysleft</td>
<td><input type="text" name="daysleft" value="<?php echo $daysleft;?>"></td>
</tr>
<tr>
<td>date90</td>
<td><input type="text" name="date90" value="<?php echo $date90;?>"></td>
</tr>
<tr>
<td>date60</td>
<td><input type="text" name="date60" value="<?php echo $date60;?>"></td>
</tr>
<tr>
<td>date30</td>
<td><input type="text" name="date30" value="<?php echo $date30;?>"></td>
</tr>
<tr>
<td><input type="hidden" name="id" value=<?php echo $_GET['id'];?>></td>
<td><input type="submit" name="update" value="Update"></td>
</tr>
</table>
</form>
</body>
</html>
----------------------------------
the result:
Warning: mysqli_fetch_array() expects parameter 1 to be mysqli_result, bool given in C:\xampp\htdocs\property\edit.php on line 12
Home

Unit
Tenant
Effectdate
expdate
moveindate
removaldate
daysleft
date90
date60
date30
 

johnb35

Administrator
Staff member
I would suggest you find a place that is designed for code to post your issues from now on. You'll get faster help and more replies. We only a few people on our forum that has any code experience. This forum used to be very popular back in the day but its not anymore.
 
Top