I’m the CEO and President of a Virtual Airline. (A non-profit organization where people come together and fly on a simulator such as Microsoft Flight Simulator.) I have a table:
[php]
CREATE TABLE IF NOT EXISTS pireps (
ID int(11) NOT NULL auto_increment,
PilotID varchar(7) collate latin1_general_ci NOT NULL,
Flight# varchar(7) collate latin1_general_ci NOT NULL,
From varchar(4) collate latin1_general_ci NOT NULL,
To varchar(4) collate latin1_general_ci NOT NULL,
Fuel decimal(10,0) NOT NULL,
FlightTime decimal(10,0) NOT NULL,
Aircraft varchar(50) collate latin1_general_ci NOT NULL,
Comments varchar(500) collate latin1_general_ci default NULL,
Accepted int(1) NOT NULL default ‘0’,
Pending int(1) NOT NULL default ‘1’,
Denied int(1) NOT NULL default ‘0’,
PRIMARY KEY (ID)
) ENGINE=MyISAM DEFAULT CHARSET=latin1 COLLATE=latin1_general_ci AUTO_INCREMENT=2 ;
[/php]
and I’m worndering how to show the PIREP’s (PIlot REPorts) that are relivent to that pilot only. I hope that I don’t sound to confusing. Thanks for the help in advance. I also have a lot more things, but this is mostly the major one.