Sending HTML Newsletters

pafranklin · November 2, 2005

Hi everyone,

I have spent ages going through the numerous forum entries relating to emails and email settings. I have now managed to send HTML emails to individual customers by changing the format of the mail.php file. At line 42 I changed:

$mimemessage->add_text($message);

to

$mimemessage->add_html($message);

That's progress but how can I make a similar alteration to send bulk emails as HTML?

I would be grateful for any suggestions as it does seem very difficult to set up in OSC and the email settings are not easy to understand.

♥Monika in Germany · November 2, 2005

Hi everyone,

I have spent ages going through the numerous forum entries relating to emails and email settings. I have now managed to send HTML emails to individual customers by changing the format of the mail.php file. At line 42 I changed:

$mimemessage->add_text($message);

to

$mimemessage->add_html($message);

That's progress but how can I make a similar alteration to send bulk emails as HTML?

I would be grateful for any suggestions as it does seem very difficult to set up in OSC and the email settings are not easy to understand.

you need not use the mimemessage format. Use tep_mail like in your create account emails. This makes it easy to add html.

pafranklin · November 2, 2005

you need not use the mimemessage format. Use tep_mail like in your create account emails. This makes it easy to add html.

Hi Monika,

Sorry for appearing thick but how and where do I edit this code?

Thank you!! :)

♥Monika in Germany · November 2, 2005

Hi Monika,

Sorry for appearing thick but how and where do I edit this code?

Thank you!! :)

admin\includes\modules\newsletters.php

I'll attach my function send, although it's severely modded ... it may help you still.

	function send($newsletter_id) {
  $mail_query = tep_db_query("select customers_firstname, customers_lastname, customers_email_address from " . TABLE_CUSTOMERS . " where customers_newsletter = '1'");

// build the message content

// ################# START MODIFICATIONS HTML EMAIL #################
		$Varlogo = ' '.VARLOGO.' ';
		$Varhttp = ''.VARHTTP.'';
		$Varstyle = ''.VARSTYLE.'';
		$Varboxwidth = ''.BOX_WIDTH.'';
		$Varswirl = ''.VARSWIRL.'';
		$Varseparator = ''.VARSEPARATOR.'';


		$Vartitle = ''.EMAIL_TITLE.'';
		$Varsignature = ''.EMAILSIGNATURE.'';
		$Varfooter = ''.FOOTER_TEXT_BODY.'';	  

  $message = $this->content;

		require(DIR_WS_MODULES . 'email/html_mail.php');

		if (EMAIL_USE_HTML == 'true') {
			$email_text = $html_email_text;
		} else {
			$email_text = $message . "\n\n";
		}

  while ($mail = tep_db_fetch_array($mail_query)) {
			tep_mail($mail['customers_firstname'] . ' ' . $mail['customers_lastname'], $mail['customers_email_address'], $this->title, $email_text, STORE_OWNER, $from);
  }

  $newsletter_id = tep_db_prepare_input($newsletter_id);
  tep_db_query("update " . TABLE_NEWSLETTERS . " set date_sent = now(), status = '1' where newsletters_id = '" . tep_db_input($newsletter_id) . "'");
}

pafranklin · November 2, 2005

Now I know I am being completely thick. I must have totally lost the plot. My newsletter.php file is in catalog/admin/includes/modules/newsletters and the code is:

<?php

/*

$Id: newsletter.php,v 1.1 2002/03/08 18:38:18 hpdl Exp $

osCommerce, Open Source E-Commerce Solutions

http://www.oscommerce.com

Released under the GNU General Public License

*/

