Uploading Images & Paths to MySQL

[paken]

I've been scouring Google and various formus all day but can't seem to completely wrap my head around the theory of how to do this, perhaps someone can direct me.

I have a large form for uploading home design information to my DB. The form contains about 10 text fields, 70 or so check boxes and 3 file upload fields for uploading floor plans in .jpg format.

I have 2 tables designed in MySQL, one for all the data, the other for the images.

I understand how to upload multiple files to a directory on my server, however, I don't know/understand how to than take the path to that image in that directory and put it into the image table.

I can't seem to find any code that bridges the gap.

I'm not posting my code here because it's just in disarray right now from trying so many combinations of code. That is why I think I am not understanding the theory of what happens in this process. Can anyone give me a simple walk-through?

Thanks!!!

[djjjozsi]

this simple code generated here (there is video tutorial over there)
you've got an upload folder.

you fill the form, and post it.

if(!empty($_POST["submit"]))
{
*1  do  something...
}

lets check the required fields, and build an error array..

*1:

            if(empty($_FILES["f_fileup"]["tmp_name"]))
            $error[]="fileup is a required field.";  // Check if fileup is empty.

        if(empty($_POST["f_one_field"]))
        $error[]="one_field is a required field.";  // Check if one_field is empty. 

check if the $error array has values, if yes, print it in other case upload the files and fill the table with data.

       if(empty($error))
        {

     if(!empty($_FILES["f_fileup"]["tmp_name"]))
     {
     move_uploaded_file($_FILES["f_fileup"]["tmp_name"] , "uploads/".basename($_FILES["f_fileup"]["name"])) OR die("Could not upload");
     $f_fileup= mysql_real_escape_string(basename($_FILES["f_fileup"]["name"]));
     }
    $f_one_field=mysql_real_escape_string($_POST["f_one_field"]);

    $sql="INSERT INTO table (`fileup`,`one_field`) VALUES ('$f_fileup','$f_one_field') ";

    mysql_query($sql) or die(mysql_error());
    header("Location: uploaded.html");

    }
    else
    print "Please check these errors:<br />" . implode("<br />" , $error); 

the file uploaded into the upload folder, and basename will create a file name without the original folder name. The file name will be included into the table. If you need to make a link for that file, you get the file name from this table, and use the upload folder as folder name.

got question?