This question already has an answer here:
I am making a table on bootstrap fetching data in this table from two table in same database here is picture of my database
here is my code i am using to fetch value from databases
<table class="table table-hover table-striped">
<thead>
<tr>
<th>Id</th>
<th>File-name</th>
<th>Purpose</th>
<th>Recieved-By </th>
<th>Processed-By</th>
<th>Address</th>
<th>Contact-No</th>
<th>Recieved-Date</th>
<th>Update-date</th>
<th>status</th>
</tr>
</thead>
<tbody>
<?php
$p_query= "SELECT id, file_name, recieved_by, processed_by, purpose, address, contact_no, date,update_date,reason FROM files INNER JOIN update_table ON files.id=update_table.id";
$con=mysqli_connect("localhost","root","","fileprogramsysteeem");
$p_run=mysqli_query($con,$p_query);
if(mysqli_num_rows($p_run)){
while($row=mysqli_fetch_array($p_run))
{
$id=$row['id'];
$file=$row['file_name'];
$purpose=$row['purpose'];
$recieve=$row['recieved_by'];
$processed=$row['processed_by'];
$address=$row['address'];
$contact=$row['contact_no'];
$date=$row['date'];
$up_date=$row['update_date'];
$status=$row['reason'];
?>
<tr>
<td><a href="post.php?post_id=<?php echo $id?>"><?php echo $id;?></a></td>
<td><a href="post.php?post_id=<?php echo $id?>"><?php echo $file;?></a></td>
<td><a href="post.php?post_id=<?php echo $id?>"><?php echo $purpose;?></a></td>
<td><a href="post.php?post_id=<?php echo $id?>"><?php echo $recieve;?></a></td>
<td><a href="post.php?post_id=<?php echo $id?>"><?php echo $processed;?></a></td>
<td><a href="post.php?post_id=<?php echo $id?>"><?php echo $address;?></a></td>
<td><a href="post.php?post_id=<?php echo $id?>"><?php echo $contact;?></a></td>
<td><a href="post.php?post_id=<?php echo $id?>"><?php echo $date;?></a></td>
<td><a href="post.php?post_id=<?php echo $id?>"><?php echo $up_date;?></a></td>
<td style="color:#337AB7;"><?php echo $id?>"><?php echo $status;?></td>
</tr>
<?php
}
}
?>
</tbody>
</table>
Now after applying this code i am getting this error :
Warning: mysqli_num_rows() expects parameter 1 to be mysqli_result
I have to select file_name, received _by, processed_by, purpose, address, contact_no, date from table files and update_date , reason from table update_table
</div>