class newsletter {

var $show_choose_audience, $title, $content;

function newsletter($title, $content) {

$this->show_choose_audience = false;

$this->title = $title;

$this->content = $content;

}

function choose_audience() {

return false;

}

function confirm() {

global $HTTP_GET_VARS;

$mail_query = tep_db_query("select count(*) as count from " . TABLE_CUSTOMERS . " where customers_newsletter = '1'");

$mail = tep_db_fetch_array($mail_query);

$confirm_string = '<table border="0" cellspacing="0" cellpadding="2">' . "\n" .

' <tr>' . "\n" .

' <td class="main"><font color="#ff0000"><b>' . sprintf(TEXT_COUNT_CUSTOMERS, $mail['count']) . '</b></font></td>' . "\n" .

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

' <tr>' . "\n" .

' <td>' . tep_draw_separator('pixel_trans.gif', '1', '10') . '</td>' . "\n" .

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

' <tr>' . "\n" .

' <td class="main"><b>' . $this->title . '</b></td>' . "\n" .

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

' <tr>' . "\n" .

' <td>' . tep_draw_separator('pixel_trans.gif', '1', '10') . '</td>' . "\n" .

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

' <tr>' . "\n" .

' <td class="main"><tt>' . nl2br($this->content) . '</tt></td>' . "\n" .

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

' <tr>' . "\n" .

' <td>' . tep_draw_separator('pixel_trans.gif', '1', '10') . '</td>' . "\n" .

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

' <tr>' . "\n" .

' <td align="right"><a href="' . tep_href_link(FILENAME_NEWSLETTERS, 'page=' . $HTTP_GET_VARS['page'] . '&nID=' . $HTTP_GET_VARS['nID'] . '&action=confirm_send') . '">' . tep_image_button('button_send.gif', IMAGE_SEND) . '</a> <a href="' . tep_href_link(FILENAME_NEWSLETTERS, 'page=' . $HTTP_GET_VARS['page'] . '&nID=' . $HTTP_GET_VARS['nID']) . '">' . tep_image_button('button_cancel.gif', IMAGE_CANCEL) . '</a></td>' . "\n" .

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

'</table>';

return $confirm_string;

}

function send($newsletter_id) {

$mail_query = tep_db_query("select customers_firstname, customers_lastname, customers_email_address from " . TABLE_CUSTOMERS . " where customers_newsletter = '1'");

$mimemessage = new email(array('X-Mailer: osCommerce bulk mailer'));

$mimemessage->add_text($this->content);

$mimemessage->build_message();

while ($mail = tep_db_fetch_array($mail_query)) {

$mimemessage->send($mail['customers_firstname'] . ' ' . $mail['customers_lastname'], $mail['customers_email_address'], '', EMAIL_FROM, $this->title);

}

$newsletter_id = tep_db_prepare_input($newsletter_id);

tep_db_query("update " . TABLE_NEWSLETTERS . " set date_sent = now(), status = '1' where newsletters_id = '" . tep_db_input($newsletter_id) . "'");

}

?>

I guess I am just not sure what to change and how to best change it. I can see the $mimemessage elements (bold and underlined) so is this what I need to amend? If so do I simply replace with tep_mail?

Many thanks yet again!

♥Monika in Germany · November 2, 2005

yep exactly that part!

pafranklin · November 2, 2005

yep exactly that part!

Thank you yet again. You keep managing to provide the answers to my problems. Very much appreciated.

One final question - Where should I look and at what files to see why my left column has "slipped" down the page??

http://www.pianocoversonline.co.uk/catalog/

Than you!!!

♥Monika in Germany · November 2, 2005

Thank you yet again. You keep managing to provide the answers to my problems. Very much appreciated.

One final question - Where should I look and at what files to see why my left column has "slipped" down the page??

http://www.pianocoversonline.co.uk/catalog/

Than you!!!

turn on the table border on the column left (right before the include) that should give us an idea ... probably a closing tag missing. What did you add last?

pafranklin · November 3, 2005

turn on the table border on the column left (right before the include) that should give us an idea ... probably a closing tag missing. What did you add last?

Sorry but how do I do that? Here is the code from my columnleft.php

<?php

/*

$Id: column_left.php,v 1.15 2003/07/01 14:34:54 hpdl Exp $

osCommerce, Open Source E-Commerce Solutions

http://www.oscommerce.com

Released under the GNU General Public License

*/

if ((USE_CACHE == 'true') && empty($SID)) {

echo tep_cache_categories_box();

} else {

include(DIR_WS_BOXES . 'categories.php');

}

// if ((USE_CACHE == 'true') && empty($SID)) {

// echo tep_cache_manufacturers_box();

// } else {

//include(DIR_WS_BOXES . 'manufacturers.php');

// }

require(DIR_WS_BOXES . 'whats_new.php');

require(DIR_WS_BOXES . 'search.php');

include (DIR_WS_BOXES . 'whos_online.php');

include (DIR_WS_BOXES . 'rss_news.php');

// BEGIN NewsDesk

include(DIR_WS_BOXES . 'newsdesk.php');

include(DIR_WS_BOXES . 'newsdesk_latest.php');

// END NewsDesk

//require(DIR_WS_BOXES . 'information.php');

?>

♥Monika in Germany · November 3, 2005

the tables for the column right and left are in the catalog files.

us a plain one like the shipping php and look for this:

<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">



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

see the border? make that a 1, then call the shipping.php file. Should show you what is wrong.

pafranklin · November 3, 2005

the tables for the column right and left are in the catalog files.

us a plain one like the shipping php and look for this:

see the border? make that a 1, then call the shipping.php file. Should show you what is wrong.

Hi Monika,

Have done this as you say and the result is here

http://www.pianocoversonline.co.uk/catalog/shipping.php

I'm still not sure where to go next????

Many thanks.

Paul.

♥Monika in Germany · November 3, 2005

Hi Monika,

Have done this as you say and the result is here

http://www.pianocoversonline.co.uk/catalog/shipping.php

I'm still not sure where to go next????

Many thanks.

Paul.

I issue wasn't there

turn on the the following border now (turn other off)

pafranklin · November 3, 2005

I issue wasn't there

turn on the the following border now (turn other off)



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

Ok, done that - http://www.pianocoversonline.co.uk/catalog/shipping.php

The border appaears to be around the correct area but the column does not set itself to the top?

♥Monika in Germany · November 3, 2005

Ok, done that - http://www.pianocoversonline.co.uk/catalog/shipping.php

The border appaears to be around the correct area but the column does not set itself to the top?

leave as is, and comment out the boxes in column_left one by one, checking in between

pafranklin · November 3, 2005

leave as is, and comment out the boxes in column_left one by one, checking in between

Very strange............ Tried and checked for every box but nothing changed. Have even checked against the core columnleft.php file and cannot see anything?

Where else could I look? Or have I over-looked something silly? Columnleft.php code below. Thanks ever so for the help.

if ((USE_CACHE == 'true') && empty($SID)) {

echo tep_cache_categories_box();

} else {

include(DIR_WS_BOXES . 'categories.php');

}

require(DIR_WS_BOXES . 'whats_new.php');

require(DIR_WS_BOXES . 'search.php');

include (DIR_WS_BOXES . 'whos_online.php');

include (DIR_WS_BOXES . 'rss_news.php');

// BEGIN NewsDesk

include(DIR_WS_BOXES . 'newsdesk.php');

include(DIR_WS_BOXES . 'newsdesk_latest.php');

// END NewsDesk

//require(DIR_WS_BOXES . 'information.php');

?>

♥Monika in Germany · November 3, 2005

hmmmm ... if you comment them all ot what happens?

pafranklin · November 3, 2005

hmmmm ... if you comment them all ot what happens?

Everything disappears completely so cannot see if anything missing.Tried leaving in just the what's new box but even that did not align to the top. I wonder is there something wrong in the index.php page?

Here is the code for that page????????????? Thanks and sorry for being such a pain!!!!

<?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

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

}

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

