<?php $mysql5 = mysqli_query($dbc, "SELECT * FROM tickets where status='1' ORDER BY dt DESC LIMIT 6 "); if($indtbl = mysqli_fetch_array($mysql5)) { $title = $indtbl['tickettitle']; $company = $indtbl['companyname']; $companyid =$indtbl['compid']; $trackid = $indtbl['trackid']; $assignto = $indtbl['assignto']; $priority = $indtbl['priority']; } ?>
<?php $findresults2323 = mysqli_query($dbc, "SELECT * FROM users WHERE id= '$assignto'"); if($rest = mysqli_fetch_array($findresults2323)) { $userimg = $rest['img']; $fname1 = $rest['fname']; $lname1 = $rest['lname']; } ?>
<table class="table table-hoverable"> <thead> <tr> <th class="text-left">Title</th> <th>Company</th> <th>Ticket ID</th> <th>Assign To</th> <th>Priority</th> </tr> </thead> <?php while($rowten = mysqli_fetch_array($mysql5)) { $retrive11 = mysqli_fetch_array($findresults2323); ?> <tr> <td><a href="readit.php?id=<?php echo $rowten["id"];?>"><?php echo $rowten["tickettitle"]; ?></td> <td><a href="readit.php?id=<?php echo $rowten["id"];?>"><?php echo $rowten["companyname"];?> <?php echo $rowten["compid"];?></td> <td><a href="readit.php?id=<?php echo $rowten["id"];?>"><?php echo $rowten["trackid"]; ?></td> <td><a href="readit.php?id=<?php echo $rowten["id"];?>"><?php echo $retrive11['fname'];?></td> <td><a href="readit.php?id=<?php echo $rowten["id"];?>"><?php echo $rowten["priority"]; ?></td> </tr> <?php } ?> </table>
Notice: Trying to access array offset on value of type null in C:\xampp\htdocs\Ticketing\demo\index.php on line 459
<td><a href="readit.php?id=<?php echo $rowten["id"];?>"><?php echo $retrive11['fname'];?></td>
"SELECT * FROM users WHERE id= '$assignto'"
$retrive11 = mysqli_fetch_array($findresults2323);
retrive11
var
This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)