.html to asp to get info to go to a database

[31479]

I am an intern who is getting headaches from trying to figure this stuff out. I need for this form inputted information to go to a database. Should I created the database first or what? PLEASE HELP<br>&lt;html&gt;<br>&lt;head&gt;<br>&lt;title&gt;Supplies Request&lt;/title&gt;<br>&lt;/head&gt;<br>&lt;Script Language = &quot;JavaScript&quot;&gt;<br>&lt;!--<br>function DateToday() {<br>&nbsp;&nbsp;&nbsp;var Today=new Date();<br>&nbsp;&nbsp;&nbsp;var ThisDay=Today.getDate();<br>&nbsp;&nbsp;&nbsp;var ThisMonth=Today.getMonth()+1;<br>&nbsp;&nbsp;&nbsp;var ThisYear=Today.getYear();<br>&nbsp;&nbsp;&nbsp;return ThisMonth+&quot;/&quot;+ThisDay+&quot;/&quot;+ThisYear;<br>}<br><br>function StartForm() {<br>&nbsp;&nbsp;&nbsp;document.REG.FORMDATE.value=DateToday();<br>}<br>//--&gt;<br>&lt;/Script&gt;<br><br>&lt;body onload=StartForm(); bgcolor=&quot;#FFFFFF&quot;&gt;<br><br>&lt;font size=&quot;+2&quot; face=&quot;verdana&quot;&gt;&lt;b&gt;Supplies Request&lt;/b&gt;&lt;/font&gt; &lt;br&gt;<br>&nbsp;&nbsp;&nbsp;&nbsp;&lt;img src=&quot;/cos/images/rule.gif&quot; align=&quot;left&quot; WIDTH=&quot;430&quot; HEIGHT=&quot;5&quot;&gt;&lt;br&gt;<br>&nbsp;&nbsp;&nbsp;&nbsp;<br>&nbsp;&nbsp;&nbsp;&nbsp;&lt;p&gt;&lt;font size=&quot;-1&quot; face=&quot;verdana&quot;&gt;Fields indicated with a &lt;img src=&quot;C:\WIN95\Desktop\star.gif&quot; WIDTH=&quot;20&quot; HEIGHT=&quot;19&quot;&gt;<br>&nbsp;&nbsp;&nbsp;&nbsp;are required fields (incomplete forms will be closed).&lt;/font&gt;&lt;/p&gt;<br>&nbsp;&nbsp;&nbsp;&nbsp;&lt;hr align=&quot;left&quot;&gt;<br>&lt;FORM ACTION=&quot;P:\Personal Applications\thanks.htm&quot; METHOD=POST name=&quot;REG&quot;&gt; <br>&lt;input type=hidden name=email value=&quot;email address&quot;&gt;<br>&lt;table&gt;<br> &lt;tr&gt;<br> &lt;td width=&quot;150&quot; align=&quot;right&quot;&gt;&lt;font size=&quot;-1&quot; face=&quot;verdana&quot;&gt;&lt;b&gt;Date&lt;/b&gt;&lt;/font&gt;&lt;/td&gt;<br> &lt;td&gt;&lt;input type=&quot;text&quot; name=FORMDATE size=8&gt;&lt;/td&gt;<br>&lt;/tr&gt;<br>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&lt;tr&gt;<br>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&lt;td width=&quot;150&quot; align=&quot;right&quot;&gt;&lt;font size=&quot;-1&quot; face=&quot;verdana&quot;&gt;&lt;b&gt;First Name&lt;/b&gt;&lt;/font&gt;&lt;/td&gt;<br>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&lt;td width=&quot;400&quot;&gt;&lt;input type=&quot;text&quot; size=&quot;18&quot; name=&quot;FirstName&quot; maxlength=&quot;20&quot;&gt;&lt;/font&gt; &lt;img src=&quot;C:\WIN95\Desktop\star.gif&quot; WIDTH=&quot;20&quot; HEIGHT=&quot;19&quot;&gt;&lt;/td&gt;<br>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&lt;/tr&gt;<br>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&lt;tr&gt;<br>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&lt;td width=&quot;150&quot; align=&quot;right&quot;&gt;&lt;font size=&quot;-1&quot; face=&quot;verdana&quot;&gt;&lt;b&gt;Last Name&lt;/b&gt;&lt;/font&gt;&lt;/td&gt;<br>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&lt;td&gt;&lt;input type=&quot;text&quot; size=&quot;18&quot; name=&quot;LastName&quot; maxlength=&quot;20&quot;&gt; &lt;img src=&quot;C:\WIN95\Desktop\star.gif&quot; WIDTH=&quot;20&quot; HEIGHT=&quot;19&quot;&gt;&lt;/td&gt;<br>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&lt;/tr&gt;<br>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;<br>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&lt;tr&gt;<br>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&lt;td width=&quot;150&quot; align=&quot;right&quot;&gt;&lt;font size=&quot;-1&quot; face=&quot;verdana&quot;&gt;&lt;b&gt;Phone Number&lt;/b&gt;&lt;/font&gt;&lt;/td&gt;<br>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&lt;td&gt;&lt;input type=&quot;text&quot; size=&quot;13&quot; name=&quot;PhoneNumber&quot; maxlength=&quot;12&quot;&gt; &lt;img src=&quot;C:\WIN95\Desktop\star.gif&quot; WIDTH=&quot;20&quot; HEIGHT=&quot;19&quot;&gt;&lt;/td&gt;<br>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&lt;/tr&gt;<br>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&lt;tr&gt;<br>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&lt;td width=&quot;150&quot; align=&quot;right&quot;&gt;&lt;font size=&quot;-1&quot; face=&quot;verdana&quot;&gt;&lt;b&gt;Location&lt;/b&gt;&lt;/font&gt;&lt;/td&gt;<br>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&lt;td&gt;&lt;input type=&quot;text&quot; size=&quot;30&quot; name=&quot;Location&quot;&gt; &lt;img src=&quot;C:\WIN95\Desktop\star.gif&quot; WIDTH=&quot;20&quot; HEIGHT=&quot;19&quot;&gt;&lt;/td&gt;<br>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&lt;/tr&gt;<br>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&lt;tr&gt;<br>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&lt;td width=&quot;150&quot; align=&quot;right&quot;&gt;&lt;font size=&quot;-1&quot; face=&quot;verdana&quot;&gt;&lt;b&gt;Department&lt;/b&gt;&lt;/font&gt;&lt;/td&gt;<br>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&lt;td&gt;&lt;input type=&quot;text&quot; size=&quot;8&quot; name=&quot;Department&quot; maxlength=&quot;9&quot;&gt; &lt;img src=&quot;C:\WIN95\Desktop\star.gif&quot; WIDTH=&quot;20&quot; HEIGHT=&quot;19&quot;&gt;&lt;/td&gt;<br>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&lt;/tr&gt;<br> &lt;tr&gt;<br> &lt;td width=&quot;150&quot; align=&quot;right&quot;&gt;&lt;font size=&quot;-1&quot; face=&quot;verdana&quot;&gt;&lt;b&gt;Reason for Supplies&lt;/b&gt;&lt;/font&gt;&lt;/td&gt;<br> &lt;td&gt;&lt;select name=&quot;REASON&quot;&gt;<br> &lt;option&gt;New Hire &nbsp;&nbsp;&lt;option&gt;Out of old supplies<br> &lt;/select&gt;&lt;img src=&quot;C:\WIN95\Desktop\star.gif&quot; WIDTH=&quot;20&quot; HEIGHT=&quot;19&quot;&gt;<br>&nbsp;&nbsp;&lt;/td&gt;<br> &lt;/tr&gt;<br> &lt;tr&gt;<br>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&lt;td width=&quot;150&quot; align=&quot;right&quot;&gt;&lt;font size=&quot;-1&quot; face=&quot;verdana&quot;&gt;&lt;b&gt;Date Needed:&lt;/b&gt;&lt;/font&gt;&lt;/td&gt;<br>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&lt;td&gt;&lt;input type=&quot;text&quot; size=&quot;10&quot; name=&quot;DateNeeded&quot; maxlength=&quot;10&quot;&gt;&lt;img src=&quot;C:\WIN95\Desktop\star.gif&quot; WIDTH=&quot;20&quot; HEIGHT=&quot;19&quot;&gt;&lt;/td&gt;<br>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&lt;/tr&gt;<br>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;<br>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&lt;tr&gt;<br>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&lt;td colspan=&quot;2&quot;&gt;&lt;font size=&quot;-1&quot; face=&quot;verdana&quot;&gt;&lt;b&gt;Is this your first request?<br>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;  &lt;input type=&quot;radio&quot; value=&quot;Yes&quot; checked name=&quot;Quote&quot;&gt;&lt;/b&gt;Yes  &lt;input type=&quot;radio&quot; name=&quot;Quote&quot; value=&quot;No&quot;&gt;No&lt;/font&gt;&lt;/td&gt;<br>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&lt;/tr&gt;<br>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;<br>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;<br>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&lt;tr align=&quot;left&quot;&gt;<br>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&lt;td colspan=&quot;2&quot;&gt;&lt;font size=&quot;-1&quot; face=&quot;verdana&quot;&gt;&lt;b&gt;Comments:&lt;/b&gt;&lt;br&gt;<br>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&lt;textarea rows=&quot;6&quot; name=&quot;SpecialRqmts&quot; cols=&quot;40&quot;&gt;

 

[palbano]

<br>&gt;Should I created the database first or what?<br><br>If one assumes you only want the database created one time then the answer would be, 'Yes'.<br><br>Then if one assumes you want the database access code running on the server, you will need some ASP code in the file to connect to the database.<br><br>Good luck<br>-pete