?>

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

<head>

<title>Piano Covers Online - The Piano Cover Specialists</title>

</head>

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

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

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

</table></td>

<?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);

?>

<tr>

<tr>

</tr>

</table></td>

</tr>

<tr>

</tr>

<tr>

</tr>

<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>

</tr>

<tr>

</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, " . TABLE_PRODUCTS_DESCRIPTION . " pd, " . TABLE_MANUFACTURERS . " m, " . TABLE_PRODUCTS_TO_CATEGORIES . " p2c left join " . TABLE_SPECIALS . " s on p.products_id = s.products_id 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, " . TABLE_PRODUCTS_DESCRIPTION . " pd, " . TABLE_MANUFACTURERS . " m left join " . TABLE_SPECIALS . " s on p.products_id = s.products_id 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, " . TABLE_PRODUCTS_DESCRIPTION . " pd, " . TABLE_MANUFACTURERS . " m, " . TABLE_PRODUCTS_TO_CATEGORIES . " p2c left join " . TABLE_SPECIALS . " s on p.products_id = s.products_id 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, " . TABLE_PRODUCTS_TO_CATEGORIES . " p2c left join " . TABLE_SPECIALS . " s on p.products_id = s.products_id 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;

}

?>

<tr>

<tr>

<?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'];

}

