Jump to content
  • Checkout
  • Login
  • Get in touch

osCommerce

The e-commerce.

Output not correct in index.php page ? help pls?


Nathali

Recommended Posts

Hi,

 

I hope please, that someone will know how to solve it..

 

My problem is:

 

In index.php page, when I choose a Manufacturers in the "Manufacturers box" (right down the "categories box")

 

I get too long "Category text line" (at the top), for browsing this Manufacturer categories.

 

I would like to reduce the length of this "Category text line" ?

 

 

 

Please, any help what code I should look for and correct?

 

Thanks for your attention :-)

 

Regards,

Nathali

Best Regards,

Nathali

Link to comment
Share on other sites

The dropdown box will always expand to be wide enough to be able to display the longest option.

 

Some of the options in your dropdown are very, very, long, thus the page misalignment.

 

You'll have to find a way to shorten them.

 

At least this is what I think you are posting about...

:blush:

If I suggest you edit any file(s) make a backup first - I'm not perfect and neither are you.

 

"Given enough impetus a parallelogramatically shaped projectile can egress a circular orifice."

- Me -

 

"Headers already sent" - The definitive help

 

"Cannot redeclare ..." - How to find/fix it

 

SSL Implementation Help

 

Like this post? "Like" it again over there >

Link to comment
Share on other sites

The dropdown box will always expand to be wide enough to be able to display the longest option.

 

Some of the options in your dropdown are very, very, long, thus the page misalignment.

 

You'll have to find a way to shorten them.

 

At least this is what I think you are posting about...

:blush:

 

Henry & Jim thanks a lot for your kind reply!

 

Jim you are right, when you say: "Some of the options in your dropdown are very, very, long, thus the page misalignment."

 

The way to shorten them it's to limit the length of the Text dropdown box..

 

What Code I need to modify to apply it?

 

Here is my index.php page:

 

<?php

/*

 

$Id: index.php,v 1.1 2003/06/11 17:37:59 hpdl Exp $

 

 

 

osCommerce, Open Source E-Commerce Solutions

 

http://www.oscommerce.com

 

 

 

Copyright © 2003 osCommerce

 

 

 

Released under the GNU General Public License

 

*/

 

 

 

require('includes/application_top.php');

 

 

 

// the following cPath references come from application_top.php

 

$category_depth = 'top';

 

if (isset($cPath) && tep_not_null($cPath)) {

 

$categories_products_query = tep_db_query("select count(*) as total from " . TABLE_PRODUCTS_TO_CATEGORIES . " where categories_id = '" . (int)$current_category_id . "'");

 

$cateqories_products = tep_db_fetch_array($categories_products_query);

 

if ($cateqories_products['total'] > 0) {

 

$category_depth = 'products'; // display products

 

} else {

 

$category_parent_query = tep_db_query("select count(*) as total from " . TABLE_CATEGORIES . " where parent_id = '" . (int)$current_category_id . "'");

 

$category_parent = tep_db_fetch_array($category_parent_query);

 

if ($category_parent['total'] > 0) {

 

$category_depth = 'nested'; // navigate through the categories

 

} else {

 

$category_depth = 'products'; // category has no products, but display the 'no products' message

 

}

 

}

 

}

 

// Add-on - Information Pages Unlimited

 

require_once(DIR_WS_FUNCTIONS . 'information.php');

 

tep_information_customer_greeting_define(); // Should be called before the Default Language is defined

 

require(DIR_WS_LANGUAGES . $language . '/' . FILENAME_DEFAULT);

 

?>

<!doctype html public "-//W3C//DTD HTML 4.01 Transitional//EN">

 

<html <?php echo HTML_PARAMS; ?>>

 

<head>

 

<meta http-equiv="Content-Type" content="text/html; charset=<?php echo CHARSET; ?>">

 

<?php include(DIR_WS_INCLUDES . 'easy_meta_tags.php'); ?>

<base href="<?php echo (($request_type == 'SSL') ? HTTPS_SERVER : HTTP_SERVER) . DIR_WS_CATALOG; ?>">

<link rel="stylesheet" type="text/css" href="stylesheet.css">

 

</head>

 

<body marginwidth="0" marginheight="0" topmargin="0" bottommargin="0" leftmargin="0" rightmargin="0">

 

<!-- header //-->

 

<?php require(DIR_WS_INCLUDES . 'header.php'); ?>

<!-- header_eof //-->

 

 

 

<!-- body //-->

 

<table border="0" width="100%" cellspacing="3" cellpadding="3">

 

<tr>

 

<td width="<?php echo BOX_WIDTH; ?>" valign="top"><table border="0" width="<?php echo BOX_WIDTH; ?>" cellspacing="0" cellpadding="2">

 

<!-- left_navigation //-->

 

<?php require(DIR_WS_INCLUDES . 'column_left.php'); ?>

<!-- left_navigation_eof //-->

 

</table></td>

 

<!-- body_text //-->

 

<?php

 

