TABLE camRun, camProcessedExp, chipRun, rawExp, chipProcessedImfile
TITLE Camera Processed
FILE  camProcessedExp.php
MENU  ipp.science.dat

# the following WHERE clauses are added to all queries joined by AND
WHERE camRun.state = 'stop'
WHERE camRun.chip_id = chipRun.chip_id
WHERE chipRun.exp_id = rawExp.exp_id
WHERE camProcessedExp.cam_id = camRun.cam_id
WHERE camProcessedExp.chip_id = camRun.chip_id
WHERE chipProcessedImfile.chip_id = camRun.chip_id

#     field                     	size  name          show   	 link to                  extras
FIELD camRun.cam_id,            	 5,   cam ID,       value
FIELD chipRun.chip_id,          	 5,   chip ID
FIELD rawExp.exp_id,	        	 5,   exposure ID,  value
FIELD rawExp.exp_name,     		 5,   Exp Name,     value
FIELD rawExp.telescope,      		10,   Telescope
FIELD rawExp.camera,         		10,   Camera
FIELD chipProcessedImfile.bg,            5,   backgnd
FIELD chipProcessedImfile.bg_stdev,      5,   stdev    
FIELD chipProcessedImfile.bg_mean_stdev, 5,   &lt;backgnd&gt;
FIELD chipProcessedImfile.n_stars,  	 5,   Nstars
FIELD chipProcessedImfile.n_astrom, 	 5,   Nastrom
FIELD chipProcessedImfile.sigma_ra, 	 5,   sigma ra
FIELD chipProcessedImfile.fwhm,     	 5,   FHWM

TAIL PHP insert_image ('PPIMAGE.JPEG1');
TAIL PHP insert_log ('LOG.EXP');
