Scrolling Specials but I'd like more than 1 scrolling

[dicko_md]

Hi

 

Ive downloaded a specials.php file which is a infobox which I have showing on my main page.

 

I can only get it to scroll from left to right with 1 item. I would like all my specials to scroll if possible ?

 

The code is below, I think its down to the query.

 

<?php
/*
$Id: specials.php 1739 2007-12-20 00:52:16Z hpdl $

osCommerce, Open Source E-Commerce Solutions
http://www.oscommerce.com

Copyright (c) 2003 osCommerce

Released under the GNU General Public License
*/

if ($random_product = tep_random_select("select p.products_id, pd.products_name, p.products_price, p.products_tax_class_id, p.products_image, s.specials_new_products_price from " . TABLE_PRODUCTS . " p, " . TABLE_PRODUCTS_DESCRIPTION . " pd, " . TABLE_SPECIALS . " s where p.products_status = '1' and p.products_id = s.products_id and pd.products_id = s.products_id and pd.language_id = '" . (int)$languages_id . "' and s.status = '1' order by s.specials_date_added desc limit " . MAX_RANDOM_SELECT_SPECIALS)) {
?>
<!-- specials //-->
<tr>
<td>
<?php
$info_box_contents = array();
$info_box_contents[] = array('text' => BOX_HEADING_SPECIALS);

new infoBoxHeading($info_box_contents, false, false, tep_href_link(FILENAME_SPECIALS));

$info_box_contents = array();
$info_box_contents[] = array('align' => 'center',
'text' => '<MARQUEE behavior= "scroll" align= "center" direction= "right" height="110" scrollamount= "4" scrolldelay= "85" onmouseover=\'this.stop()\' onmouseout=\'this.start()\'>'.'<a href="' . tep_href_link(FILENAME_PRODUCT_INFO, 'products_id=' . $random_product["products_id"]) . '">' . tep_image(DIR_WS_IMAGES . $random_product['products_image'], $random_product['products_name'], SMALL_IMAGE_WIDTH, SMALL_IMAGE_HEIGHT) . '</a><br><a href="' . tep_href_link(FILENAME_PRODUCT_INFO, 'products_id=' . $random_product['products_id']) . '">' . $random_product['products_name'] . '</a><br><s>' . $currencies->display_price($random_product['products_price'], tep_get_tax_rate($random_product['products_tax_class_id'])) . '</s><br><span class="productSpecialPrice">' . $currencies->display_price($random_product['specials_new_products_price'], tep_get_tax_rate($random_product['products_tax_class_id'])) . '</span> </MARQUEE>');

new infoBox($info_box_contents);
?>
</td>
</tr>
<!-- specials_eof //-->
<?php
}
?>

 

Thanks in advance

 

Martyn

[Guest]

I use ScrollingSpecials it scrolls up, it was an easy install, if you can't get the one you are using to work.

[dicko_md]

Thanks but that is not exactly what I am looking for as I need it scrolling left to right. I think if I just managed to change the query, then I will be OK

 

if ($random_product = tep_random_select("select p.products_id, pd.products_name, p.products_price, p.products_tax_class_id, p.products_image, s.specials_new_products_price from " . TABLE_PRODUCTS . " p, " . TABLE_PRODUCTS_DESCRIPTION . " pd, " . TABLE_SPECIALS . " s where p.products_status = '1' and p.products_id = s.products_id and pd.products_id = s.products_id and pd.language_id = '" . (int)$languages_id . "' and s.status = '1' order by s.specials_date_added desc limit " . MAX_RANDOM_SELECT_SPECIALS)) {

 

Cheers

[jhande]

Hey Martyn,

 

Did the contribution add a section to your admin panel configurations?

 

It looks like it is calling for a setting = MAX_RANDOM_SELECT_SPECIALS

 

[dicko_md]

Hey Martyn,

 

Did the contribution add a section to your admin panel configurations?

 

It looks like it is calling for a setting = MAX_RANDOM_SELECT_SPECIALS

 

 

thanks but I have checked and I can't see anything within the admin panel. What does the MAX_RANDOM_SELECT_SPECIALS mean ?

 

Is there a different db query that can be run to pull out all specials like the specials page on the root of catalog ? I've tried that query but there are a couple of differences and that doesn't work

 

thanks

 

martyn