upload txt file to database

Anon

I have crteated a form where users enter there email address and chose a txt file from there computer to upload ... the txt file is a file trading list ... my goal is to dynamically display all the users' lists
on a page as they upload to the database ... How should i go about this? When i tested what i thought might work , it just displayed the path to the file on the users machine ... what was in the txt file was not being recorded into the database (mysql)? Help is greatly appreciated ... thanks !!!

toma42

You need to change your html form to be multi-part.

Anon

this is how i have it set up:
"form.html"

<FONT FACE="Arial" COLOR="#00ff00"><P ALIGN="CENTER">Please enter your contact info</P>
<P ALIGN="CENTER">Email
<INPUT TYPE="TEXT" WIDTH="147" NAME=email>
</P>
<P ALIGN="CENTER">ICQ #
<INPUT TYPE="TEXT" WIDTH="152" name=icq>
</P></FONT>
<P ALIGN="CENTER"><CENTER><TABLE CELLSPACING=0 BORDER=0 CELLPADDING=7 WIDTH=339>
<TR><TD WIDTH="60%" VALIGN="TOP" HEIGHT=42>
<P ALIGN="CENTER"><FONT FACE="Arial" COLOR="#00ff00">Do you run an FTP Server?</FONT></TD>
<TD WIDTH="20%" VALIGN="TOP" HEIGHT=42>
<FONT FACE="Arial" COLOR="#00ff00"><P ALIGN="CENTER">
<INPUT TYPE="RADIO" NAME=runserver>
yes</FONT></TD>
<TD WIDTH="20%" VALIGN="TOP" HEIGHT=42>
<FONT FACE="Arial" COLOR="#00ff00"><P ALIGN="CENTER">
<INPUT TYPE="RADIO" NAME=runserver>
no</FONT></TD>
</TR>
</TABLE>
</CENTER></P>
<FONT FACE="Arial" COLOR="#00ff00"><P ALIGN="CENTER">Upload you trading list in text format<BR>
Make sure your contact info is in the text</P>
<P ALIGN="CENTER">
<INPUT TYPE="file" name=tradelist>
</P>
<P ALIGN="CENTER">By clicking submit you are posting the above<BR>
info to other users browsing this site.</P>
<P ALIGN="CENTER">
<INPUT TYPE="SUBMIT" NAME="submit" VALUE="submit">
</P></FORM>
<FORM></FORM></FONT></BODY>

"submitform.php"

<body>
<?php
mysql_connect (localhost, root);

mysql_select_db (trade);
mysql_query ("INSERT INTO email_list (email, icq, runserver, tradelist)
VALUES ('$email', '$icq', '$runserver', '$tradelist')
print ($email);
print ("<p> ");
print ($icq);
print ("<p>");
print ($runserver);
print ("<p>");
print ($tradelist);
print ("<p>");
print ("Thanks for submitting.");
?>
</body>