ONE form with image upload and other data

[scottrad]

I hope some one can help, and yes I have read many of the posts, but cant seem to find one in my situation.
My form is a regular form capturing data such as first name, last name etc.. but in this form I also want to upload an image to the table. For some reason it only sets the image path to my local drive in the table and that isnt what I want.

Even if I can just upload the image to a dir and then have the path in the db thats fine, I just dont know how this will work all in one form.

Here is my code: (not all fields for sake of brevity)

<form method=post action="register_new.php">
<table width="480" cellpadding="0" cellspacing="0">
<tr>
<td colspan="2" class="maincontent">Please fill out fields marked with an asterisk
<span class="maincontent"></span>.<br />You only need to Register once.<br />You will be able to go back and change your information at any time after you register.<br /><br /></td>
</tr>
<tr>
<td width="150" class="maincontent">First name&nbsp;&nbsp;<span class="maincontent"></span>&nbsp;</td>
<td><input type="text" name="firstname" size="20" maxlength="20"></td></tr>......

<tr>
<td width="150" class="maincontent">Picture&nbsp;&nbsp;<span class="maincontent">*</span>&nbsp;</td>
<td width="150"><input type="hidden" name="MAX_FILE_SIZE" value="1000000">
<input type=file name=picture size=15 maxlength=15></td></tr>.....

</form>

The result I get is D:\picture.jpg and not the actual file.

Any help would be appreciated!

The action register_new.php simply inserts the data to the db.

[marque]

your form must be a multipart data form

<form action="register_new.php" method="post" enctype="multipart/form-data">

[scottrad]

I have already tried that once, when I use enctype="multipart/form-data" my data doesnt get stored correctly. Each column is then off by one when it is stored. When I remove enctype="multipart/form-data" the data is stored but not the image just the image path.😕