MySQL PHP Script request

dflowers · #1 (**permalink**) 04-26-06, 01:17 AM

Hello, I am in need of a PHP script that can be used to insert data, and update data in a MySQL database. I know there are several available on the net, but specifically I need to be able to format form used for inserting, editing, and viewing the data using HTML table tags, such as td tr, etc. Also, I need the script to upload and assign unique IDs to images and pdf files. Further more, the image files need to be automatically resized to 350 x 350. I currently have a form that I have formatted that can be used to enter new records, but that is all I have come up with. This script is to help my fire department to enter and maintain our preplan database. I am willing to pay someone to develop this script for me although my funds are limited as the fire department cannot afford to apy for this service and I will have to pay for it out of my pocket. Any Help would be appreciated. Below is what I have so far:

<?php
if ($submit):
include '/usr/local/psa/home/vhosts/youraddress.com/httpdocs/preplandb/config.php';
include '/usr/local/psa/home/vhosts/youraddress.com/httpdocs/preplandb/opendb.php';

$sql = "INSERT INTO PreplanMain SET " .
"Occupant='$Occupant', " .
"Address1='$Address1', " .
"Address2='$Address2', " .
"City='$City', " .
"State='$State', " .
"ZipCode='$ZipCode', " .
"Phone='$Phone', " .
"Fax='$Fax', " .
"BusinessType='$BusinessType', " .
"ConstructionClass='$ConstructionClass', " .
"RoofConstruction='$RoofConstruction', " .
"NumberStories='$NumberStories', " .
"Length='$Length', " .
"Width='$Width', " .
"Height='$Height', " .
"RoofCovering='$RoofCovering', " .
"StructureNotes='$StructureNotes', " .
"MainAccess='$MainAccess', " .
"RoofAccess='$RoofAccess', " .
"KBPresent='$KBPresent', " .
"KBLocation='$KBLocation', " .
"AlarmPanelLocation='$AlarmPanelLocation', " .
"BusinessHours='$BusinessHours', " .
"AccessNotes='$AccessNotes', " .
"Hydrant1='$Hydrant1', " .
"Hydrant2='$Hydrant2', " .
"WaterPoint1='$WaterPoint1', " .
"WaterPoint2='$WaterPoint2', " .
"Sprinklers='$Sprinklers', " .
"SprinklerControl='$SprinklerControl', " .
"FDC='$FDC', " .
"FDCLocation='$FDCLocation', " .
"Standpipe='$Standpipe', " .
"StandpipeLocation='$StandpipeLocation', " .
"Gas='$Gas', " .
"GasType='$GasType', " .
"GasSOLocation='$GasSOLocation', " .
"ElectricalSOLocation='$ElecetricalSOLocation' , " .
"WaterSOLocation='$WaterSOLocation', " .
"ProtectionNotes='$ProtectionNotes', " .
"Staging1='$Staging1', " .
"Staging2='$Staging2', " .
"MANotes='$MANotes', " .
"PagerID3='$PagerID3', " .
"MaterialName1='$MaterialName1', " .
"UNID1='$UNID1', " .
"ERGID1='$ERGID1', " .
"Location1='$Location1', " .
"Quantity1='$Quantity1', " .
"MSDS1='$MSDS1', " .
"MaterialName2='$MaterialName2', " .
"UNID2='$UNID2', " .
"ERGID2='$ERGID2', " .
"Location2='$Location2', " .
"Quantity2='$Quantity2', " .
"MSDS2='$MSDS2', " .
"MaterialName3='$MaterialName3', " .
"UNID3='$UNID3', " .
"ERGID3='$ERGID3', " .
"Location3='$Location3', " .
"Quantity3='$Quantity3', " .
"MSDS3='$MSDS3', " .
"MaterialName4='$MaterialName4', " .
"UNID4='$UNID4', " .
"ERGID4='$ERGID4', " .
"Location4='$Location4', " .
"Quantity4='$Quantity4', " .
"MSDS4='$MSDS4', " .
"ContactName1='$ContactName1', " .
"Title1='$Title1', " .
"WorkPhone1='$Workphone1', " .
"HomePhone1='$HomePhone1', " .
"CellPhone1='$CellPhone1', " .
"Pager1='$Pager1', " .
"PagerID1='$PagerID1', " .
"ContactName2='$ContactName2', " .
"Title2='$Title2', " .
"WorkPhone2='$Workphone2', " .
"HomePhone2='$HomePhone2', " .
"CellPhone2='$CellPhone2', " .
"Pager2='$Pager2', " .
"PagerID2='$PagerID2', " .
"ContactName3='$ContactName3', " .
"Title3='$Title3', " .
"WorkPhone3='$Workphone3', " .
"HomePhone3='$HomePhone3', " .
"CellPhone3='$CellPhone3', " .
"Pager3='$Pager3', " .
"Plot='$Plot', " .
"SideA='$SideA', " .
"SideB='$SideB', " .
"SideC='$SideC', " .
"SideD='$SideD', " .
"PRoof='$PRoof', " .
"POther='$POther', " .
"Floor1='$Floor1', " .
"Floor2='$Floor2', " .
"Floor3='$Floor3', " .
"Floor4='$Floor4', " .
"SpecialNotes='$SpecialNotes'";
if (mysql_query($sql)) { echo("<P><B>Preplan Added</B></P><A HREF='index.php'>Add Another Preplan</A>

");
} else {
echo("<P>Error adding new record: " .
mysql_error() . "</P>"); }
?>

<?php else: // Enter another record?>

<FORM NAME="PREPLAN" METHOD=POST>

<P><B><FONT SIZE="4">Please enter preplan information below</FONT></B><BR>
<TABLE border=1 cellpadding=2 cellspacing=2 width="700">
<TR><TD colspan="4" BGCOLOR="#cccccc"><center><b>Business Name:
<INPUT TYPE=TEXT NAME="Occupant" SIZE=75MAXLENGTH=100></b></center></td></tr>
<TR><TD Width="350"><FONT SIZE=2 FACE="Arial"><b>Address:</b>
<INPUT TYPE=TEXT NAME="Address1" SIZE=75MAXLENGTH=100><br><b>Unit/Suite:</b>
<INPUT TYPE=TEXT NAME="Address2" SIZE=75MAXLENGTH=100><br><b>City:</b>
<input type=TEXT name="City" size=75MAXLENGTH=100><br><b>State:</b>
<select NAME="State" size="1">
<option>--</option>
<option>AL</option>
<option>AK</option>
<option>AZ</option>
<option>AR</option>
<option>CA</option>
<option>CO</option>
<option>CT</option>
<option>DE</option>
<option>FL</option>
<option>GA</option>
<option>HI</option>
<option>ID</option>
<option>IL</option>
<option>IN</option>
<option>IA</option>
<option>KS</option>
<option>KY</option>
<option>LA</option>
<option>ME</option>
<option>MD</option>
<option>MA</option>
<option>MI</option>
<option>MN</option>
<option>MS</option>
<option>MO</option>
<option>MT</option>
<option>NE</option>
<option>NV</option>
<option>NH</option>
<option>NJ</option>
<option>NM</option>
<option>NY</option>
<option selected>NC</option>
<option>ND</option>
<option>OH</option>
<option>OK</option>
<option>OR</option>
<option>PA</option>
<option>RI</option>
<option>SC</option>
<option>SD</option>
<option>TN</option>
<option>TX</option>
<option>UT</option>
<option>VT</option>
<option>VA</option>
<option>WA</option>
<option>WV</option>
<option>WI</option>
<option>WY</option>
</select><br><b>Zipcode:</b>
<input type=TEXT name="ZipCode" size=10MAXLENGTH=10></FONT></TD>
<TD Width="350"><FONT SIZE=2 FACE="Arial"><b>Phone:</b>
<INPUT TYPE=TEXT NAME="Phone" SIZE=75MAXLENGTH=100><br><b>Fax: </b><INPUT TYPE=TEXT NAME="Fax" SIZE=75MAXLENGTH=100><br><b>Business Type: </b><INPUT TYPE=TEXT NAME="BusinessType" SIZE=75MAXLENGTH=100><br><b>Business Hours: </b><INPUT TYPE=TEXT NAME="BusinessHours" SIZE=75MAXLENGTH=100></FONT></TD>
</TR>
<TR><TD width="350" BGCOLOR="#cccccc"><FONT SIZE=2 FACE="Arial"><center><b>STRUCTURE</b></center></FONT></TD><TD width="350" BGCOLOR="#cccccc"><FONT SIZE=2 FACE="Arial"><center><b>ACCESS</b></center></FONT></TD>
</TR>
<TR><TD width="350"><FONT SIZE=2 FACE="Arial"><b>Construction Class:</b> <select NAME="ConstructionClass" size="1">
<option>--</option>
<option>Fire Resistive</option>
<option>Non Combustible</option>
<option>Heavy Timber</option>
<option>Ordinary</option>
<option>Wood Frame</option>
</select><br><b>Roof Construction:</b> <INPUT TYPE=TEXT NAME="RoofConstruction" SIZE=75MAXLENGTH=100><br><b>Roof Covering:</b> <INPUT TYPE=TEXT NAME="RoofCovering" SIZE=75MAXLENGTH=100><br><b>Length:</b> <INPUT TYPE=TEXT NAME="Length" SIZE=75MAXLENGTH=100><br><b>Width:</b> <INPUT TYPE=TEXT NAME="Width" SIZE=75MAXLENGTH=100><br><b>Height:</b> <INPUT TYPE=TEXT NAME="Height" SIZE=75MAXLENGTH=100><br><b>Number of Stories:</b> <INPUT TYPE=TEXT NAME="NumberStories" SIZE=75MAXLENGTH=100></FONT></TD><TD width="350"><FONT SIZE=2 FACE="Arial"><b>Main Access:</b> <INPUT TYPE=TEXT NAME="MainAccess" SIZE=75MAXLENGTH=100><br><b>Roof Access:</b> <INPUT TYPE=TEXT NAME="RoofAcces" SIZE=75MAXLENGTH=100><br><b>Knox Box Present:</b> <select NAME="KBPresent" size="1">
<option>--</option>
<option>Yes</option>
<option>No</option>
</select><br><b>Knox Box Location:</b> <INPUT TYPE=TEXT NAME="KBLocation" SIZE=75MAXLENGTH=100><br><b>Alarm Panel Location:</b> <INPUT TYPE=TEXT NAME="AlarmPanelLocation" SIZE=75MAXLENGTH=100></FONT></TD></TR>
<TR><TD colspan="4" BGCOLOR="#cccccc"><FONT SIZE=2 FACE="Arial"><center><b> WATER SUPPLY</b></center></FONT></TD></TR>
<TR><TD colspan="4"><FONT SIZE=2 FACE="Arial"><b> Hydrant Location 1:</b> <INPUT TYPE=TEXT NAME="Hydrant1" SIZE=75MAXLENGTH=100><b><br> Hydrant Location 2:</b> <INPUT TYPE=TEXT NAME="Hydrant2" SIZE=75MAXLENGTH=100><br><b> Water Point Location 1:</b> <INPUT TYPE=TEXT NAME="WaterPoint1" SIZE=75MAXLENGTH=100><b><br> Water Point Location 2:</b> <INPUT TYPE=TEXT NAME="WaterPoint2" SIZE=75MAXLENGTH=100></FONT></TD></TR>
<TR><TD colspan="4" BGCOLOR="#cccccc"><FONT SIZE=2 FACE="Arial"><center><b>FIRE PROTECTION SYSTEMS</b></center></FONT></TD></TR>
<TR><TD width="350" BGCOLOR="#ccffff"><FONT SIZE=2 FACE="Arial"><center><b>SPRINKLER SYSTEM</b></center></FONT></TD><TD width="350" BGCOLOR="#ccffff"><FONT SIZE=2 FACE="Arial"><center><b>FIRE DEPARTMENT CONNECTION</b></center></FONT></TD></TR>
<TR><TD width="350"><FONT SIZE=2 FACE="Arial"><b>Sprinkler System Present:</b> <select NAME="Sprinklers" size="1">
<option>--</option>
<option>Yes</option>
<option>No</option>
</select><br> <b>Shut Off Location:</b> <INPUT TYPE=TEXT NAME="SprinklerControl" SIZE=75MAXLENGTH=100></FONT></TD><TD width="350"><FONT SIZE=2 FACE="Arial"><b>FDC Present:</b> <select NAME="FDC" size="1">
<option>--</option>
<option>Yes</option>
<option>No</option>
</select><br><b>FDC Shut Off Location:</b> <INPUT TYPE=TEXT NAME="FDCLocation" SIZE=75MAXLENGTH=100></FONT></TD></TR>
<TR><TD width="350" BGCOLOR="#ccffff"><FONT SIZE=2 FACE="Arial"><center><b>STANDPIPE SYSTEM</b></center></FONT></TD><TD width="350" BGCOLOR="#ccffff"><FONT SIZE=2 FACE="Arial"><center><b>GAS CONNECTIONS</b></center></FONT></TD></TR>
<TR><TD width="350"><FONT SIZE=2 FACE="Arial"><b>Standpipe System Present:</b> <select NAME="Standpipe" size="1">
<option>--</option>
<option>Yes</option>
<option>No</option>
</select><br> <b>Locations:</b> <INPUT TYPE=TEXT NAME="StandpipeLocation" SIZE=75MAXLENGTH=100></FONT></TD><TD width="350"><FONT SIZE=2 FACE="Arial"><b>Gas Present:</b> <select NAME="Gas" size="1">
<option>--</option>
<option>Yes</option>
<option>No</option>
</select><br> <b>Gas Type:</b> <select NAME="GasType" size="1">
<option>--</option>
<option>Natural</option>
<option>Propane</option>
</select><br> <b>Gas Shut Off Location:</b> <INPUT TYPE=TEXT NAME="GasSOLocation" SIZE=75MAXLENGTH=100></FONT></TD></TR>
<TR><TD width="350" BGCOLOR="#ccffff"><FONT SIZE=2 FACE="Arial"><center><b>ELECTRICAL</b></center></FONT></TD><TD width="350" BGCOLOR="#ccffff"><FONT SIZE=2 FACE="Arial"><center><b>WATER</b></center></FONT></TD></TR>
<TR><TD width="350"><FONT SIZE=2 FACE="Arial"><b>Electrical Shut Off Location:</b> <INPUT TYPE=TEXT NAME="ElectricalSOLocation" SIZE=75MAXLENGTH=100></FONT></TD><TD width="350"><FONT SIZE=2 FACE="Arial"><b>Water Shut Off Location:</b> <INPUT TYPE=TEXT NAME="WaterSOLocation" SIZE=75MAXLENGTH=100></FONT></TD></TR>
<TR><TD colspan="4" BGCOLOR="#cccccc"><FONT SIZE=2 FACE="Arial"><center><b>HAZMAT</b></center></FONT></TD></TR>
<TR><TD width="350" BGCOLOR="#ccffff"><FONT SIZE=2 FACE="Arial"><center><b>Chemcial: </b><INPUT TYPE=TEXT NAME="MaterialName1" SIZE=75MAXLENGTH=100> </center></FONT></TD><TD width="350" BGCOLOR="#ccffff"><FONT SIZE=2 FACE="Arial"><center><b>Chemical:</b> <INPUT TYPE=TEXT NAME="MaterialName2" SIZE=75MAXLENGTH=100></center></FONT></TD></TR>
<TR><TD width="350"><FONT SIZE=2 FACE="Arial"><b>UN ID#:</b> <INPUT TYPE=TEXT NAME="UNID1" SIZE=75MAXLENGTH=100><br><b>ERG Guide#:</b> <INPUT TYPE=TEXT NAME="ERGID1" SIZE=75MAXLENGTH=100><br><b>Location:</b> <INPUT TYPE=TEXT NAME="Location1" SIZE=75MAXLENGTH=100><br><b>Amount:</b> <INPUT TYPE=TEXT NAME="Quantity1" SIZE=75MAXLENGTH=100><br><b>MSDS:</b> <INPUT TYPE=TEXT NAME="MSDS1" SIZE=75MAXLENGTH=100></FONT></TD><TD width="350"><FONT SIZE=2 FACE="Arial"><b>UN ID#:</b> <INPUT TYPE=TEXT NAME="UNID2" SIZE=75MAXLENGTH=100><br><b>ERG Guide#:</b> <INPUT TYPE=TEXT NAME="ERGID2" SIZE=75MAXLENGTH=100><br><b>Location:</b> <INPUT TYPE=TEXT NAME="Location2" SIZE=75MAXLENGTH=100><br><b>Amount:</b> <INPUT TYPE=TEXT NAME="Quantity2" SIZE=75MAXLENGTH=100><br><b>MSDS:</b> <INPUT TYPE=TEXT NAME="MSDS2" SIZE=75MAXLENGTH=100></FONT></TD></TR>
<TR><TD width="350" BGCOLOR="#ccffff"><FONT SIZE=2 FACE="Arial"><center><b>Chemical:</b> <INPUT TYPE=TEXT NAME="MaterialName3" SIZE=75MAXLENGTH=100></center></FONT></TD><TD width="350" BGCOLOR="#ccffff"><FONT SIZE=2 FACE="Arial"><center><b>Chemical:</b> <INPUT TYPE=TEXT NAME="MaterialName4" SIZE=75MAXLENGTH=100></center></FONT></TD></TR>
<TR><TD width="350"><FONT SIZE=2 FACE="Arial"><b>UN ID#:</b> <INPUT TYPE=TEXT NAME="UNID3" SIZE=75MAXLENGTH=100><br><b>ERG Guide#:</b> <INPUT TYPE=TEXT NAME="ERGID3" SIZE=75MAXLENGTH=100><br><b>Location:</b> <INPUT TYPE=TEXT NAME="Location3" SIZE=75MAXLENGTH=100><br><b>Amount:</b> <INPUT TYPE=TEXT NAME="Quantity3" SIZE=75MAXLENGTH=100><br><b>MSDS:</b> <INPUT TYPE=TEXT NAME="MSDS3" SIZE=75MAXLENGTH=100></FONT></TD><TD width="350"><FONT SIZE=2 FACE="Arial"><b>UN ID#:</b> <INPUT TYPE=TEXT NAME="UNID4" SIZE=75MAXLENGTH=100><br><b>ERG Guide#:</b> <INPUT TYPE=TEXT NAME="ERGID4" SIZE=75MAXLENGTH=100><br><b>Location:</b> <INPUT TYPE=TEXT NAME="Location4" SIZE=75MAXLENGTH=100><br><b>Amount:</b> <INPUT TYPE=TEXT NAME="Quantity4" SIZE=75MAXLENGTH=100><br><b>MSDS:</b> <INPUT TYPE=TEXT NAME="MSDS4" SIZE=75MAXLENGTH=100></FONT></TD></TR>
<TR><TD colspan="4" BGCOLOR="#cccccc"><FONT SIZE=2 FACE="Arial"><center><b>STRATGIES & NOTES</b></center></FONT></TD></TR>
<TR><TD colspan="4"><FONT SIZE=2 FACE="Arial"><b>Level 1 Staging:</b> <INPUT TYPE=TEXT NAME="Staging1" SIZE=75MAXLENGTH=100><br><b>Level 2 Staging:</b> <INPUT TYPE=TEXT NAME="Staging2" SIZE=75MAXLENGTH=100><br><b>Mutual Aid Notes:</b> <INPUT TYPE=TEXT NAME="MANotes" SIZE=150MAXLENGTH=500><br><b>Protection System Notes:</b> <INPUT TYPE=TEXT NAME="ProtectionNotes" SIZE=150MAXLENGTH=500><br><b>Access Notes:</b> <INPUT TYPE=TEXT NAME="AccessNotes" SIZE=75MAXLENGTH=100><br><b>Structure Notes:</b> <INPUT TYPE=TEXT NAME="StructureNotes" SIZE=150MAXLENGTH=500><br></FONT></TD></TR>
<TR><TD colspan="4" BGCOLOR="#cccccc"><FONT SIZE=2 FACE="Arial"><center><b>CONTACTS</b></center></FONT></TD></TR>
<TR><TD width="350"><FONT SIZE=2 FACE="Arial"><b>Name:</b> <INPUT TYPE=TEXT NAME="ContactName1" SIZE=75MAXLENGTH=100><br> <b>Title:</b> <INPUT TYPE=TEXT NAME="Title1" SIZE=75MAXLENGTH=100><br><b>Work Phone:</b> <INPUT TYPE=TEXT NAME="WorkPhone1" SIZE=75MAXLENGTH=100><br> <b>Home Phone:</b> <INPUT TYPE=TEXT NAME="HomePhone1" SIZE=75MAXLENGTH=100><br> <b>Cell Phone:</b> <INPUT TYPE=TEXT NAME="CellPhone1" SIZE=75MAXLENGTH=100><br> <b>Pager Phone:</b> <INPUT TYPE=TEXT NAME="Pager1" SIZE=75MAXLENGTH=100><br> <b>Pager ID:</b> <INPUT TYPE=TEXT NAME="PagerID1" SIZE=75MAXLENGTH=100></FONT></TD><TD width="350"><FONT SIZE=2 FACE="Arial"><b>Name:</b> <INPUT TYPE=TEXT NAME="ContactName2" SIZE=75MAXLENGTH=100><br> <b>Title:</b> <INPUT TYPE=TEXT NAME="Title2" SIZE=75MAXLENGTH=100><br><b>Work Phone:</b> <INPUT TYPE=TEXT NAME="WorkPhone2" SIZE=75MAXLENGTH=100><br> <b>Home Phone:</b> <INPUT TYPE=TEXT NAME="HomePhone2" SIZE=75MAXLENGTH=100><br> <b>Cell Phone:</b> <INPUT TYPE=TEXT NAME="CellPhone2" SIZE=75MAXLENGTH=100><br> <b>Pager Phone:</b> <INPUT TYPE=TEXT NAME="Pager2" SIZE=75MAXLENGTH=100><br> <b>Pager ID:</b> <INPUT TYPE=TEXT NAME="PagerID1" SIZE=75MAXLENGTH=100></FONT></TD></TR>
<TR><TD width="350"><FONT SIZE=2 FACE="Arial"><b>Name:</b> <INPUT TYPE=TEXT NAME="ContactName3" SIZE=75MAXLENGTH=100><br> <b>Title:</b> <INPUT TYPE=TEXT NAME="Title3" SIZE=75MAXLENGTH=100><br><b>Work Phone:</b> <INPUT TYPE=TEXT NAME="WorkPhone3" SIZE=75MAXLENGTH=100><br> <b>Home Phone:</b> <INPUT TYPE=TEXT NAME="HomePhone3" SIZE=75MAXLENGTH=100><br> <b>Cell Phone:</b> <INPUT TYPE=TEXT NAME="CellPhone3" SIZE=75MAXLENGTH=100><br> <b>Pager Phone:</b> <INPUT TYPE=TEXT NAME="Pager3" SIZE=75MAXLENGTH=100><br> <b>Pager ID:</b> <INPUT TYPE=TEXT NAME="PagerID3" SIZE=75MAXLENGTH=100></FONT></TD><TD width="350"><FONT SIZE=2 FACE="Arial"></FONT></TD></TR>
<TR><TD colspan="4" BGCOLOR="#cccccc"><FONT SIZE=2 FACE="Arial"><center><b>SPECIAL NOTES & OTHER CONSIDERATIONS</b></center></FONT></TD></TR>
<TR><TD colspan="4"><FONT SIZE=2 FACE="Arial"><center><INPUT TYPE=TEXT NAME="SpecialNotes" SIZE=150MAXLENGTH=500></center></FONT></TD></TR>
<TR><TD colspan="4" BGCOLOR="#cccccc"><FONT SIZE=2 FACE="Arial"><center><b>PHOTOS</b></center></FONT></TD></TR>
<TR><TD width="350" BGCOLOR="#ccffff"><FONT SIZE=2 FACE="Arial"><center><b>Side A</b></center></FONT></TD><TD width="350" BGCOLOR="#ccffff"><FONT SIZE=2 FACE="Arial"><center><b>Side B</b></center></FONT></TD></TR>
<TR><TD width="350"><FONT SIZE=2 FACE="Arial"><center><INPUT TYPE=TEXT NAME="SideA" SIZE=75MAXLENGTH=100></center></FONT></TD><TD width="350"><FONT SIZE=2 FACE="Arial"><center><INPUT TYPE=TEXT NAME="SideB" SIZE=75MAXLENGTH=100></center></FONT></TD></TR>
<TR><TD width="350" BGCOLOR="#ccffff"><FONT SIZE=2 FACE="Arial"><center><b>Side C</b></center></FONT></TD><TD width="350" BGCOLOR="#ccffff"><FONT SIZE=2 FACE="Arial"><center><b>Side D</b></center></FONT></TD></TR>
<TR><TD width="350"><FONT SIZE=2 FACE="Arial"><center><INPUT TYPE=TEXT NAME="SideC" SIZE=75MAXLENGTH=100></center></FONT></TD><TD width="350"><FONT SIZE=2 FACE="Arial"><center><INPUT TYPE=TEXT NAME="SideD" SIZE=75MAXLENGTH=100></center></FONT></TD></TR>
<TR><TD width="350" BGCOLOR="#ccffff"><FONT SIZE=2 FACE="Arial"><center><b>Roof</b></center></FONT></TD><TD width="350" BGCOLOR="#ccffff"><FONT SIZE=2 FACE="Arial"><center><b>Other</b></center></FONT></TD></TR>
<TR><TD width="350"><FONT SIZE=2 FACE="Arial"><center><INPUT TYPE=TEXT NAME="PRoof" SIZE=75MAXLENGTH=100></center></FONT></TD><TD width="350"><FONT SIZE=2 FACE="Arial"><center><INPUT TYPE=TEXT NAME="POther" SIZE=75MAXLENGTH=100></center></FONT></TD></TR>
<TR><TD colspan="4" BGCOLOR="#cccccc"><FONT SIZE=2 FACE="Arial"><center><b>FLOOR PLANS</b></center></FONT></TD></TR>
<TR><TD width="350" BGCOLOR="#ccffff"><FONT SIZE=2 FACE="Arial"><center><b>Floor Plan 1</b></center></FONT></TD><TD width="350" BGCOLOR="#ccffff"><FONT SIZE=2 FACE="Arial"><center><b>Floor Plan 2</b></center></FONT></TD></TR>
<TR><TD width="350"><FONT SIZE=2 FACE="Arial"><INPUT TYPE=TEXT NAME="Floor1" SIZE=75MAXLENGTH=100></FONT></TD><TD width="350"><FONT SIZE=2 FACE="Arial"><INPUT TYPE=TEXT NAME="Floor2" SIZE=75MAXLENGTH=100></FONT></TD></TR>
<TR><TD width="350" BGCOLOR="#ccffff"><FONT SIZE=2 FACE="Arial"><center><b>Floor Plan 3</b></center></FONT></TD><TD width="350" BGCOLOR="#ccffff"><FONT SIZE=2 FACE="Arial"><center><b>Floor Plan 4</b></center></FONT></TD></TR>
<TR><TD width="350"><FONT SIZE=2 FACE="Arial"><INPUT TYPE=TEXT NAME="Floor3" SIZE=75MAXLENGTH=100></FONT></TD><TD width="350"><FONT SIZE=2 FACE="Arial"><INPUT TYPE=TEXT NAME="Floor4" SIZE=75MAXLENGTH=100></FONT></TD></TR>
<TR><TD colspan="4" BGCOLOR="#cccccc"><FONT SIZE=2 FACE="Arial"><center><b>PLOT PLAN</b></center></FONT></TD></TR>
<TR><TD colspan="4"><FONT SIZE=2 FACE="Arial"><center><INPUT TYPE=TEXT NAME="Plot" SIZE=75MAXLENGTH=100></center></FONT></TD></TR>
<TR><TD colspan="4"><FONT SIZE=2 FACE="Arial"><center><INPUT TYPE=SUBMIT NAME="submit" VALUE="SUBMIT"></center></FONT></TD></TR>
</TABLE><BR>
</P>
</FORM>

<UL>
<LI><B><FONT SIZE="4">NOTES:</FONT></B><BR>
<UL>
<LI><B>Please fill out preplan form completely. Use "NA" if something does not apply</B> <BR>
<LI><B>For each preplan you create, please create a folder on the station computer and put files such as pictures etc. in it.</B> <BR>
<LI><B>If you need help please ask</B> <BR>
</UL>
</UL>
<?php endif; ?>