zencart mysql and php help needed

im making an addon to the site which is an image scrolling slideshow which can be added to any page within zencart.

This mod will take the images and links from the featured items.

Their is no mod like this in the download section or seaching on the net so im going to have to make on my self. Im bound to run into some problems so will be asking for help in here.

so who is good with the mysql working of zencart??

The SQL would be the same as is used for the featured products sidebox, except that you might want to change the number of products extracted.

cheers for that, now i just need to get it to output in a in a way to for the scolling javascript code to work.

does the standard code only show one item in the featured item box??

<?php
/**
 * Side Box Template
 *
 * @package templateSystem
 * @copyright Copyright 2003-2007 Zen Cart Development Team
 * @copyright Portions Copyright 2003 osCommerce
 * @license [URL]http://www.zen-cart.com/license/2_0.txt[/URL] GNU Public License V2.0
 * @version $Id: tpl_featured.php 6128 2007-04-08 04:53:32Z birdbrain $
 */
  $content = "";
  $featured_box_counter = 0;
  while (!$random_featured_product->EOF) {
    $featured_box_counter++;
    $featured_box_price = zen_get_products_display_price($random_featured_product->fields['products_id']);
    $content .= '<div class="sideBoxContent centeredContent">';
    $content .=  '<a href="' . zen_href_link(zen_get_info_page($random_featured_product->fields["products_id"]), 'cPath=' . zen_get_generated_category_path_rev($random_featured_product->fields["master_categories_id"]) . '&products_id=' . $random_featured_product->fields["products_id"]) . '">' . zen_image(DIR_WS_IMAGES . $random_featured_product->fields['products_image'], $random_featured_product->fields['products_name'], SMALL_IMAGE_WIDTH, SMALL_IMAGE_HEIGHT); 
    $content .= '<br />' . $random_featured_product->fields['products_name'] . '</a>';
    $content .= '<div>' . $featured_box_price . '</div>';
    $content .= '</div>';
    $random_featured_product->MoveNextRandom();
  }
?>

i need to to output more than one item image and these need to be wrapped like so

leftrightslide[0]='<a href="[URL]http://link to product"><img[/URL] src="image.gif" border=0></a>'
leftrightslide[1]='<a href="[URL]http://ling to product"><img[/URL] src="image.gif" border=0></a>'
leftrightslide[2]='<a href="[URL="http://ling%20to%20product%22%3e%3cimg/"]http://ling to product"><img[/URL] src="image.gif" border=0></a>'

No. There's a while loop in there allowing the code to display as many products as were pulled from the database.

co i can edit the $content senction in the side box code so i can remove the div etc and add my own tags but how can i make it so if i say get 10 items from the features items how can i out put the code to include the leftrightslide[0]=' then for next image leftrightslide[1]=' the 2 3 4 etc ??

Move $featured_box_counter++; to the end of the while loop and use $content .= leftrightslide[$featured_box_counter]='

right i think i the code should be correct but need to ask, can php code be inside javascript??

also tried the script by added the javascript into the tmp_index_default but i just kills the page

kitcorsa:

right i think i the code should be correct but need to ask, can php code be inside javascript??
Yes. There's an explanation in the javascript readme in the docs folder that comes with each Zen Cart release package.
kitcorsa:

also tried the script by added the javascript into the tmp_index_default but i just kills the pageZen Cart has a proper javascript loading mechanism. You hack the code directly into pages at your own risk.

i removed the php from the javascript and the loaded but no images as their is nothing to output.

yep defo the php killing it, dropping the php into the tmp_index_default file kills it

dropping the php into the tmp_index_defalut file also kills it so i think the php has an error somewhere.

i read the readme file about on Js and tried as instructed and the the site never loaded all, and couldn't figger out how i would display the JS output were i wanted it on the page.

here is where i got to with the php.

<?php
  $content = "";
  $featured_box_counter = 1;
  while (!$random_featured_product->EOF);
  $featured_box_counter++; {
    $content .= 'leftrightslide[$featured_box_counter]=';
    $content .= '<a href="' . zen_href_link(zen_get_info_page($random_featured_product->fields["products_id"]), 'cPath=' . zen_get_generated_category_path_rev($random_featured_product->fields["master_categories_id"]) . '&products_id=' . $random_featured_product->fields["products_id"]) . '">' . zen_image(DIR_WS_IMAGES . $random_featured_product->fields['products_image'], $random_featured_product->fields['products_name'], SMALL_IMAGE_WIDTH, SMALL_IMAGE_HEIGHT); 
    $content .= '</a>'';
    $random_featured_product->MoveNextRandom();
  }
?>