Scrolling bestsellers with images

[Tsuri Japan]

Hey guys this is a great contribution and I totally recomend it!!!

 

http://www.oscommerce.com/community/contri...ch,best+sellers

 

I just have one small thing I want to change the image size....the default is pulling out the image size from the admin section of small image width/height. I can't edit the size there because then all my images in index will be too small. In the scroll down images they are a bit too big......so here's what I want to do. I want to make the images mini thumbnail sizes like 60X50 or something, you know something small.

 

I found the code that it's pulling it out from and want to know what or how I should change this?

 

$rows = 0;
$bestsellers_list = '<table border="0" width="100%" cellspacing="0" cellpadding="1">';
while ($best_sellers = tep_db_fetch_array($best_sellers_query)) {
  $rows++;
  $bestsellers_list .= '<tr><td class="infoBoxContents" valign="top">'  . '</td><td class="infoBoxContents">'. '<a href="' . tep_href_link(FILENAME_PRODUCT_INFO, 'products_id=' . $best_sellers['products_id']) . '">' .tep_image(DIR_WS_IMAGES . $best_sellers['products_image'], $best_sellers['products_name'], SMALL_IMAGE_WIDTH, SMALL_IMAGE_HEIGHT).'<br>'. tep_row_number_format($rows). '. <a href="' . tep_href_link(FILENAME_PRODUCT_INFO, 'products_id=' . $best_sellers['products_id']) . '">' . $best_sellers['products_name'] . '</a></td></tr>';
}
$bestsellers_list .= '</table>';

 

Thanks very much for anyone who's kind enough to help me out!!

 

Sorry to ask here but there's no help thread so maybe this can become the new help thread?

 

Nigelman :thumbsup:

[Tsuri Japan]

  $rows = 0;
$bestsellers_list = '<table border="0" width="100%" cellspacing="0" cellpadding="1">';
while ($best_sellers = tep_db_fetch_array($best_sellers_query)) {
  $rows++;
  $bestsellers_list .= '<tr><td class="infoBoxContents" valign="top">'  . '</td><td class="infoBoxContents">'. '<a href="' . tep_href_link(FILENAME_PRODUCT_INFO, 'products_id=' . $best_sellers['products_id']) . '">' .tep_image(DIR_WS_IMAGES . $best_sellers['products_image'], $best_sellers['products_name'], WIDTH="60", HEIGHT="50" ).'<br>'. tep_row_number_format($rows). '. <a href="' . tep_href_link(FILENAME_PRODUCT_INFO, 'products_id=' . $best_sellers['products_id']) . '">' . $best_sellers['products_name'] . '</a></td></tr>';

 

Tried this but no dice.........

 

Nigelman :blink:

[Tsuri Japan]

C'mon someone must know what I'm doing wrong?

 

Nigelman :'(

[Guest]

try

tep_image(DIR_WS_IMAGES . $best_sellers['products_image'], $best_sellers['products_name'], '60', '60')

[Tsuri Japan]

Hey Enigma, thanks a million man it looks much better now!!!!! Um just one more question if you don't mind.....how can I center the image and text in the box?

 

Nigelman :thumbsup:

[Guest]

use the <center></center> html tags before/after the table if you want to center the table. If you want just the table contents use the aling="center" inside the table tag or around each of the bestseller entries.

[racespec]

use the <center></center> html tags before/after the table if you want to center the table. If you want just the table contents use the aling="center" inside the table tag or around each of the bestseller entries.

 

Enigma, I too ma trying to centre the images

 

this is the script from the scrolling box

 

<?php

/*

$Id: best_sellers.php,v 1.21 2003/06/09 22:07:52 hpdl Exp $

 

osCommerce, Open Source E-Commerce Solutions

http://www.oscommerce.com

 

Copyright © 2003 osCommerce

 

Released under the GNU General Public License

*/

 

if (isset($current_category_id) && ($current_category_id > 0)) {

$best_sellers_query = tep_db_query("select distinct p.products_id, p.products_image, pd.products_name from " . TABLE_PRODUCTS . " p, " . TABLE_PRODUCTS_DESCRIPTION . " pd, " . TABLE_PRODUCTS_TO_CATEGORIES . " p2c, " . TABLE_CATEGORIES . " c where p.products_status = '1' and p.products_ordered > 0 and p.products_id = pd.products_id and pd.language_id = '" . (int)$languages_id . "' and p.products_id = p2c.products_id and p2c.categories_id = c.categories_id and '" . (int)$current_category_id . "' in (c.categories_id, c.parent_id) order by p.products_ordered desc, pd.products_name limit " . MAX_DISPLAY_BESTSELLERS);

} else {

$best_sellers_query = tep_db_query("select distinct p.products_id, p.products_image, pd.products_name from " . TABLE_PRODUCTS . " p, " . TABLE_PRODUCTS_DESCRIPTION . " pd where p.products_status = '1' and p.products_ordered > 0 and p.products_id = pd.products_id and pd.language_id = '" . (int)$languages_id . "' order by p.products_ordered desc, pd.products_name limit " . MAX_DISPLAY_BESTSELLERS);

}

 

if (tep_db_num_rows($best_sellers_query) >= MIN_DISPLAY_BESTSELLERS) {

?>

<!-- best_sellers_scroll //-->

<tr>

<td>

<?php

$info_box_contents = array();

$info_box_contents[] = array('text' => BOX_HEADING_BESTSELLERS);

 

new infoBoxHeading($info_box_contents, false, false);

 

$rows = 0;

$bestsellers_list = '<table border="0" width="100%" cellspacing="0" cellpadding="1">';

while ($best_sellers = tep_db_fetch_array($best_sellers_query)) {

$rows++;

$bestsellers_list .= '<tr><td class="infoBoxContents" valign="top" align="center">' . '</td><td class="infoBoxContents">'. '<a href="' . tep_href_link(FILENAME_PRODUCT_INFO, 'products_id=' . $best_sellers['products_id']) . '">' .tep_image(DIR_WS_IMAGES . $best_sellers['products_image'], $best_sellers['products_name'], SMALL_IMAGE_WIDTH, SMALL_IMAGE_HEIGHT).'<br>'. tep_row_number_format($rows). '. <a href="' . tep_href_link(FILENAME_PRODUCT_INFO, 'products_id=' . $best_sellers['products_id']) . '">' . $best_sellers['products_name'] . '</a></td></tr>';

}

$bestsellers_list .= '</table>';

 

$info_box_contents = array();

$info_box_contents[] = array('text' => '<MARQUEE behavior= "scroll" align= "center" direction= "up" height="160" scrollamount= "2" scrolldelay= "70" onmouseover=\'this.stop()\' onmouseout=\'this.start()\'>'.$bestsellers_list.'</MARQUEE>');

 

new infoBox($info_box_contents);

?>

</td>

</tr>

<!-- best_sellers_scroll_eof //-->

<?php

}

?>

 

WHERE DO I PUT THE CENTRE TAGS?

 

ALSO, HOW DO I GET RID OF THE NUMBERS INFRONT OF THE ITEMS DESCRIPTION and also centre/bold the description

 

Thanks for your help

 

Tarek

[Tsuri Japan]

Try this..........I've got it working for me now.

 

$bestsellers_list .= '<tr><td class="infoBoxContents" valign="top">'  . '</td><td class="infoBoxContents">'. '<div align="center"><a href="' . tep_href_link(FILENAME_PRODUCT_INFO, 'products_id=' . $best_sellers['products_id']) . '">' .

 

Ok?

 

Nigelman :thumbsup:

[racespec]

Perfect

 

:) :) :)

 

Thanks mate

 

Tarek