fu

".$row["imonumber"].""; } echo "
Search:"; echo " "; echo ""; echo "
"; $display=""; #$display.=""; $display.=""; $display.=""; $display.=""; $display.=""; $display.=""; #$display.=""; $display.=""; $p=$_GET["imonumber"]; if($_GET["submit"]=="Submit Query") { $query1="SELECT DISTINCT bwt.imonumber, s.shipname, bwt.date, p.arrivalport, bwt.port_uid, s.flag FROM ballast_water_tanks bwt, ship s, port p WHERE bwt.imonumber = s.imonumber AND p.imonumber = bwt.imonumber AND p.arrivaldate = bwt.date AND bwt.imonumber = '$p' ORDER BY bwt.date DESC"; $result=mysql_query($query1); $result1=mysql_num_rows($result); #echo $result1; while($row=mysql_fetch_array($result)) { $display.=""; //$display.=""; $display.=""; $display.=""; $display.=""; $display.=""; $display.=""; #$display.=""; $display.=""; $imonumber=$imonumber.""; } $display.="
Sr.No.
IMO NumberShip NameArrival DateFlagArrivalportPort IdAction
".$row["imonumber"]."".$row["shipname"]."".$row["date"]."".$row["flag"]."".$row["arrivalport"]."".$row["port_uid"]."view
"; echo($display); } else { $q="SELECT DISTINCT bwt.imonumber, s.shipname, bwt.date, p.arrivalport, bwt.port_uid, s.flag FROM ballast_water_tanks bwt, ship s, port p WHERE bwt.imonumber = s.imonumber AND p.imonumber = bwt.imonumber AND p.arrivaldate = bwt.date ORDER BY bwt.date DESC LIMIT 0,49"; $res=mysql_query($q); $resnum=mysql_num_rows($res); while($r=mysql_fetch_array($res)) { $display.=""; # $display.="no"; $display.="".$r["imonumber"].""; $display.="".$r["shipname"].""; $display.="".$r["date"].""; $display.="".$r["flag"].""; $display.="".$r["arrivalport"].""; #$display.="".$r["port_uid"].""; $display.="view"; } $display.=""; echo($display); } ?>