Code: Select all
if ($types_picked['extra_fields_type_cat_id'] == '999999999') {
$picked = 'true';
} else {
$picked = 'false';
}Moderator: General Moderators
Code: Select all
if ($types_picked['extra_fields_type_cat_id'] == '999999999') {
$picked = 'true';
} else {
$picked = 'false';
}Code: Select all
echo $types_picked['extra_fields_type_cat_id']Code: Select all
<?php
echo tep_draw_form('extra_fields', FILENAME_SUPERFIELDSTYPE, 'action=update' . '&' . 'cPath=' . $cPath . '&pID=' . $pInfo->products_id,'post');
?>
<?php
$extra_fields_query_update = tep_db_query("SELECT * FROM " . TABLE_EXTRA_FIELDS_TYPE . " WHERE extra_fields_type_status=1 ORDER BY extra_fields_type_order");
$types_picked_query = tep_db_query("SELECT * FROM " . TABLE_PRODUCTS_TO_EXTRA_FIELDS . " WHERE products_id = '" . (int)$HTTP_GET_VARS['pID'] . "' and extra_fields_type_id='" .tep_db_input($key) . "'");
$types_picked = tep_db_fetch_array($types_picked_query);
while ($extra_fields = tep_db_fetch_array($extra_fields_query_update)) {
?>
<?php echo ($types_picked['extra_fields_type_cat_id'] == '999999999') {
$picked = 'true';
} else {
$picked = 'false';
};
echo tep_draw_checkbox_field('mark['.$extra_fields['extra_fields_type_id'].']', $pInfo->products_id, $picked); ?>
<?php echo $extra_fields['extra_fields_type_name']; ?>
<br/>
<?php } ?> <?php echo tep_image_submit('button_update_fields.png',IMAGE_UPDATE_FIELDS); ?>Code: Select all
echo '<pre>';
print_r($types_picked);
echo '</pre>';Code: Select all
$types_picked_query = tep_db_query("SELECT * FROM " . TABLE_PRODUCTS_TO_EXTRA_FIELDS . " WHERE products_id = '" . (int)$HTTP_GET_VARS['pID'] . "' and extra_fields_type_id='" .tep_db_input($key) . "'");Code: Select all
echo "SELECT * FROM " . TABLE_PRODUCTS_TO_EXTRA_FIELDS . " WHERE products_id = '" . (int)$HTTP_GET_VARS['pID'] . "' and extra_fields_type_id='" .tep_db_input($key) . "'";Code: Select all
<?php
echo tep_draw_form('extra_fields', FILENAME_SUPERFIELDSTYPE, 'action=update' . '&' . 'cPath=' . $cPath . '&pID=' . $pInfo->products_id,'post');
?>
<?php
$extra_fields_query_update = tep_db_query("SELECT * FROM " . TABLE_EXTRA_FIELDS_TYPE . " WHERE extra_fields_type_status=1 ORDER BY extra_fields_type_order");
$types_picked_query = tep_db_query("SELECT * FROM " . TABLE_PRODUCTS_TO_EXTRA_FIELDS . " WHERE products_id = '" . (int)$HTTP_GET_VARS['pID'] . "' and extra_fields_type_id='" . $extra_fields['extra_fields_type_id'] . "'");
$types_picked = tep_db_fetch_array($types_picked_query);
while ($extra_fields = tep_db_fetch_array($extra_fields_query_update)) {
?>
<?php if ($types_picked['extra_fields_type_cat_id'] == '999999999') {
$picked = 'true';
} else {
$picked = 'false';
}
echo tep_draw_checkbox_field('mark['.$extra_fields['extra_fields_type_id'].']', $pInfo->products_id, $picked); ?>
<?php echo $extra_fields['extra_fields_type_name']; ?>
<br/>
<?php } ?> <?php echo tep_image_submit('button_update_fields.png',IMAGE_UPDATE_FIELDS); ?> </form>Code: Select all
tep_db_query("INSERT INTO " . TABLE_PRODUCTS_TO_EXTRA_FIELDS . " (products_id, extra_fields_type_id) VALUES (" . tep_db_input((int)$HTTP_GET_VARS['pID']) . ", " .tep_db_input($key) . ") ON DUPLICATE KEY UPDATE products_id=" . tep_db_input((int)$HTTP_GET_VARS['pID']) . ", extra_fields_type_id=" .tep_db_input($key) . ";");
well tryTry replacing all instances of $HTTP_GET_VARS with $_GET also.
$HTTP_GET_VARS is deprecated.
never mind on that... forgot i turns the defult in phpMyAdmin was off... no luck with the if claseCode: Select all
tep_db_query("INSERT INTO " . TABLE_PRODUCTS_TO_EXTRA_FIELDS . " (products_id, extra_fields_type_id) VALUES (" . tep_db_input((int)$HTTP_GET_VARS['pID']) . ", " .tep_db_input($key) . ") ON DUPLICATE KEY UPDATE products_id=" . tep_db_input((int)$HTTP_GET_VARS['pID']) . ", extra_fields_type_id=" .tep_db_input($key) . ";");
Code: Select all
<?php
echo tep_draw_form('extra_fields', FILENAME_SUPERFIELDSTYPE, 'action=update' . '&' . 'cPath=' . $cPath . '&pID=' . $pInfo->products_id,'post');
?>
<?php
$extra_fields_query_update = tep_db_query("SELECT * FROM " . TABLE_EXTRA_FIELDS_TYPE . " WHERE extra_fields_type_status=1 ORDER BY extra_fields_type_order");
while ($extra_fields = tep_db_fetch_array($extra_fields_query_update)) {
$types_picked_query = tep_db_query("SELECT * FROM " . TABLE_PRODUCTS_TO_EXTRA_FIELDS . " WHERE products_id = '" . (int)$_GET['pID'] . "' and extra_fields_type_id='" . $extra_fields['extra_fields_type_id'] . "'");
$types_picked = tep_db_fetch_array($types_picked_query);
echo ($types_picked['extra_fields_type_cat_id'] == 999999999);
if ($types_picked['extra_fields_type_cat_id'] == 999999999) {
$picked = 'true';
} else {
$picked = 'false';
}
?>
<?php
echo '<pre>t';
print_r($types_picked);
echo '</pre>';
echo "SELECT * FROM " . TABLE_PRODUCTS_TO_EXTRA_FIELDS . " WHERE products_id = '" . (int)$_GET['pID'] . "' and extra_fields_type_id='" . $extra_fields['extra_fields_type_id'] . "'";
echo tep_draw_checkbox_field('mark['.$extra_fields['extra_fields_type_id'].']', $pInfo->products_id, $picked); ?>
<?php echo $extra_fields['extra_fields_type_name']; ?>
<br/>
<?php } ?> <?php echo tep_image_submit('button_update_fields.png',IMAGE_UPDATE_FIELDS); ?> </form>