if(isset($_POST['upload'])) { while(list($key,$value) = each($_FILES[inpFile][name])) { $uploaddir = '/home/httpd/vhosts/aussieonlinephoto.com/httpdocs/catalog/images/customerimages/'; $uploadfile = $uploaddir . basename($_FILES['inpFile']['name'][$key]); if (move_uploaded_file($_FILES['inpFile']['name'][$key], $uploadfile)) { echo "File is valid, and was successfully uploaded.\n"; $current_category_id = '23'; $newpic = $_FILES['inpFile']['name'][$key]; $quantity = "1"; $cart = $_GET['osCsid']; $newq = mysql_query("INSERT INTO `products` ( `products_id` , `products_quantity` , `products_model` , `products_image` , `products_price` , `products_date_added` , `products_last_modified` , `products_date_available` , `products_weight` , `products_status` , `products_tax_class_id` , `manufacturers_id` , `products_ordered` ) VALUES ('', '$qty', NULL , 'customerimages/$newpic', '1.0000', now(), NULL , NULL , '0.00', '1', '0', NULL , '0')") or die(mysql_error()); $prodid = mysql_query("SELECT * from products WHERE products_image = '$newpic' LIMIT 1") or die(mysql_error()); while($prodrow = mysql_fetch_array($prodid)) { $products_id = $prodrow['products_id']; $newq2 = mysql_query("INSERT INTO `products_to_categories` ( `products_id` , `categories_id` ) VALUES ('$products_id', '23')") or die(mysql_error()); $newq3 = mysql_query("INSERT INTO `products_description` ( `products_id` , `language_id` , `products_name` , `products_description` , `products_url` , `products_viewed` ) VALUES ('$products_id', '1', 'Customer Uploaded Image', 'Customer Uplooaded Image', NULL , '0')") or die(mysql_error()); echo "newq3: $newq3"; $cart->add_cart($products_id, $cart->get_quantity('1')+1, '$products_id'); } }