$wherea="IATA = '$icode' OR AGENCYNAME LIKE '%$name1%' OR AGENCYNAME LIKE '%$name2%' OR LEGALNAME LIKE '%$name1%' OR LEGALNAME LIKE '%$name2%' OR OWNERNAME LIKE '%$name1%' OR OWNERNAME LIKE '%$name2%' OR DECISIONNAME LIKE '%$name1%' OR DECISIONNAME LIKE '%$name2%' OR C1NAME LIKE '%$name1%' OR C1NAME LIKE '%$name2%' OR C2NAME LIKE '%$name1%' OR C2NAME LIKE '%$name2%' OR C3NAME LIKE '%$name1%' OR C3NAME LIKE '%$name2%' OR C4NAME LIKE '%$name1%' C4NAME OR LIKE '%$name2%' OR C5NAME LIKE '%$name1%' OR C5NAME LIKE '%$name2%' OR C6NAME LIKE '%$name1%' OR C6NAME LIKE '%$name2%' OR C7NAME LIKE '%$name1%' OR C7NAME LIKE '%$name2%' OR C8NAME LIKE '%$name1%' OR C8NAME LIKE '%$name2%' OR C9NAME LIKE '%$name1%' OR C9NAME LIKE '%$name2%'";
$wherep="NAME LIKE '%$name1% OR NAME LIKE '%$name2%'";
$wherec="NAME LIKE '%$name1% OR NAME LIKE '%$name2%' OR SECNAME LIKE '%$name1% OR SECNAME LIKE '%$name2%'";
$derrubaseexiste=mysql_query("DROP TABLE IF EXISTS templista");
$crialista=mysql_query("CREATE TABLE templista (ID int(24) NOT NULL auto_increment, AID int(24) NOT NULL, AGENCYNAME varchar(64) NOT NULL default '', LEGALNAME varchar(64) NOT NULL default '', IATA varchar(12) NOT NULL default '', OWNERNAME varchar(32) NOT NULL default '', DECISIONNAME varchar(32) NOT NULL default '', C1NAME varchar(32) NOT NULL default '', C2NAME varchar(32) NOT NULL default '', C3NAME varchar(32) NOT NULL default '', C4NAME varchar(32) NOT NULL default '', C5NAME varchar(32) NOT NULL default '', C6NAME varchar(32) NOT NULL default '', C7NAME varchar(32) NOT NULL default '', C8NAME varchar(32) NOT NULL default '', C9NAME varchar(32) NOT NULL default '', PID int(24) NOT NULL, PNAME varchar(64) NOT NULL default '', COID int(24) NOT NULL, CNAME varchar(64) NOT NULL default '', SECNAME varchar(32) NOT NULL default '', PRIMARY KEY (ID)) ENGINE=MyISAM DEFAULT CHARSET=latin1");