?>

</tr>

</table></td>

</tr>

<tr>

</tr>

<tr>

</tr>

</table></td>

<?php

} else { // default page

?>

<tr>

<tr>

</tr>

</table></td>

</tr>

<tr>

</tr>

<tr>

<tr>

</tr>

<tr>

</tr>

<tr>

</tr>

<tr>

</tr>

<tr>

</tr>

<?php

include(DIR_WS_MODULES . FILENAME_UPCOMING_PRODUCTS);

?>

</table></td>

</tr>

</table>

<?php

}

?>

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

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

</table></td>

</tr>

</table>

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

<br>

</body>

<a href="http://www.phpmyvisites.net/" title="phpMyVisites : an open source website statistics application in PHP/MySQL, distributed under the GPL."

onclick="window.open(this.href);return(false);">

<!--

var a_vars = Array();

var pagename='';

var phpmyvisitesSite = 2;

var phpmyvisitesURL = "http://www.pianocoversonline.co.uk/stats/phpmyvisites.php";'>http://www.pianocoversonline.co.uk/stats/phpmyvisites.php";

//-->

</script>

<p>phpMyVisites : an open source website statistics application in PHP/MySQL, distributed under the GPL.

</p>

</noscript>

</a>

</html>

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

♥Monika in Germany · November 3, 2005

it cannot be the index.php if you get it on all pages

pafranklin · November 3, 2005

it cannot be the index.php if you get it on all pages

Yes, every page seems to have the same problem but I just cannot seem to figure out why. Are there any other files I should look at apart from the columnleft.php?

Thanks.

♥Monika in Germany · November 3, 2005

Yes, every page seems to have the same problem but I just cannot seem to figure out why. Are there any other files I should look at apart from the columnleft.php?

Thanks.

sorry, no idea right now. I stripped of your column left source code line by line but it looked ok to me.

and you seem to have the valign="top" for the column_left in the index.php, so I bet it's there in all files.

revoking all I said

I just copied in the space that looks empty ... and you have a whole book of text in there.

from copying:

Quick Find

Use keywords to find the product you are looking for.
Advanced Search

Sending HTML Newsletters

Recommended Posts

pafranklin

♥Monika in Germany

pafranklin

♥Monika in Germany

pafranklin

♥Monika in Germany

pafranklin

♥Monika in Germany

pafranklin

♥Monika in Germany

pafranklin

♥Monika in Germany

pafranklin

♥Monika in Germany

pafranklin

♥Monika in Germany

pafranklin

♥Monika in Germany

pafranklin

♥Monika in Germany

pafranklin

pafranklin

♥Monika in Germany

Archived

Browse

Activity