PHP code<?php
$sql="select C.id,C.number
from cargo1 C
left join cargo2 C2
on C.number = C2.number
left join cargo3 C3
on C.number = C3.number";
if($_SESSION['filter']){
if(ereg("^[a-zA-Z]*$",$_SESSION['auth'])){
$sql.=" where C.shipper like '%".$_SESSION['filter']."%' or C.cnee like '%".$_SESSION['filter']."%'";
}else{
$sql.=" where ucase(C.pol)='".$_SESSION['filter']."'";
}//if ereg
}//if
$sql.=" order by C.id desc";
$q=$m->query($sql);
$tb="";
while ($r=$q->fetch_array(MYSQLI_USE_RESULT)){
$tb.="
".$r[number]."".$r[shipper]."".$r[cnee]."".$r[po]."".$r[invoice]."".$r[pol]."".$r[pod]."".$r[dest]."".$r[vessel]."".$r[bookingDate]."".$r[receivedBooking]."".$r[confirmSpace]."";}
?>
編號出貨人
編號出貨人