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)
11-20-2002, 05:19 AM
Script Check
Linear Mode
