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:
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 ;
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.
