Script Check

[ManagerJosh]

This script (non vbulletin) is starting to annoy me....
Could someone give me an insight on what I did wrong?

PHP Code:

$manufacturers_array = array(array('id' => '', 'text' => TEXT_NONE));
    $manufacturers_query = tep_db_query("select manufacturers_id, manufacturers_name, manufacturers_directory from " . TABLE_MANUFACTURERS . " order by manufacturers_name");
    while ($manufacturers = tep_db_fetch_array($manufacturers_query)) {
      $manufacturers_array[] = array('id' => $manufacturers['manufacturers_id'],
                                     'text' => $manufacturers['manufacturers_name']);
    }
    $manufacturers_data = tep_db_fetch_array($manufacturers_query);




$products_image = tep_get_uploaded_file('products_image');
      $image_directory = tep_get_local_path(DIR_FS_CATALOG_IMAGES);

      if (is_uploaded_file($products_image['tmp_name'])) {
        tep_copy_uploaded_file($products_image, $image_directory/$manufacturers_data['manufacturers_directory']}; 
// Directory Modifications

        $products_image_name = $products_image['name'];
      } else {
        $products_image_name = $HTTP_POST_VARS['products_previous_image'];
      }
    } else {
      $product_query = tep_db_query("select p.products_id, pd.language_id, pd.products_name, pd.products_description, pd.products_url, pd.products_affiliates, p.products_quantity, p.products_model, p.products_image, p.products_price, p.products_weight, p.products_date_added, p.products_last_modified, p.products_date_available, p.products_status, p.manufacturers_id  from " . TABLE_PRODUCTS . " p, " . TABLE_PRODUCTS_DESCRIPTION . " pd where p.products_id = pd.products_id and p.products_id = '" . $HTTP_GET_VARS['pID'] . "'");
      $product = tep_db_fetch_array($product_query);

      $pInfo = new objectInfo($product);
      $products_image_name = $pInfo->products_image;
    } 


I renamed mysql to tep for certain reasons (and no it doesn't affect the query)