query("SELECT area,rack,location FROM Crate WHERE crateid=$crateid")){ $row = $res->fetch(); $area = $row["area"]; $rack = $row["rack"]; $location = $row["location"]; } ?>