1.
$additional_image_fields['sale'] = array("Standard RF sale", "radio", 0);
$additional_image_fields['rm_photo'] = array("RM Request", "radio", 0);
$additional_image_fields['image_promotion'] = array("Promotion", "radio", 0);
$additional_image_fields['promopic'] = array("Add Promotion Pic", "radio", 0);
$additional_image_fields['price3'] = array('Price (euro)', "text", 0);
2.
I used this upload for each additional field to the database:
<?php
define('ROOT_PATH', './');
include(ROOT_PATH.'config.php');
include(ROOT_PATH.'global.php');
$sql_data = array(
"ALTER TABLE `".IMAGES_TABLE."` ADD `promopic` tinyint (1) NOT NULL",
);
foreach ($sql_data as $val){
if ($site_db->query($val)) {
$log[$val] = "Succesfully updated Database";
}
else {
$log[$val] = "<font color=\"red\">Error</font>";
$error = 1;
}
}
if (!$error) echo "Succesfully updated Database";
else echo "an Error occured";
?>
-------
PHP version: 4.4.6
Mysql: 4.1.22
Thanks for helping finding an answer. It's much appreciated.
Dennis, Sweden