Table: tour

array(11) { [0]=> string(1) "1" [1]=> string(9) "Singapore" [2]=> string(7) "Bangkok" [3]=> NULL [4]=> string(5) "10380" [5]=> string(4) "5580" [6]=> string(4) "4000" [7]=> string(2) "20" [8]=> string(4) "2800" [9]=> string(4) "Rail" [10]=> string(3) "EOE" }
012345678910
1SingaporeBangkok1038055804000202800RailEOE
2SingaporeJohor39537075RailPLS
3SingaporeBatam Island0:402733FerryABF
4Kuala LumpurBangkok824044403160202220RailEOE
5SingaporeButterworth656035402500202220RailEOE
6ButterworthBangkok656035402500202220RailEOE
7SingaporeMalacca63059075RailPLS
8SingaporeBatam Island0:403040FerryCHH
9SingaporeKuala Lumpur360019601380201120RailEOE
10SingaporeBintan1:306333FerryABF
11Kuala LumpurButterworth464014801780201120RailEOE
12SingaporeMalacca196AirPLS
13SingaporeBintan1:306334FerryDSH

Table: operator

array(4) { [0]=> string(3) "EOE" [1]=> string(26) "Eastern & Oriental Express" [2]=> string(7) "2272068" [3]=> string(7) "2249265" }
0123
EOEEastern & Oriental Express22720682249265
PLSPeninsular Line Services Pte Ltd22425882241721
ABFAuto Batam Ferries27144866
CHHChannel Holidays2702228
DSHDino Shipping276922

See also: PHP PostgreSQL Functions