argh hesa!\n"); echo ("
query is \"$query_inst\"\n"); exit; } $row = mysql_fetch_array ($result); $name = $row['name']; $where_uoa = "rae_res.HESAcode='$hesa' AND rae_res.UOA=rae_uoa.UOA"; $query_uoa = "SELECT * from rae_res, rae_uoa WHERE $where_uoa ORDER BY rae_res.UOA"; $result = mysql_query($query_uoa); if ( ! $result ) { echo ("argh uoa!\n"); echo ("
query is \"$query_uoa\"\n"); exit; } $nos = mysql_num_rows($result); ?>
| UOA | UOA name | rating | prop | RAS FTE | $uoa | "); echo("$uoaname | "); echo("$rating | "); echo("$prop | "); echo("$rasfte | "); echo("\n"); } ?>
|---|
| example script uoalist.php from http://www.meandeviation.com/rae/ | Alan Dix © 2003 |