ทดลอง sqlใน phpmyadmin แล้วข้อมูลออกมา แต่พอในโค้ดไม่แสดงค่ะ
โค้ด: เลือกทั้งหมด
<?php
include '../header.php';
// if (isset($_GET['no'])) {
// $sql = "SELECT * FROM $data WHERE no = " . $_GET['no'];
// $result = mysqli_query($conn, $sql);
// $fetch = mysqli_fetch_assoc($result);
// }
//
$no = $_REQUEST['no'];
$sql1 = "SELECT no,name,money,wht,totalwht,tax,total,time,ip FROM tools_calculate_payment
INNER JOIN tools_deduction ON tools_deduction.wht_no = tools_calculate_payment.wht
where no = 'no'";
$query1 = $conn->query($sql1);
$result1 = mysqli_fetch_assoc($query1);
?>
โค้ด: เลือกทั้งหมด
<div class="row">
<h3><?php echo $lang_userinformation;?></h3>
<table id="table-listtax" class="table table-striped">
<tbody>
<tr class="active">
<td width="50%">
<p><b><?php echo $lang_no;?></b></p>
</td>
<td>
<?php echo $result1['no'] ?>
</td>
</tr>
<tr class="warning">
<td>
<p><b><?php echo $lang_name;?></b></p>
</td>
<td>
<?php echo $result1['name']; ?>
</td>
</tr>
<tr class="active">
<td>
<p><b><?php echo $lang_amount;?></b></p>
</td>
<td>
<?php echo $result1['money'];?>
</td>
</tr>
<tr class="active">
<td>
<p><b><?php echo $lang_withholdingtax;?>%</b></p>
</td>
<td>
<?php echo $result1['wht']; ?>
</td>
</tr>
<tr class="active">
<td>
<p><b><?php echo $lang_totaldeduction;?></b></p>
</td>
<td>
<?php echo $result1['totalwht']; ?>
</td>
</tr>
<tr class="warning">
<td>
<p><b><?php echo $lang_taxs;?> </b></p>
</td>
<td>
<?php echo $result1['tax']; ?>
</td>
</tr>
<tr class="active">
<td>
<p><b><?php echo $lang_interest;?></b></p>
</td>
<td>
<?php echo $result1['total']; ?>
</td>
<tr class="warning">
<td>
<p><b><?php echo $lang_textnumder." : "; ?></b></p>
</td>
<td>
<?php $textnum = ($lang == 'th') ? convert($result1['total']) : Currency::bahtEng($result1['total']) ; ?>
<?php echo $textnum ; ?>
</td>
</tr>
<tr class="active">
<td>
<p><b><?php echo $lang_activetime;?></b></p>
</td>
<td>
<?php
echo $result1['time'];
?>
</td>
</tr>
<tr class="warning">
<td>
<p><b><?php echo $lang_yoouripis;?></b></p>
</td>
<td>
<?php include 'ip.php'; ?>
</td>
</tr>
</tbody>
</table>
</div>
</div>