if ($category_depth == 'nested') {

 

$category_query = tep_db_query("select cd.categories_name, c.categories_image from " . TABLE_CATEGORIES . " c, " . TABLE_CATEGORIES_DESCRIPTION . " cd where c.categories_id = '" . (int)$current_category_id . "' and cd.categories_id = '" . (int)$current_category_id . "' and cd.language_id = '" . (int)$languages_id . "'");

 

$category = tep_db_fetch_array($category_query);

 

?>

<td width="100%" valign="top"><table border="0" width="100%" cellspacing="0" cellpadding="0">

 

<tr>

 

<td><table border="0" width="100%" cellspacing="0" cellpadding="0">

 

<tr>

 

<td class="pageHeading"><?php echo HEADING_TITLE; ?></td>

 

<td class="pageHeading" align="right"><?php echo tep_image(DIR_WS_IMAGES . $category['categories_image'], $category['categories_name'], HEADING_IMAGE_WIDTH, HEADING_IMAGE_HEIGHT); ?></td>

 

</tr>

 

</table></td>

 

</tr>

 

<tr>

 

<td><?php echo tep_draw_separator('pixel_trans.gif', '100%', '10'); ?></td>

 

</tr>

 

<tr>

 

<td><table border="0" width="100%" cellspacing="0" cellpadding="2">

 

<tr>

 

<td><table border="0" width="100%" cellspacing="0" cellpadding="2">

 

<tr>

 

<?php

if (isset($cPath) && strpos('_', $cPath)) {

 

// check to see if there are deeper categories within the current category

 

$category_links = array_reverse($cPath_array);

 

for($i=0, $n=sizeof($category_links); $i<$n; $i++) {

 

$categories_query = tep_db_query("select count(*) as total from " . TABLE_CATEGORIES . " c, " . TABLE_CATEGORIES_DESCRIPTION . " cd where c.parent_id = '" . (int)$category_links[$i] . "' and c.categories_id = cd.categories_id and cd.language_id = '" . (int)$languages_id . "'");

 

$categories = tep_db_fetch_array($categories_query);

 

if ($categories['total'] < 1) {

 

// do nothing, go through the loop

 

} else {

 

$categories_query = tep_db_query("select c.categories_id, cd.categories_name, c.categories_image, c.parent_id from " . TABLE_CATEGORIES . " c, " . TABLE_CATEGORIES_DESCRIPTION . " cd where c.parent_id = '" . (int)$category_links[$i] . "' and c.categories_id = cd.categories_id and cd.language_id = '" . (int)$languages_id . "' order by sort_order, cd.categories_name");

 

break; // we've found the deepest category the customer is in

 

}

 

}

 

} else {

 

$categories_query = tep_db_query("select c.categories_id, cd.categories_name, c.categories_image, c.parent_id from " . TABLE_CATEGORIES . " c, " . TABLE_CATEGORIES_DESCRIPTION . " cd where c.parent_id = '" . (int)$current_category_id . "' and c.categories_id = cd.categories_id and cd.language_id = '" . (int)$languages_id . "' order by sort_order, cd.categories_name");

 

}

 

 

 

$number_of_categories = tep_db_num_rows($categories_query);

 

 

 

$rows = 0;

 

while ($categories = tep_db_fetch_array($categories_query)) {

 

$rows++;

 

$cPath_new = tep_get_path($categories['categories_id']);

 

$width = (int)(100 / MAX_DISPLAY_CATEGORIES_PER_ROW) . '%';

 

echo ' <td align="center" class="smallText" width="' . $width . '" valign="top"><a href="' . tep_href_link(FILENAME_DEFAULT, $cPath_new) . '">' . tep_image(DIR_WS_IMAGES . $categories['categories_image'], $categories['categories_name'], SUBCATEGORY_IMAGE_WIDTH, SUBCATEGORY_IMAGE_HEIGHT) . '<br>' . $categories['categories_name'] . '</a></td>' . "\n";

 

if ((($rows / MAX_DISPLAY_CATEGORIES_PER_ROW) == floor($rows / MAX_DISPLAY_CATEGORIES_PER_ROW)) && ($rows != $number_of_categories)) {

 

echo ' </tr>' . "\n";

 

echo ' <tr>' . "\n";

 

}

 

}

 

 

 

// needed for the new products module shown below

 

$new_products_category_id = $current_category_id;

 

?>

</tr>

 

</table></td>

 

</tr>

 

<tr>

 

<td><?php echo tep_draw_separator('pixel_trans.gif', '100%', '10'); ?></td>

 

</tr>

 

<tr>

 

<td><?php include(DIR_WS_MODULES . FILENAME_NEW_PRODUCTS); ?></td>

 

</tr>

 

</table></td>

 

</tr>

 

</table></td>

 

<?php

} elseif ($category_depth == 'products' || isset($HTTP_GET_VARS['manufacturers_id'])) {

 

// create column list

 

$define_list = array('PRODUCT_LIST_MODEL' => PRODUCT_LIST_MODEL,

 

'PRODUCT_LIST_NAME' => PRODUCT_LIST_NAME,

 

'PRODUCT_LIST_MANUFACTURER' => PRODUCT_LIST_MANUFACTURER,

 

'PRODUCT_LIST_PRICE' => PRODUCT_LIST_PRICE,

 

'PRODUCT_LIST_QUANTITY' => PRODUCT_LIST_QUANTITY,

 

'PRODUCT_LIST_WEIGHT' => PRODUCT_LIST_WEIGHT,

 

'PRODUCT_LIST_IMAGE' => PRODUCT_LIST_IMAGE,

 

'PRODUCT_LIST_BUY_NOW' => PRODUCT_LIST_BUY_NOW);

 

 

 

asort($define_list);

 

 

 

$column_list = array();

 

reset($define_list);

 

while (list($key, $value) = each($define_list)) {

 

if ($value > 0) $column_list[] = $key;

 

}

 

 

 

$select_column_list = '';

 

 

 

for ($i=0, $n=sizeof($column_list); $i<$n; $i++) {

 

switch ($column_list[$i]) {

 

case 'PRODUCT_LIST_MODEL':

 

$select_column_list .= 'p.products_model, ';

 

break;

 

case 'PRODUCT_LIST_NAME':

 

$select_column_list .= 'pd.products_name, ';

 

break;

 

case 'PRODUCT_LIST_MANUFACTURER':

 

$select_column_list .= 'm.manufacturers_name, ';

 

break;

 

case 'PRODUCT_LIST_QUANTITY':

 

$select_column_list .= 'p.products_quantity, ';

 

break;

 

case 'PRODUCT_LIST_IMAGE':

 

$select_column_list .= 'p.products_image, ';

 

break;

 

case 'PRODUCT_LIST_WEIGHT':

 

$select_column_list .= 'p.products_weight, ';

 

break;

 

}

 

}

 

 

 

// show the products of a specified manufacturer

 

if (isset($HTTP_GET_VARS['manufacturers_id'])) {

 

if (isset($HTTP_GET_VARS['filter_id']) && tep_not_null($HTTP_GET_VARS['filter_id'])) {

 

// We are asked to show only a specific category

 

$listing_sql = "select " . $select_column_list . " p.products_id, p.manufacturers_id, p.products_price, p.products_tax_class_id, IF(s.status, s.specials_new_products_price, NULL) as specials_new_products_price, IF(s.status, s.specials_new_products_price, p.products_price) as final_price from " . TABLE_PRODUCTS . " p left join " . TABLE_SPECIALS . " s on p.products_id = s.products_id, " . TABLE_PRODUCTS_DESCRIPTION . " pd, " . TABLE_MANUFACTURERS . " m, " . TABLE_PRODUCTS_TO_CATEGORIES . " p2c where p.products_status = '1' and p.manufacturers_id = m.manufacturers_id and m.manufacturers_id = '" . (int)$HTTP_GET_VARS['manufacturers_id'] . "' and p.products_id = p2c.products_id and pd.products_id = p2c.products_id and pd.language_id = '" . (int)$languages_id . "' and p2c.categories_id = '" . (int)$HTTP_GET_VARS['filter_id'] . "'";

 

} else {

 

// We show them all

 

$listing_sql = "select " . $select_column_list . " p.products_id, p.manufacturers_id, p.products_price, p.products_tax_class_id, IF(s.status, s.specials_new_products_price, NULL) as specials_new_products_price, IF(s.status, s.specials_new_products_price, p.products_price) as final_price from " . TABLE_PRODUCTS . " p left join " . TABLE_SPECIALS . " s on p.products_id = s.products_id, " . TABLE_PRODUCTS_DESCRIPTION . " pd, " . TABLE_MANUFACTURERS . " m where p.products_status = '1' and pd.products_id = p.products_id and pd.language_id = '" . (int)$languages_id . "' and p.manufacturers_id = m.manufacturers_id and m.manufacturers_id = '" . (int)$HTTP_GET_VARS['manufacturers_id'] . "'";

 

}

 

} else {

 

// show the products in a given categorie

 

if (isset($HTTP_GET_VARS['filter_id']) && tep_not_null($HTTP_GET_VARS['filter_id'])) {

 

// We are asked to show only specific catgeory

 

$listing_sql = "select " . $select_column_list . " p.products_id, p.manufacturers_id, p.products_price, p.products_tax_class_id, IF(s.status, s.specials_new_products_price, NULL) as specials_new_products_price, IF(s.status, s.specials_new_products_price, p.products_price) as final_price from " . TABLE_PRODUCTS . " p left join " . TABLE_SPECIALS . " s on p.products_id = s.products_id, " . TABLE_PRODUCTS_DESCRIPTION . " pd, " . TABLE_MANUFACTURERS . " m, " . TABLE_PRODUCTS_TO_CATEGORIES . " p2c where p.products_status = '1' and p.manufacturers_id = m.manufacturers_id and m.manufacturers_id = '" . (int)$HTTP_GET_VARS['filter_id'] . "' and p.products_id = p2c.products_id and pd.products_id = p2c.products_id and pd.language_id = '" . (int)$languages_id . "' and p2c.categories_id = '" . (int)$current_category_id . "'";

 

} else {

 

// We show them all

 

$listing_sql = "select " . $select_column_list . " p.products_id, p.manufacturers_id, p.products_price, p.products_tax_class_id, IF(s.status, s.specials_new_products_price, NULL) as specials_new_products_price, IF(s.status, s.specials_new_products_price, p.products_price) as final_price from " . TABLE_PRODUCTS_DESCRIPTION . " pd, " . TABLE_PRODUCTS . " p left join " . TABLE_MANUFACTURERS . " m on p.manufacturers_id = m.manufacturers_id left join " . TABLE_SPECIALS . " s on p.products_id = s.products_id, " . TABLE_PRODUCTS_TO_CATEGORIES . " p2c where p.products_status = '1' and p.products_id = p2c.products_id and pd.products_id = p2c.products_id and pd.language_id = '" . (int)$languages_id . "' and p2c.categories_id = '" . (int)$current_category_id . "'";

 

}

 

}

 

 

 

if ( (!isset($HTTP_GET_VARS['sort'])) || (!ereg('[1-8][ad]', $HTTP_GET_VARS['sort'])) || (substr($HTTP_GET_VARS['sort'], 0, 1) > sizeof($column_list)) ) {

 

for ($i=0, $n=sizeof($column_list); $i<$n; $i++) {

 

if ($column_list[$i] == 'PRODUCT_LIST_NAME') {

 

$HTTP_GET_VARS['sort'] = $i+1 . 'a';

 

$listing_sql .= " order by pd.products_name";

 

break;

 

}

 

}

 

} else {

 

$sort_col = substr($HTTP_GET_VARS['sort'], 0 , 1);

 

$sort_order = substr($HTTP_GET_VARS['sort'], 1);

 

$listing_sql .= ' order by ';

 

switch ($column_list[$sort_col-1]) {

 

case 'PRODUCT_LIST_MODEL':

 

$listing_sql .= "p.products_model " . ($sort_order == 'd' ? 'desc' : '') . ", pd.products_name";

 

break;

 

case 'PRODUCT_LIST_NAME':

 

$listing_sql .= "pd.products_name " . ($sort_order == 'd' ? 'desc' : '');

 

break;

 

case 'PRODUCT_LIST_MANUFACTURER':

 

$listing_sql .= "m.manufacturers_name " . ($sort_order == 'd' ? 'desc' : '') . ", pd.products_name";

 

break;

 

case 'PRODUCT_LIST_QUANTITY':

 

$listing_sql .= "p.products_quantity " . ($sort_order == 'd' ? 'desc' : '') . ", pd.products_name";

 

break;

 

case 'PRODUCT_LIST_IMAGE':

 

$listing_sql .= "pd.products_name";

 

break;

 

case 'PRODUCT_LIST_WEIGHT':

 

$listing_sql .= "p.products_weight " . ($sort_order == 'd' ? 'desc' : '') . ", pd.products_name";

 

break;

 

case 'PRODUCT_LIST_PRICE':

 

$listing_sql .= "final_price " . ($sort_order == 'd' ? 'desc' : '') . ", pd.products_name";

 

break;

 

}

 

}

 

?>

<td width="100%" valign="top"><table border="0" width="100%" cellspacing="0" cellpadding="0">

 

<tr>

 

<td><table border="0" width="100%" cellspacing="0" cellpadding="0">

 

<tr>

 

<td class="pageHeading"><?php echo HEADING_TITLE; ?></td>

 

 

 

<?php

// optional Product List Filter

 

if (PRODUCT_LIST_FILTER > 0) {

 

if (isset($HTTP_GET_VARS['manufacturers_id'])) {

 

$filterlist_sql = "select distinct c.categories_id as id, cd.categories_name as name from " . TABLE_PRODUCTS . " p, " . TABLE_PRODUCTS_TO_CATEGORIES . " p2c, " . TABLE_CATEGORIES . " c, " . TABLE_CATEGORIES_DESCRIPTION . " cd where p.products_status = '1' and p.products_id = p2c.products_id and p2c.categories_id = c.categories_id and p2c.categories_id = cd.categories_id and cd.language_id = '" . (int)$languages_id . "' and p.manufacturers_id = '" . (int)$HTTP_GET_VARS['manufacturers_id'] . "' order by cd.categories_name";

 

} else {

 

$filterlist_sql= "select distinct m.manufacturers_id as id, m.manufacturers_name as name from " . TABLE_PRODUCTS . " p, " . TABLE_PRODUCTS_TO_CATEGORIES . " p2c, " . TABLE_MANUFACTURERS . " m where p.products_status = '1' and p.manufacturers_id = m.manufacturers_id and p.products_id = p2c.products_id and p2c.categories_id = '" . (int)$current_category_id . "' order by m.manufacturers_name";

 

}

 

$filterlist_query = tep_db_query($filterlist_sql);

 

if (tep_db_num_rows($filterlist_query) > 1) {

 

echo ' <td align="center" class="main">' . tep_draw_form('filter', FILENAME_DEFAULT, 'get') . TEXT_SHOW . ' ';

 

if (isset($HTTP_GET_VARS['manufacturers_id'])) {

 

echo tep_draw_hidden_field('manufacturers_id', $HTTP_GET_VARS['manufacturers_id']);

 

$options = array(array('id' => '', 'text' => TEXT_ALL_CATEGORIES));

 

} else {

 

echo tep_draw_hidden_field('cPath', $cPath);

 

$options = array(array('id' => '', 'text' => TEXT_ALL_MANUFACTURERS));

 

}

 

echo tep_draw_hidden_field('sort', $HTTP_GET_VARS['sort']);

 

while ($filterlist = tep_db_fetch_array($filterlist_query)) {

 

$options[] = array('id' => $filterlist['id'], 'text' => $filterlist['name']);

 

}

 

echo tep_draw_pull_down_menu('filter_id', $options, (isset($HTTP_GET_VARS['filter_id']) ? $HTTP_GET_VARS['filter_id'] : ''), 'onchange="this.form.submit()"');

 

echo '</form></td>' . "\n";

 

}

 

}

 

 

 

// Get the right image for the top-right

 

$image = DIR_WS_IMAGES . 'table_background_list.gif';

 

if (isset($HTTP_GET_VARS['manufacturers_id'])) {

 

$image = tep_db_query("select manufacturers_image from " . TABLE_MANUFACTURERS . " where manufacturers_id = '" . (int)$HTTP_GET_VARS['manufacturers_id'] . "'");

 

$image = tep_db_fetch_array($image);

 

$image = $image['manufacturers_image'];

 

} elseif ($current_category_id) {

 

$image = tep_db_query("select categories_image from " . TABLE_CATEGORIES . " where categories_id = '" . (int)$current_category_id . "'");

 

$image = tep_db_fetch_array($image);

 

$image = $image['categories_image'];

 

}

?>

<td align="right"><?php echo tep_image(DIR_WS_IMAGES . $image, HEADING_TITLE, HEADING_IMAGE_WIDTH, HEADING_IMAGE_HEIGHT); ?></td>

 

</tr>

 

</table></td>

 

</tr>

 

<tr>

 

<td><?php echo tep_draw_separator('pixel_trans.gif', '100%', '10'); ?></td>

 

</tr>

 

<tr>

 

<td><?php include(DIR_WS_MODULES . FILENAME_PRODUCT_LISTING); ?></td>

 

</tr>

 

</table></td>

 

<?php

} else { // default page

?>

 

<td width="100%" valign="top"><table border="0" width="100%" cellspacing="0" cellpadding="0">

 

<tr>

 

<td><table border="0" width="100%" cellspacing="0" cellpadding="0">

 

<tr>

 

<td class="pageHeading"><?php echo HEADING_TITLE; ?></td>

 

<td class="pageHeading" align="right"><?php echo tep_image(DIR_WS_IMAGES . 'table_background_default.gif', HEADING_TITLE, HEADING_IMAGE_WIDTH, HEADING_IMAGE_HEIGHT); ?></td>

 

</tr>

 

</table></td>

 

</tr>

 

<tr>

 

<td><?php echo tep_draw_separator('pixel_trans.gif', '100%', '10'); ?></td>

 

</tr>

 

<tr>

 

<td><table border="0" width="100%" cellspacing="0" cellpadding="0">

 

<tr>

 

<!-- Add-on - Information Pages Unlimited -->

 

<td class="main"><?php echo tep_information_customer_greeting(); ?></td>

 

</tr>

 

<tr>

 

<td><?php echo tep_draw_separator('pixel_trans.gif', '100%', '10'); ?></td>

 

</tr>

 

<tr>

 

<td class="main"><?php echo TEXT_MAIN; ?></td>

 

</tr>

 

<tr>

 

<td><?php echo tep_draw_separator('pixel_trans.gif', '100%', '10'); ?></td>

 

</tr>

 

<tr>

 

<td><?php include(DIR_WS_MODULES . FILENAME_NEW_PRODUCTS); ?></td>

 

</tr>

 

<?php

include(DIR_WS_MODULES . FILENAME_UPCOMING_PRODUCTS);

?>

 

</table></td>

 

</tr>

 

</table></td>

 

<?php

}

