Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- $query= mysqli_query($link, "SELECT StationaryCustomersInfo.C_ID,
- StationaryCustomersInfo.C_RequestingDate, Employees.EMP_Fname, Employees.EMP_Mname, Employees.EMP_Lname, Employees.EMP_ipPhone, Employees.EMP_officeNo FROM StationaryCustomersInfo inner join Employees WHERE EMP_ID=$i");
- while($row=mysqli_fetch_assoc($query)){
- ?>
- <br><br><table align="center" border='0' style=" line-height:30px; border-color: #020B58; font-size:25px;">
- <tr>
- <!--   it's only for add space between the HTML words -->
- <!-- one   equal one, so the number of spaces depends on the number of   you entering -->
- <th style="width:800px; text-align:right;">ID:       </th>
- <td style="width:800px;"><?php echo $row['C_ID']; ?></td>
- </tr>
- <tr>
- <th style="width:800px; text-align:right;">Name:       </th>
- <td style="width:800px;"><?php echo $row1['EMP_Fname']." ".$row1['EMP_Mname']." ".$row1['EMP_Lname'];; ?></td>
- </tr>
- <tr>
- <th style="width:800px; text-align:right;">IP Phone:       </th>
- <td style="width:800px;"><?php echo $row1['EMP_ipPhone']; ?></td>
- </tr>
- <tr>
- <th style="width:800px; text-align:right;">Office Number:       </th>
- <td style="width:800px;"><?php echo $row1['EMP_officeNo']; ?></td>
- </tr>
- <tr>
- <th style="width:800px; text-align:right;">Requesting Date:       </th>
- <td style="width:800px;"><?php echo $row['C_RequestingDate']; ?></td>
- </tr>
- <?php
- if(!$query){
- // die('Could not update data:');
- echo '<script type="text/javascript">';
- echo "There is no Informations!";
- echo ' </script>';
- }else{
- }}
- C_ID | EMP_Fname EMP_Mname EMP_Lname | EMP_ipPhone | EMP_officeNo | C_RequestingDate
- | | | |
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement