[Resolved] mysql update arrays

[jasonmills58]

hi, this update works fine when I just upload one file. its a database for tracking which files belong to who, etc.

$query = "INSERT INTO reclamation ( clientid, reportname, filename, path )
		VALUES( '$id', '$reportname', '$filename', '$path' )";

but when I do this to upload multiple files (1, 2, 3, or 4 files)

$file_dir = "/home/httpd/vhosts/babysteps.tv/httpdocs/counterpoint/uploads";
$file_url = "http://babysteps.tv/counterpoint/uploads";
foreach( $_FILES as $file_name => $file_array ) {
	move_uploaded_file( $file_array['tmp_name'], $file_dir.'/'.$file_array['name'] )
		or die ("Couldn't Copy");
}

the UPDATE statement just picks one. how can i gather up all that data?

cheers!

[LordShryku]

Are you planning on inserting them all in the same row, or a seperate row for each one? The logical thing to do would be to make a seperate row for each one, and just stick the query into your loop there.

[jasonmills58]

Yes, I want them in separate rows. I'm just not sure how to place the query in the loop.

[LordShryku]

Provided you have all the other info also at this time, this should work:

$file_dir = "/home/httpd/vhosts/babysteps.tv/httpdocs/counterpoint/uploads";
$file_url = "http://babysteps.tv/counterpoint/uploads";
foreach( $_FILES as $file_name => $file_array ) {
    if(move_uploaded_file( $file_array['tmp_name'], $file_dir.'/'.$file_array['name'] )) {
        $query = "INSERT INTO reclamation ( clientid, reportname, filename, path )
                       VALUES( '$id', '$reportname', '$filename', '$path' )";
        if(!mysql_query($query)) {
            die("Could not execute query: ".mysql_error());
        }
    }
    else {
        die("Couldn't Copy");
    }
}

[jasonmills58]

thanks so much lord shryku! you're the best!