?>

 

<!-- body_text_eof //-->

 

<td width="<?php echo BOX_WIDTH; ?>" valign="top"><table border="0" width="<?php echo BOX_WIDTH; ?>" cellspacing="0" cellpadding="2">

 

<!-- right_navigation //-->

 

<?php require(DIR_WS_INCLUDES . 'column_right.php'); ?>

 

<!-- right_navigation_eof //-->

 

</table></td>

 

</tr>

 

</table>

 

<!-- body_eof //-->

 

 

 

<!-- footer //-->

 

<?php require(DIR_WS_INCLUDES . 'footer.php'); ?>

 

<!-- footer_eof //-->

 

<br>

 

</body>

 

</html>

 

<?php require(DIR_WS_INCLUDES . 'application_bottom.php'); ?>

 

 

Jim & Henry, Thank you very much for helping..

 

Great Day,

 

Nathali

Best Regards,

Nathali

Link to comment
Share on other sites

This one can't be solved with "code magic", IMHO.

:blush:

 

Your options defined in the DB are just too long for your page.

 

I'd change this code:

 

<td width="100%" valign="top"><table border="0" width="100%" cellspacing="0" cellpadding="0">

<tr>

<td><table border="0" width="100%" cellspacing="0" cellpadding="0">

<tr>

<td class="pageHeading"><?php echo HEADING_TITLE; ?></td> 

<?php
// optional Product List Filter

if (PRODUCT_LIST_FILTER > 0) {

if (isset($HTTP_GET_VARS['manufacturers_id'])) {

$filterlist_sql = "select distinct c.categories_id as id, cd.categories_name as name from " . TABLE_PRODUCTS . " p, " . TABLE_PRODUCTS_TO_CATEGORIES . " p2c, " . TABLE_CATEGORIES . " c, " . TABLE_CATEGORIES_DESCRIPTION . " cd where p.products_status = '1' and p.products_id = p2c.products_id and p2c.categories_id = c.categories_id and p2c.categories_id = cd.categories_id and cd.language_id = '" . (int)$languages_id . "' and p.manufacturers_id = '" . (int)$HTTP_GET_VARS['manufacturers_id'] . "' order by cd.categories_name";

To:

 

 

<td width="100%" valign="top"><table border="0" width="100%" cellspacing="0" cellpadding="0">

<tr>

<td><table border="0" width="100%" cellspacing="0" cellpadding="0">

<tr>

<td class="pageHeading"><?php echo HEADING_TITLE; ?></td> 

<!-- beginning of added code //-->

</tr>
<tr>

<!-- end of added code //-->


<?php
// optional Product List Filter

if (PRODUCT_LIST_FILTER > 0) {

if (isset($HTTP_GET_VARS['manufacturers_id'])) {

$filterlist_sql = "select distinct c.categories_id as id, cd.categories_name as name from " . TABLE_PRODUCTS . " p, " . TABLE_PRODUCTS_TO_CATEGORIES . " p2c, " . TABLE_CATEGORIES . " c, " . TABLE_CATEGORIES_DESCRIPTION . " cd where p.products_status = '1' and p.products_id = p2c.products_id and p2c.categories_id = c.categories_id and p2c.categories_id = cd.categories_id and cd.language_id = '" . (int)$languages_id . "' and p.manufacturers_id = '" . (int)$HTTP_GET_VARS['manufacturers_id'] . "' order by cd.categories_name";

The only part I changed was I added this code:

 

<!-- beginning of added code //-->

</tr>
<tr>

<!-- end of added code //-->

Then in your DB attributes alter these so they are split up at minimum by 1/2:

(presented in no particular order)

 

<option value="1848">Model: zd8010EA, zd8020EA, zd8044EA, zd8050LA, zd8052EA, zd8055us, zd8060ca, zd8060us, zd8078EA, zd8080EA, zd8080us, zd8110EA, zd8110us, zd8112EA</option>
<option value="1849">Model: zd8120cl, zd8125EA, zd8130EA, zd8147EA, zd8155EA, zd8160EA, zd8181EA, zd8185EA,  zd8202AP, zd8205US, zd8214EA, zd8220US, zd8226EA, zd8228EA, zd8230EA, zd8231EA, zd8238EA</option>
<option value="1850">Model: zd8250LA, zd8253EA, zd8280EA, zd8289EA, zd8290EA, zd8301EA, zd8305EA, zd8308EA, zd8319EA, zd8325EA, zd8350LA, zd8369EA, zd8388EA, zd8398EA, zd8460EA, zd8480EA, zd8490EA</option>
<option value="455">Model: Z8000K (Z80K), Z8100D (Z81D), Z8100G (Z81G), Z8100K (Z81K), Z8100L (Z81L)</option>
<option value="2066">Model: Z Pro (6866-11x,15x, 21x, 25x, 30x, 40x, 50x, A1x, A5x, 5Ax, 6Ax, B1x, B5x, Cox,)</option>
<option value="1837">Model: XE3 (F23xxx) C550/600/650/700, PIII 650/700/750/800/850/900</option>
<option value="1769">Model: V600t (CTO), V600z (CTO), V6012ea, V6030us, V6065ea, V6066ea</option>
<option value="1777">Model: V2618tn, V2620tn, V2625tn, V3000t (CTO), V3010ca, V3020au, V3030ca, V5000t (CTO)</option>
<option value="2150">Model: T60 (2613,2623,2637,6369,6370,6371,6372,8741,8742,8743,8744-xxx)</option>
<option value="1729">Model: t175.uk, t180 series, t190 series, t200 series, t220i/m, t230 series</option>
<option value="1728">Model: t112d, t120series, t130 series, t140 series, t150series, t160 series</option>
<option value="722">Model: SR1530KR, SR1619NL, SR1620FR, SR1629IT, SR1637NL, SR1657ES, SR1703LS, SR1705AL</option>
<option value="725">Model: SR1599AN, SR1560FR, SR1598ES, SR1599AN, SR1619ES, SR1637IT, SR1649FR, SR1649NL</option>
<option value="726">Model: SR1650AP, SR1650KR, SR1659NL, SR1670KR, SR1719ES, SR1750UK, SR1760FR, SR1769FR, SR1770KR</option>
<option value="689">Model: SR1660AN, SR1660ES, SR1667IT, SR1669ES, SR1669IT, SR1675CL, SR1675CL-B</option>
<option value="690">Model: SR1677ES, SR1677IT, SR1680TW, SR1687ES, SR1689IT, SR1699AN, SR1740FR</option>
<option value="728">Model: SR1705UK, SR1706FR, SR1707AL, SR1708AL, SR1710FR, SR1718IL, SR1720LA, SR1720TW</option>
<option value="723">Model: SR1708HL, SR1711FR, SR1712IL, SR1716IL, SR1717AL, SR1720IL, SR1722IL, SR1722X</option>
<option value="729">Model: SR1725IN, SR1728IN, SR1729UK, SR1730KR, SR1740CF, SR1740TW, SR1750KR, SR1760TW</option>
<option value="691">Model: SR1750CF, SR1750NX, SR1760AN, SR1770TW, SR1780TW, SR1790AN, SR1790CF</option>
<option value="730">Model: SR1769NL, SR1770CF, SR1780CF, SR1900AP, SR1920AN, SR1920AP, SR1920FR, SR1920IL</option>
<option value="692">Model: SR1802FR, SR1802HM, SR1810NX, SR1819IT, SR1819UK, SR1820FR, SR1820NX</option>
<option value="693">Model: SR1840FR, SR1859NL, SR1867ES, SR1900Z (CTO), SR1920NX, SR1930Z (CTO)</option>
<option value="731">Model: SR1920LA, SR1930AP, SR1930IL, SR2002X, SV2050KR, SR1939UK, SR1949ES, SR1949NL</option>
<option value="1826">Model: SR5002HM, SR5003FR, SR5010NL, SR5010NX, SR5012AL, SR5013AP, SR5013HK</option>
<option value="1827">Model: SR5015AP, SR5020AN, SR5023HK, SR5025AN, SR5027UK, SR5030NX, SR5050NX</option>
<option value="1344">Model: S2110, S6130, S6210, S6220, S6230, S7010, S7010D, S7011, T4010, T4010D</option>
<option value="2178">Model: R51 Pentium M (1829/1830/1831/1836/2883/2887/2888/2889/2894/2895-xxx)</option>
<option value="2147">Model: R60 (9444,9445,9446,9455,9456,9457,9459,9460,9461,9462,9464-xxx)</option>
<option value="250">Model: RC550, RC810, SA60, SA80, SA85, T120E, T130, T135, T140, T320</option>
<option value="1280">Model: Pro V2030, V2035, V2040 Edition, V2045 Edition, V2055, V2060, V2065, V2085</option>
<option value="1800">Model: Pavilion a1000.dk, a1000.fl, a1005.uk, a1008.dk, a1010.dk, a1011.tw, a1022n, a1118x, a450e (CTO)</option>
<option value="1802">Model: Pavilion a1009.fl, a1010.uk, a1012.tw, a1018.dk, a1020.uk, a1020a, a1020in, a1025.dk, a1029.uk, a1030.dk</option>
<option value="1803">Model: Pavilion a1030e (CTO), a1030l, a1035d, a1040a, a1050y (CTO), a1060a, a1068hk, a1107kr, a1108.uk</option>
<option value="1804">Model: Pavilion a1109.it, a1109kr, a1110.dk, a1119.dk, a1128.uk, a1129n, a1130n, a1132n, a1140a, a1160a</option>
<option value="1801">Model: Pavilion a450n, a450y (CTO), a475c, a550.nl, a550e (CTO), a550y (CTO)</option>
<option value="843">Model: Pentium Pro, 5166X/2150, 5200X/4200/PDS, 6266/4200/CDS, 6233/2150/PDS</option>
<option value="1763">Model: nc4200, nc6200 series (nc6220, nc6230), nc8200 series (nc8230)</option>
<option value="1999">Model: M52 (8110, 8111, 8112, 8113, 8114, 8115, 8211, 8212, 8213, 8214, 8215-xxx)</option>
<option value="1990">Model: M55 (8009, 8010, 8791, 8792, 8795, 8796, 8799, 8800, 8803, 8804, 8807, 8808, 8812, 8813, 8814-xxx)</option>
<option value="1991">Model: M55e (9278, 9279, 9288, 9379, 9380, 9389, 9632, 9637, 9642, 9644, 9645-xxx)</option>
<option value="1994">Model: M55p (8792, 8794, 8796, 8798, 8800, 8802, 8804, 8806, 8808, 8811-xxx)</option>
<option value="2058">Model: M42 (6290, 8181, 8182-xxx, 8301, 8302, 8303, 8304, 8305, 8306, 8307, 8308-xxx)</option>
<option value="2590">Model: M50 (101, 142, 143, 148, 159, 176, 181, 182, 183, 196, 215, 226, 231)</option>
<option value="2001">Model: M50 (8185, 8186, 8187, 8188, 8189, 8190, 8413, 8414, 8415-xxx)</option>
<option value="2585">Model: M40 (140, 142, 145, 149, 150, 152, 154, 183, 184, 185, 192, 197)</option>
<option value="2586">Model: M40 (221, 225, 230, 231, 232, 236, 237, 238, 239, 241, 243, 245, 250)</option>
<option value="2587">Model: M40 (JM3, JM8, P535, P5351, P545, S417TD, S4172TD, SF3, YP3, 037009, 038009, 03K009)</option>
<option value="827">Model: M2045AP, M2046EA, M2052EA, M2054EA, M2055EA, M2065EA, M2075EA</option>
<option value="828">Model: M2201AP, M2203AP, M2207AP, M2211AP, M2212AP, M2213AP, M2215AP, M2216AP, M2217AP</option>
<option value="829">Model: M2230AP, M2232AP, M2233AP, M2247AP, M2254AP, M2254AU, M2512AU, M2515TU</option>
<option value="1288">Model: L1300, L1310, L1310D, L1310G, L7300, L7300G, L7310, M1420, M1424, M1425, M7405</option>
<option value="590">Model: Intel Core 2 Duo 20" 2GHz,  2.4GHz,  24" 2.4GHz,  24" Intel Core 2 Extreme  2.8GHz</option>
<option value="757">Model: F506LA, F550EF, F550EO, F550ET, F551AU, F552AU, F552LA, F553AU, F553CL, F553US</option>
<option value="758">Model: F554AU, F555AU, F555US, F557US, F557WM, F558US, F560ET, F560US, F562LA, F564LA</option>
<option value="759">Model: F571AU, F573AU, F577CL, F579WM, G5002EA, G5003EA, G5009EA, G5040EA, G5052EA, G5055EA</option>
<option value="405">Model: F3 series F3F, F3H, F3Ja, F3Jc, F3H, F3Ja, F3Jm, F3Jp, F3Jv, F3M, F3T</option>
<option value="2395">Model: E3100, E6200, E6201, E6210, E6211, M360, P7200, P8100, P8210, S5200</option>
<option value="1847">Model: dv1000t Series (CTO), dv1330BR, dv1340BR, dv4201TX, dv4273EA, dv4280EA, dv4290EA, dv4295EA</option>
<option value="1753">Model: dv4205tu, dv4205tx, dv4206tx, dv4208tx, dv4209tx, dv4210tx, dv4211tx, dv4212tx, dv4213ap, dv4215ap</option>
<option value="1754">Model: dv4217cl, dv4220tx, dv4224ea, dv4224tx, dv4225ea, dv4225tx, dv4250ca, dv4250us, dv4270ca, dv4270us</option>
<option value="1851">Model: dv4307ca, dv4307cl, dv4310us, dv4320us, dv4325EA, dv4326EA, dv4330ca, dv4330us, dv4335nr</option>
<option value="1852">Model: dv4340ca, dv4340us, dv4358EA, dv4376EA, dv4384EA, dv4395EA</option>
<option value="1784">Model: dv5123cl, dv5129us, dv5130us, dv5135nr, dv5139us, dv5140us, dv8113cl</option>
<option value="1780">Model: dv8210 tx, dv8212tx, dv8216tx, dv8218ea, dv8219ea, dv8226ea, dv8227ea, dv8228ea, dv8229ea</option>
<option value="1783">Model: dv8210us, dv8213cl, dv8220ca, dv8220us, dv8225nr, dv8240us, zv6243ea, zv6273ea</option>
<option value="1781">Model: dv8230ea, dv8230ca, dv8231ea, dv8232ea, dv8233ea, dv8235ea, dv8275la, dv8284ea</option>
<option value="1750">Model: dv9000t (CTO), dv9000z (CTO), dv9005ea, dv9005us, dv9007tx, dv9008tx, dv9010us, dv9015ea</option>
<option value="1751">Model: dv9018tx, dv9023us, dv9024ea, dv9030us, dv9040us, dv9043ea, dv9044ea, dv9047ea, dv9054ea</option>
<option value="1752">Model: dv9056ea, dv9060us, dv9065ea, dv9074ea, dv9076ea, dv9095ea</option>
<option value="752">Model: C301NR, C301TU, C302NR, C302TU, C304NR, C305LA, C306US, C307TU, C310TU</option>
<option value="746">Model: C307NR, C555EA, C555EM, C555EU, C571EA, F502EA, F502EU,<br> F504EM, F504EU, F545EA, F545EU, V6314EA, V6314EM, V6325EA, V6325EM</option>
<option value="753">Model: C315LA, C318LA, C500EA, C500EU, C501NR, C502CA, C502US, C503WM, C504EA</option>
<option value="754">Model: C506CA, C507US, C508US, C509NR, C518LA, C540EA, C551NR, C552CA, C552US</option>
<option value="755">Model: C554TU, C554US, C556CA, C557CL, C558US, C560US, C561TU, C563NR, C568LA</option>
<option value="756">Model: C570EA, C571NR, C571TU, C582TU, F500EA, F501AU, F502AU, F505AU, F505EA, F505LA</option>
<option value="760">Model: B1801TU, B1805TU, B1809TU, B1810TU, B1813TU, B1817TU, B1818TU, B1821TU, B1822TU, V2000T Series (CTO)</option>
<option value="748">Model: B1900 Series (CTO), B1901JP, B1901TU, B1907TU, B1908TU, B1909TU, B1910TU, B1911TU</option>
<option value="749">Model: B1912TU, B1915TU, B1916TU, B1919TU, B1920TU, B1921TU, B1922TU, B1927TU, B1928TU</option>
<option value="750">Model: B1931TU, B1933TU, B1950TU, B1951TU, B1954TU, B1956TU, B1957TU, B1958TU, B1959TU</option>
<option value="751">Model: B1960TU, B1962TU, B1965TU, B1967TU, B1969TU, B1973TU, B1985TU</option>
<option value="1997">Model: A52 (8153, 8154, 8166, 8167, 8168, 8169, 8170-xxx), (8161, 8162, 8163, 8164, 8165-xxx)</option>
<option value="1998">Model: A52 (8287, 8296, 8327, 8340, 8343, 8381, 8782, 8783, 8784, 8785, 8786, 8788-xxx)</option>
<option value="1995">Model: A52 (8288, 8289, 8297, 8298, 8326, 8328, 8329-xxx), (8341, 8342, 8344-xxx), (8380, 8382-xxx)</option>
<option value="1996">Model: A53 (8701, 8702, 8973, 8980, 8983, 8992, 8995, 9276, 9277, 9286, 9287, 9378, 9387, 9628, 9635-xxx)</option>
<option value="1987">Model: A55 (8705, 8706, 8972, 8975, 8982, 8985, 8994, 9265, 9636, 9640, 9641-xxx)</option>
<option value="2580">Model: A55 (S106, S1063, S1065, S1066, S129, S1271, S1291, S139,  S1391, S179, S306, s3061, S3062)</option>
<option value="1988">Model: A60 (8013, 8700, 8976, 8979, 8986, 8991, 9266, 9269, 9282, 9283, 9374, 9383, 9384, 9631-xxx)</option>
<option value="400">Model: A6000J (A6J), A6000Ja (A6Ja), A7000J (A7J), A7000Jb (A7Jb), A7000Jc (A7Jc)</option>
<option value="399">Model: A7000G (A7G), A7000Gb (A7Gb), A7000Gc (A7Gc), A7000Vb (A7Vb), A7000Vc (A7Vc)</option>
<option value="2003">Model: A51 (8122, 8123, 8124, 8129, 8131, 8132, 8133, 8134, 8135, 8136, 8137, 8138, 9212-xxx)</option>
<option value="1794">Model: a1000.dk, a1000.fl, a1005.uk, a1008.dk, a1010.dk, a1011.tw, a1022n, a1118x, a450e (CTO)</option>
<option value="1796">Model: a1009.fl, a1010.uk, a1012.tw, a1018.dk, a1020.uk, a1020a, a1020in, a1025.dk, a1029.uk, a1030.dk</option>
<option value="1797">Model: a1030e (CTO), a1030l, a1035d, a1040a, a1050y (CTO), a1060a, a1068hk, a1107kr, a1108.uk</option>
<option value="1823">Model: a1100y (CTO), a1112kr, a1119.pt, a1120a, a1130.dk, a1200il, a1200y (CTO), a1210.be, a1220a</option>
<option value="1798">Model: a1109.it, a1109kr, a1110.dk, a1119.dk, a1128.uk, a1129n, a1130n, a1132n, a1140a, a1160a</option>
<option value="1807">Model: 856x, 876x, 896c, m200y, m270, m270n, m280n, m300y, m376n, m377n</option>
<option value="515">Model: 8100 (8101,8103,8104,8106), C200 Tablet (202,204), C310 Tablet (C311,C312,C313,C314)</option>
<option value="2642">Model: 8000 Pentium II 233, 266, 300, 366, 400 models, Celeron 333, 400Mhz.</option>
<option value="494">Model: 610 (610TXVi,611/611-TXC/TXCi/TXCi-D/TXV,612 / 612TXVI,613,614)</option>
<option value="2767">Model: 6350 / 6350DP / 6350DT / 6350YDP / 7400 / 7400N / 7400DT / 7400DX</option>
<option value="949">Model: 5900 Z; 5060; 5062; 5070; 5100C-400; 5130; 5137; 5140; 5151; 5152; 5155; 5166; 5170; 5176</option>
<option value="953">Model: 5676; 5630; 5635; 5640; 5650; 5600i 450/3; 5600i series; 5600s 400/450; 5610; 5612; 5736</option>
<option value="954">Model: 5738; 5745; 5686; 5690; 5695; 5696; 5838; 5831; 5852; 5855; 5858; 5861; 5868; 5875; 5888</option>
<option value="956">Model: 5542; 5543; 5700N series; 5711(Celeron); 5712(Celeron); 5714(Celeron); 5715(Celeron)</option>
<option value="950">Model: 5180; 5184; 5185; 5186; 5190; 5192; 5202; 5203; 5204; 5220; 5221; 5222; 5225; 5240; 5242</option>
<option value="951">Model: 5245; 5260; 5270; 5280; 5282; 8284; 5285; 5286; 5290; 5296; 5301; 5303; 5304; 5330; 5340</option>
<option value="952">Model: 5345; 5352; 5360; 5365; 5440; 5677; 5441; 5460; 5461; 5465; 5540; 5546; 5660; 5665; 5670</option>
<option value="955">Model: 5346; 5396; 5452; 5471; 5473; 5474; 5475; 5476; 5477; 5504; 5520; 5521; 5530; 5531; 5541</option>
<option value="718">Model: 5005R; 5006CA/H; 5123; 5109; 5101; 5105; 5106; 5103; 5007; 5108; 5560; 5561; 5563; 5564</option>
<option value="514">Model: 4020 (4021), 4060 (4061,4062,4064), 4150 (4151,4152,4154), 4650 (4651,4652,4654)</option>
<option value="1983">Model: 3000 J100 Series (8255, 8256-xxx), 3000 Q100 Series (8822-xxx)</option>
<option value="2110">Model: 3000 N100 Series (0689, 0768-xxx), 3000 C200 Series (8922-xxx)</option>
<option value="513">Model: 2400 (2403), 2410 (2413,2419), 3000 (3002,3004), 3210 (3211,3212), 3220 (3222)</option>
<option value="508">Model: 2020 (2023,2025,2026), 3000 (3002,3003), 3020 (3022,3023), 3500 (3502,3503)</option>
<option value="839">Model: 2000 5133/2500/CD, 5166/1200, 5166/2500, 5166/2500/CD, 5200/2500</option>
<option value="709">Model: 17XL360/ 365/ 375/ 262/ 362/ 462/ 260/ 265/ 275/ 1700XL/ 1720CA/ 1715CA</option>
<option value="505">Model: 1620 (1621,1622,1623,1624), 1660 (1661,1662,1663,1664), 1670 (1671,1672,1673,1674)</option>
<option value="510">Model: 1640 (1644), 1650, 1690 (DDR2), 3600 (3603,3608), 3610 (3613), 5500 (5502), 5510 (5512,5513)</option>
<option value="507">Model: 1690 (DDR), 1800 (1801,1802,1804), 2000 (2001,2002,2003,2012), 2010 (2012)</option>
<option value="743">Model: 1700 Series (1700T/1700AU/1720US)(1711CL/1712TC/1712US/1714TC)</option>
<option value="695">Model: 1600 XL Series / 1600S/ 1670/ 1672/ 1675/ 1685/ 1687/ 1688/ 1690/ 1692/ 1693/ 1694</option>
<option value="557">Model: 13" 1.83GHz / 2GHz (Intel Core Duo), 13" 1.83GHz / 2GHz / 2.16GHz (Intel Core 2 Duo)</option>
<option value="503">Model: 1310 (1310,1312,1314,1315), 1410 (1414), 1500 (1501,1502), 1600 (1601,1603,1604,1605)</option>
<option value="504">Model: 1350 (1351, 1352, 1353, 1355, 1356, 1357), 1360 (1362), 1450, 1510 (1511,1513), 1520</option>
<option value="2053">Model:  ZPro (6866-14x, 16x, 24x, 26x, 27x, 31x, 34x, 41x, 44x, A4x, A6x, 5xx, 6xx, B4x, B6x, B7x, C1x)</option>

The longest "option" can only be about this long before it makes the page go out of alignment:

 

<option value="xxxx">xxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxx</option>

I know this isn't what you wanted to hear, but it's simply a case of trying to show too much data in too small a place.

 

You need to make some of the lines of data shorter, and more of them.

 

That's my assessment of the situation.

If I suggest you edit any file(s) make a backup first - I'm not perfect and neither are you.

 

"Given enough impetus a parallelogramatically shaped projectile can egress a circular orifice."

- Me -

 

"Headers already sent" - The definitive help

 

"Cannot redeclare ..." - How to find/fix it

 

SSL Implementation Help

 

Like this post? "Like" it again over there >

Link to comment
Share on other sites

This one can't be solved with "code magic", IMHO.

:blush:

 

Your options defined in the DB are just too long for your page.

 

I'd change this code:

 

<td width="100%" valign="top"><table border="0" width="100%" cellspacing="0" cellpadding="0">

<tr>

<td><table border="0" width="100%" cellspacing="0" cellpadding="0">

<tr>

<td class="pageHeading"><?php echo HEADING_TITLE; ?></td> 

<?php
// optional Product List Filter

if (PRODUCT_LIST_FILTER > 0) {

if (isset($HTTP_GET_VARS['manufacturers_id'])) {

$filterlist_sql = "select distinct c.categories_id as id, cd.categories_name as name from " . TABLE_PRODUCTS . " p, " . TABLE_PRODUCTS_TO_CATEGORIES . " p2c, " . TABLE_CATEGORIES . " c, " . TABLE_CATEGORIES_DESCRIPTION . " cd where p.products_status = '1' and p.products_id = p2c.products_id and p2c.categories_id = c.categories_id and p2c.categories_id = cd.categories_id and cd.language_id = '" . (int)$languages_id . "' and p.manufacturers_id = '" . (int)$HTTP_GET_VARS['manufacturers_id'] . "' order by cd.categories_name";

To:

 

 

<td width="100%" valign="top"><table border="0" width="100%" cellspacing="0" cellpadding="0">

<tr>

<td><table border="0" width="100%" cellspacing="0" cellpadding="0">

<tr>

<td class="pageHeading"><?php echo HEADING_TITLE; ?></td> 

<!-- beginning of added code //-->

</tr>
<tr>

<!-- end of added code //-->


<?php
// optional Product List Filter

if (PRODUCT_LIST_FILTER > 0) {

if (isset($HTTP_GET_VARS['manufacturers_id'])) {

$filterlist_sql = "select distinct c.categories_id as id, cd.categories_name as name from " . TABLE_PRODUCTS . " p, " . TABLE_PRODUCTS_TO_CATEGORIES . " p2c, " . TABLE_CATEGORIES . " c, " . TABLE_CATEGORIES_DESCRIPTION . " cd where p.products_status = '1' and p.products_id = p2c.products_id and p2c.categories_id = c.categories_id and p2c.categories_id = cd.categories_id and cd.language_id = '" . (int)$languages_id . "' and p.manufacturers_id = '" . (int)$HTTP_GET_VARS['manufacturers_id'] . "' order by cd.categories_name";

The only part I changed was I added this code:

 

<!-- beginning of added code //-->

</tr>
<tr>

<!-- end of added code //-->

Then in your DB attributes alter these so they are split up at minimum by 1/2:

(presented in no particular order)

 

<option value="1848">Model: zd8010EA, zd8020EA, zd8044EA, zd8050LA, zd8052EA, zd8055us, zd8060ca, zd8060us, zd8078EA, zd8080EA, zd8080us, zd8110EA, zd8110us, zd8112EA</option>
<option value="1849">Model: zd8120cl, zd8125EA, zd8130EA, zd8147EA, zd8155EA, zd8160EA, zd8181EA, zd8185EA,  zd8202AP, zd8205US, zd8214EA, zd8220US, zd8226EA, zd8228EA, zd8230EA, zd8231EA, zd8238EA</option>
<option value="1850">Model: zd8250LA, zd8253EA, zd8280EA, zd8289EA, zd8290EA, zd8301EA, zd8305EA, zd8308EA, zd8319EA, zd8325EA, zd8350LA, zd8369EA, zd8388EA, zd8398EA, zd8460EA, zd8480EA, zd8490EA</option>
<option value="455">Model: Z8000K (Z80K), Z8100D (Z81D), Z8100G (Z81G), Z8100K (Z81K), Z8100L (Z81L)</option>
<option value="2066">Model: Z Pro (6866-11x,15x, 21x, 25x, 30x, 40x, 50x, A1x, A5x, 5Ax, 6Ax, B1x, B5x, Cox,)</option>
<option value="1837">Model: XE3 (F23xxx) C550/600/650/700, PIII 650/700/750/800/850/900</option>
<option value="1769">Model: V600t (CTO), V600z (CTO), V6012ea, V6030us, V6065ea, V6066ea</option>
<option value="1777">Model: V2618tn, V2620tn, V2625tn, V3000t (CTO), V3010ca, V3020au, V3030ca, V5000t (CTO)</option>
<option value="2150">Model: T60 (2613,2623,2637,6369,6370,6371,6372,8741,8742,8743,8744-xxx)</option>
<option value="1729">Model: t175.uk, t180 series, t190 series, t200 series, t220i/m, t230 series</option>
<option value="1728">Model: t112d, t120series, t130 series, t140 series, t150series, t160 series</option>
<option value="722">Model: SR1530KR, SR1619NL, SR1620FR, SR1629IT, SR1637NL, SR1657ES, SR1703LS, SR1705AL</option>
<option value="725">Model: SR1599AN, SR1560FR, SR1598ES, SR1599AN, SR1619ES, SR1637IT, SR1649FR, SR1649NL</option>
<option value="726">Model: SR1650AP, SR1650KR, SR1659NL, SR1670KR, SR1719ES, SR1750UK, SR1760FR, SR1769FR, SR1770KR</option>
<option value="689">Model: SR1660AN, SR1660ES, SR1667IT, SR1669ES, SR1669IT, SR1675CL, SR1675CL-B</option>
<option value="690">Model: SR1677ES, SR1677IT, SR1680TW, SR1687ES, SR1689IT, SR1699AN, SR1740FR</option>
<option value="728">Model: SR1705UK, SR1706FR, SR1707AL, SR1708AL, SR1710FR, SR1718IL, SR1720LA, SR1720TW</option>
<option value="723">Model: SR1708HL, SR1711FR, SR1712IL, SR1716IL, SR1717AL, SR1720IL, SR1722IL, SR1722X</option>
<option value="729">Model: SR1725IN, SR1728IN, SR1729UK, SR1730KR, SR1740CF, SR1740TW, SR1750KR, SR1760TW</option>
<option value="691">Model: SR1750CF, SR1750NX, SR1760AN, SR1770TW, SR1780TW, SR1790AN, SR1790CF</option>
<option value="730">Model: SR1769NL, SR1770CF, SR1780CF, SR1900AP, SR1920AN, SR1920AP, SR1920FR, SR1920IL</option>
<option value="692">Model: SR1802FR, SR1802HM, SR1810NX, SR1819IT, SR1819UK, SR1820FR, SR1820NX</option>
<option value="693">Model: SR1840FR, SR1859NL, SR1867ES, SR1900Z (CTO), SR1920NX, SR1930Z (CTO)</option>
<option value="731">Model: SR1920LA, SR1930AP, SR1930IL, SR2002X, SV2050KR, SR1939UK, SR1949ES, SR1949NL</option>
<option value="1826">Model: SR5002HM, SR5003FR, SR5010NL, SR5010NX, SR5012AL, SR5013AP, SR5013HK</option>
<option value="1827">Model: SR5015AP, SR5020AN, SR5023HK, SR5025AN, SR5027UK, SR5030NX, SR5050NX</option>
<option value="1344">Model: S2110, S6130, S6210, S6220, S6230, S7010, S7010D, S7011, T4010, T4010D</option>
<option value="2178">Model: R51 Pentium M (1829/1830/1831/1836/2883/2887/2888/2889/2894/2895-xxx)</option>
<option value="2147">Model: R60 (9444,9445,9446,9455,9456,9457,9459,9460,9461,9462,9464-xxx)</option>
<option value="250">Model: RC550, RC810, SA60, SA80, SA85, T120E, T130, T135, T140, T320</option>
<option value="1280">Model: Pro V2030, V2035, V2040 Edition, V2045 Edition, V2055, V2060, V2065, V2085</option>
<option value="1800">Model: Pavilion a1000.dk, a1000.fl, a1005.uk, a1008.dk, a1010.dk, a1011.tw, a1022n, a1118x, a450e (CTO)</option>
<option value="1802">Model: Pavilion a1009.fl, a1010.uk, a1012.tw, a1018.dk, a1020.uk, a1020a, a1020in, a1025.dk, a1029.uk, a1030.dk</option>
<option value="1803">Model: Pavilion a1030e (CTO), a1030l, a1035d, a1040a, a1050y (CTO), a1060a, a1068hk, a1107kr, a1108.uk</option>
<option value="1804">Model: Pavilion a1109.it, a1109kr, a1110.dk, a1119.dk, a1128.uk, a1129n, a1130n, a1132n, a1140a, a1160a</option>
<option value="1801">Model: Pavilion a450n, a450y (CTO), a475c, a550.nl, a550e (CTO), a550y (CTO)</option>
<option value="843">Model: Pentium Pro, 5166X/2150, 5200X/4200/PDS, 6266/4200/CDS, 6233/2150/PDS</option>
<option value="1763">Model: nc4200, nc6200 series (nc6220, nc6230), nc8200 series (nc8230)</option>
<option value="1999">Model: M52 (8110, 8111, 8112, 8113, 8114, 8115, 8211, 8212, 8213, 8214, 8215-xxx)</option>
<option value="1990">Model: M55 (8009, 8010, 8791, 8792, 8795, 8796, 8799, 8800, 8803, 8804, 8807, 8808, 8812, 8813, 8814-xxx)</option>
<option value="1991">Model: M55e (9278, 9279, 9288, 9379, 9380, 9389, 9632, 9637, 9642, 9644, 9645-xxx)</option>
<option value="1994">Model: M55p (8792, 8794, 8796, 8798, 8800, 8802, 8804, 8806, 8808, 8811-xxx)</option>
<option value="2058">Model: M42 (6290, 8181, 8182-xxx, 8301, 8302, 8303, 8304, 8305, 8306, 8307, 8308-xxx)</option>
<option value="2590">Model: M50 (101, 142, 143, 148, 159, 176, 181, 182, 183, 196, 215, 226, 231)</option>
<option value="2001">Model: M50 (8185, 8186, 8187, 8188, 8189, 8190, 8413, 8414, 8415-xxx)</option>
<option value="2585">Model: M40 (140, 142, 145, 149, 150, 152, 154, 183, 184, 185, 192, 197)</option>
<option value="2586">Model: M40 (221, 225, 230, 231, 232, 236, 237, 238, 239, 241, 243, 245, 250)</option>
<option value="2587">Model: M40 (JM3, JM8, P535, P5351, P545, S417TD, S4172TD, SF3, YP3, 037009, 038009, 03K009)</option>
<option value="827">Model: M2045AP, M2046EA, M2052EA, M2054EA, M2055EA, M2065EA, M2075EA</option>
<option value="828">Model: M2201AP, M2203AP, M2207AP, M2211AP, M2212AP, M2213AP, M2215AP, M2216AP, M2217AP</option>
<option value="829">Model: M2230AP, M2232AP, M2233AP, M2247AP, M2254AP, M2254AU, M2512AU, M2515TU</option>
<option value="1288">Model: L1300, L1310, L1310D, L1310G, L7300, L7300G, L7310, M1420, M1424, M1425, M7405</option>
<option value="590">Model: Intel Core 2 Duo 20" 2GHz,  2.4GHz,  24" 2.4GHz,  24" Intel Core 2 Extreme  2.8GHz</option>
<option value="757">Model: F506LA, F550EF, F550EO, F550ET, F551AU, F552AU, F552LA, F553AU, F553CL, F553US</option>
<option value="758">Model: F554AU, F555AU, F555US, F557US, F557WM, F558US, F560ET, F560US, F562LA, F564LA</option>
<option value="759">Model: F571AU, F573AU, F577CL, F579WM, G5002EA, G5003EA, G5009EA, G5040EA, G5052EA, G5055EA</option>
<option value="405">Model: F3 series F3F, F3H, F3Ja, F3Jc, F3H, F3Ja, F3Jm, F3Jp, F3Jv, F3M, F3T</option>
<option value="2395">Model: E3100, E6200, E6201, E6210, E6211, M360, P7200, P8100, P8210, S5200</option>
<option value="1847">Model: dv1000t Series (CTO), dv1330BR, dv1340BR, dv4201TX, dv4273EA, dv4280EA, dv4290EA, dv4295EA</option>
<option value="1753">Model: dv4205tu, dv4205tx, dv4206tx, dv4208tx, dv4209tx, dv4210tx, dv4211tx, dv4212tx, dv4213ap, dv4215ap</option>
<option value="1754">Model: dv4217cl, dv4220tx, dv4224ea, dv4224tx, dv4225ea, dv4225tx, dv4250ca, dv4250us, dv4270ca, dv4270us</option>
<option value="1851">Model: dv4307ca, dv4307cl, dv4310us, dv4320us, dv4325EA, dv4326EA, dv4330ca, dv4330us, dv4335nr</option>
<option value="1852">Model: dv4340ca, dv4340us, dv4358EA, dv4376EA, dv4384EA, dv4395EA</option>
<option value="1784">Model: dv5123cl, dv5129us, dv5130us, dv5135nr, dv5139us, dv5140us, dv8113cl</option>
<option value="1780">Model: dv8210 tx, dv8212tx, dv8216tx, dv8218ea, dv8219ea, dv8226ea, dv8227ea, dv8228ea, dv8229ea</option>
<option value="1783">Model: dv8210us, dv8213cl, dv8220ca, dv8220us, dv8225nr, dv8240us, zv6243ea, zv6273ea</option>
<option value="1781">Model: dv8230ea, dv8230ca, dv8231ea, dv8232ea, dv8233ea, dv8235ea, dv8275la, dv8284ea</option>
<option value="1750">Model: dv9000t (CTO), dv9000z (CTO), dv9005ea, dv9005us, dv9007tx, dv9008tx, dv9010us, dv9015ea</option>
<option value="1751">Model: dv9018tx, dv9023us, dv9024ea, dv9030us, dv9040us, dv9043ea, dv9044ea, dv9047ea, dv9054ea</option>
<option value="1752">Model: dv9056ea, dv9060us, dv9065ea, dv9074ea, dv9076ea, dv9095ea</option>
<option value="752">Model: C301NR, C301TU, C302NR, C302TU, C304NR, C305LA, C306US, C307TU, C310TU</option>
<option value="746">Model: C307NR, C555EA, C555EM, C555EU, C571EA, F502EA, F502EU,<br> F504EM, F504EU, F545EA, F545EU, V6314EA, V6314EM, V6325EA, V6325EM</option>
<option value="753">Model: C315LA, C318LA, C500EA, C500EU, C501NR, C502CA, C502US, C503WM, C504EA</option>
<option value="754">Model: C506CA, C507US, C508US, C509NR, C518LA, C540EA, C551NR, C552CA, C552US</option>
<option value="755">Model: C554TU, C554US, C556CA, C557CL, C558US, C560US, C561TU, C563NR, C568LA</option>
<option value="756">Model: C570EA, C571NR, C571TU, C582TU, F500EA, F501AU, F502AU, F505AU, F505EA, F505LA</option>
<option value="760">Model: B1801TU, B1805TU, B1809TU, B1810TU, B1813TU, B1817TU, B1818TU, B1821TU, B1822TU, V2000T Series (CTO)</option>
<option value="748">Model: B1900 Series (CTO), B1901JP, B1901TU, B1907TU, B1908TU, B1909TU, B1910TU, B1911TU</option>
<option value="749">Model: B1912TU, B1915TU, B1916TU, B1919TU, B1920TU, B1921TU, B1922TU, B1927TU, B1928TU</option>
<option value="750">Model: B1931TU, B1933TU, B1950TU, B1951TU, B1954TU, B1956TU, B1957TU, B1958TU, B1959TU</option>
<option value="751">Model: B1960TU, B1962TU, B1965TU, B1967TU, B1969TU, B1973TU, B1985TU</option>
<option value="1997">Model: A52 (8153, 8154, 8166, 8167, 8168, 8169, 8170-xxx), (8161, 8162, 8163, 8164, 8165-xxx)</option>
<option value="1998">Model: A52 (8287, 8296, 8327, 8340, 8343, 8381, 8782, 8783, 8784, 8785, 8786, 8788-xxx)</option>
<option value="1995">Model: A52 (8288, 8289, 8297, 8298, 8326, 8328, 8329-xxx), (8341, 8342, 8344-xxx), (8380, 8382-xxx)</option>
<option value="1996">Model: A53 (8701, 8702, 8973, 8980, 8983, 8992, 8995, 9276, 9277, 9286, 9287, 9378, 9387, 9628, 9635-xxx)</option>
<option value="1987">Model: A55 (8705, 8706, 8972, 8975, 8982, 8985, 8994, 9265, 9636, 9640, 9641-xxx)</option>
<option value="2580">Model: A55 (S106, S1063, S1065, S1066, S129, S1271, S1291, S139,  S1391, S179, S306, s3061, S3062)</option>
<option value="1988">Model: A60 (8013, 8700, 8976, 8979, 8986, 8991, 9266, 9269, 9282, 9283, 9374, 9383, 9384, 9631-xxx)</option>
<option value="400">Model: A6000J (A6J), A6000Ja (A6Ja), A7000J (A7J), A7000Jb (A7Jb), A7000Jc (A7Jc)</option>
<option value="399">Model: A7000G (A7G), A7000Gb (A7Gb), A7000Gc (A7Gc), A7000Vb (A7Vb), A7000Vc (A7Vc)</option>
<option value="2003">Model: A51 (8122, 8123, 8124, 8129, 8131, 8132, 8133, 8134, 8135, 8136, 8137, 8138, 9212-xxx)</option>
<option value="1794">Model: a1000.dk, a1000.fl, a1005.uk, a1008.dk, a1010.dk, a1011.tw, a1022n, a1118x, a450e (CTO)</option>
<option value="1796">Model: a1009.fl, a1010.uk, a1012.tw, a1018.dk, a1020.uk, a1020a, a1020in, a1025.dk, a1029.uk, a1030.dk</option>
<option value="1797">Model: a1030e (CTO), a1030l, a1035d, a1040a, a1050y (CTO), a1060a, a1068hk, a1107kr, a1108.uk</option>
<option value="1823">Model: a1100y (CTO), a1112kr, a1119.pt, a1120a, a1130.dk, a1200il, a1200y (CTO), a1210.be, a1220a</option>
<option value="1798">Model: a1109.it, a1109kr, a1110.dk, a1119.dk, a1128.uk, a1129n, a1130n, a1132n, a1140a, a1160a</option>
<option value="1807">Model: 856x, 876x, 896c, m200y, m270, m270n, m280n, m300y, m376n, m377n</option>
<option value="515">Model: 8100 (8101,8103,8104,8106), C200 Tablet (202,204), C310 Tablet (C311,C312,C313,C314)</option>
<option value="2642">Model: 8000 Pentium II 233, 266, 300, 366, 400 models, Celeron 333, 400Mhz.</option>
<option value="494">Model: 610 (610TXVi,611/611-TXC/TXCi/TXCi-D/TXV,612 / 612TXVI,613,614)</option>
<option value="2767">Model: 6350 / 6350DP / 6350DT / 6350YDP / 7400 / 7400N / 7400DT / 7400DX</option>
<option value="949">Model: 5900 Z; 5060; 5062; 5070; 5100C-400; 5130; 5137; 5140; 5151; 5152; 5155; 5166; 5170; 5176</option>
<option value="953">Model: 5676; 5630; 5635; 5640; 5650; 5600i 450/3; 5600i series; 5600s 400/450; 5610; 5612; 5736</option>
<option value="954">Model: 5738; 5745; 5686; 5690; 5695; 5696; 5838; 5831; 5852; 5855; 5858; 5861; 5868; 5875; 5888</option>
<option value="956">Model: 5542; 5543; 5700N series; 5711(Celeron); 5712(Celeron); 5714(Celeron); 5715(Celeron)</option>
<option value="950">Model: 5180; 5184; 5185; 5186; 5190; 5192; 5202; 5203; 5204; 5220; 5221; 5222; 5225; 5240; 5242</option>
<option value="951">Model: 5245; 5260; 5270; 5280; 5282; 8284; 5285; 5286; 5290; 5296; 5301; 5303; 5304; 5330; 5340</option>
<option value="952">Model: 5345; 5352; 5360; 5365; 5440; 5677; 5441; 5460; 5461; 5465; 5540; 5546; 5660; 5665; 5670</option>
<option value="955">Model: 5346; 5396; 5452; 5471; 5473; 5474; 5475; 5476; 5477; 5504; 5520; 5521; 5530; 5531; 5541</option>
<option value="718">Model: 5005R; 5006CA/H; 5123; 5109; 5101; 5105; 5106; 5103; 5007; 5108; 5560; 5561; 5563; 5564</option>
<option value="514">Model: 4020 (4021), 4060 (4061,4062,4064), 4150 (4151,4152,4154), 4650 (4651,4652,4654)</option>
<option value="1983">Model: 3000 J100 Series (8255, 8256-xxx), 3000 Q100 Series (8822-xxx)</option>
<option value="2110">Model: 3000 N100 Series (0689, 0768-xxx), 3000 C200 Series (8922-xxx)</option>
<option value="513">Model: 2400 (2403), 2410 (2413,2419), 3000 (3002,3004), 3210 (3211,3212), 3220 (3222)</option>
<option value="508">Model: 2020 (2023,2025,2026), 3000 (3002,3003), 3020 (3022,3023), 3500 (3502,3503)</option>
<option value="839">Model: 2000 5133/2500/CD, 5166/1200, 5166/2500, 5166/2500/CD, 5200/2500</option>
<option value="709">Model: 17XL360/ 365/ 375/ 262/ 362/ 462/ 260/ 265/ 275/ 1700XL/ 1720CA/ 1715CA</option>
<option value="505">Model: 1620 (1621,1622,1623,1624), 1660 (1661,1662,1663,1664), 1670 (1671,1672,1673,1674)</option>
<option value="510">Model: 1640 (1644), 1650, 1690 (DDR2), 3600 (3603,3608), 3610 (3613), 5500 (5502), 5510 (5512,5513)</option>
<option value="507">Model: 1690 (DDR), 1800 (1801,1802,1804), 2000 (2001,2002,2003,2012), 2010 (2012)</option>
<option value="743">Model: 1700 Series (1700T/1700AU/1720US)(1711CL/1712TC/1712US/1714TC)</option>
<option value="695">Model: 1600 XL Series / 1600S/ 1670/ 1672/ 1675/ 1685/ 1687/ 1688/ 1690/ 1692/ 1693/ 1694</option>
<option value="557">Model: 13" 1.83GHz / 2GHz (Intel Core Duo), 13" 1.83GHz / 2GHz / 2.16GHz (Intel Core 2 Duo)</option>
<option value="503">Model: 1310 (1310,1312,1314,1315), 1410 (1414), 1500 (1501,1502), 1600 (1601,1603,1604,1605)</option>
<option value="504">Model: 1350 (1351, 1352, 1353, 1355, 1356, 1357), 1360 (1362), 1450, 1510 (1511,1513), 1520</option>
<option value="2053">Model:  ZPro (6866-14x, 16x, 24x, 26x, 27x, 31x, 34x, 41x, 44x, A4x, A6x, 5xx, 6xx, B4x, B6x, B7x, C1x)</option>

The longest "option" can only be about this long before it makes the page go out of alignment:

 

<option value="xxxx">xxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxx</option>

I know this isn't what you wanted to hear, but it's simply a case of trying to show too much data in too small a place.

 

You need to make some of the lines of data shorter, and more of them.

 

That's my assessment of the situation.

 

Hi Jim !

 

Happy new year!

 

Thanks a lot for your reply.

 

I changed the code to what you offered.. But the search results looks the same..

 

If I understand you correct, you mean that I have to short the length of the categories text in the DB. right ?

 

Is there no other way, like, to reduce the length of the dropdown text box ?

 

Thanks again dear Jim !

 

All the best,

Nath

Best Regards,

Nathali

Link to comment
Share on other sites

Click the dropdown arrow to the side, then scroll down almost to the bottom.

 

You'll find you've (or maybe I) missed some of the very, very long options.

:blush:

 

The box is still expanding to fit the longest option, and there is no way to stop it from doing that, or breaking the options into more than one line in the HTML, that I am aware of.

 

On a personal note I'm glad to hear from you.

 

Every time I hear about unrest in your "neck of the woods" (at least I think I know where you are, give or take a few hundred miles :lol: ) I pray for your well being.

:blush:

If I suggest you edit any file(s) make a backup first - I'm not perfect and neither are you.

 

"Given enough impetus a parallelogramatically shaped projectile can egress a circular orifice."

- Me -

 

"Headers already sent" - The definitive help

 

"Cannot redeclare ..." - How to find/fix it

 

SSL Implementation Help

 

Like this post? "Like" it again over there >

Link to comment
Share on other sites

Click the dropdown arrow to the side, then scroll down almost to the bottom.

 

You'll find you've (or maybe I) missed some of the very, very long options.

:blush:

 

The box is still expanding to fit the longest option, and there is no way to stop it from doing that, or breaking the options into more than one line in the HTML, that I am aware of.

 

On a personal note I'm glad to hear from you.

 

Every time I hear about unrest in your "neck of the woods" (at least I think I know where you are, give or take a few hundred miles :lol: ) I pray for your well being.

:blush:

 

Thanks for your kind reply dear Jim !

Best Regards,

Nathali

Link to comment
Share on other sites

Archived

This topic is now archived and is closed to further replies.

×
×
  • Create New...