[PHP][MySQL]Problem pobieraniem danych z bazy mysql Opcje

[saviola15]

Witam dodałem kod PHP żeby pokazywał graficzne stany magazynowe. Tabela w mysql z virtuemart to product_in_stock i niestety nie pobiera mi tej ilości i wszędzie pokazuje się ten sam obrazek.
kliknij tutaj aby zobaczyć strone
kod który dodałem:

[PHP] pobierz, plaintext 
 {
 
 
 
             if (($product_in_stock > 49)) $dost=1 ; 
              if (($product_in_stock>19) && ($product_in_stock<=49)) $dost=2 ; 
             if (($product_in_stock<=19) && ($product_in_stock>=4))  $dost=3 ; 
           if (($product_in_stock<=30) && ($product_in_stock<=10)) $dost=2 ; 
            if (($product_in_stock<=0)) $dost=1 ; 
 
 
                       switch ($dost)
               {
                  case '1': {$data[$row][] ="<center><br/><br/><br/><img src=\"images/ilosc/4.gif\" /></center>"; } break;
                 case  '2': {$data[$row][] ="<center><br/><br/><br/><img src=\"images/ilosc/3.gif\" /></center>"; } break;
                  case '3': {$data[$row][] ="<center><br/><br/><br/><img src=\"images/ilosc/2.gif\" /></center>"; } break;
                  case  '4': {$data[$row][] ="<center><br/><br/><br/><img src=\"images/ilosc/1.gif\" /></center>"; } break;
                  case '5': {$data[$row][] ="<center><br/><br/><br/><img src=\"images/ilosc/0.gif\" /></center>"; } break;
               }
			   }
 
[PHP] pobierz, plaintext 

A tutaj cały plik:

[PHP] pobierz, plaintext 
<?php if( !defined( '_VALID_MOS' ) && !defined( '_JEXEC' ) ) die( 'Direct Access to '.basename(__FILE__).' is not allowed.' );
mm_showMyFileName(__FILE__); ?>
 
<?php echo $buttons_header // The PDF, Email and Print buttons ?>
 
 
 
<?php
 
 
 
$data =array(); // Holds the rows of products
$i = 1; $row = 0; // Counters
 
// Table header
$tableheader[] = $VM_LANG->_('PHPSHOP_PRODUCT_FORM_THUMB_IMAGE');
$tableheader[] = $VM_LANG->_('PHPSHOP_CART_NAME');
$tableheader[] = '<center>Zapas Magazynowy</center>';
if( _SHOW_PRICES && $auth['show_prices'] ) {
	$tableheader[] = $VM_LANG->_('PHPSHOP_CART_PRICE');
 
}
 
 
	$tableheader[] = 'Akcja';
 
 
// Creates a new HTML_Table object that will help us
// to build a table holding all the products
$table = new HTML_Table('width="105%"');
 
$table->addRow( $tableheader, 'class="sectiontableheader"', 'th', true );
 
foreach( $products as $product ) {
 
		foreach( $product as $attr => $val ) {
			// Using this we make all the variables available in the template
			// translated example: $this->set( 'product_name', $product_name );
			$this->set( $attr, $val );
		}
		$data[$row][] = '<br/><a href="'.$product['product_flypage'].'" title="'.$product['product_name'].'">'
						. ps_product::image_tag( $product['product_thumb_image'] )
						. '</a>';
		$data[$row][] = '<br/><br/><br/><h2><center><a href="'.$product['product_flypage'].'" title="'.$product['product_name'].'">'.$product['product_name'].'</a></center></h2>';
			if( $this->get_cfg( 'showAvailability' )) 
 
 
		 {
 
 
 
             if (($product_in_stock > 49)) $dost=1 ; 
              if (($product_in_stock>19) && ($product_in_stock<=49)) $dost=2 ; 
             if (($product_in_stock<=19) && ($product_in_stock>=4))  $dost=3 ; 
           if (($product_in_stock<=30) && ($product_in_stock<=10)) $dost=2 ; 
            if (($product_in_stock<=0)) $dost=1 ; 
 
 
 
           switch ($dost)
               {
                  case '1': {$data[$row][] ="<center><br/><br/><br/><img src=\"images/ilosc/4.gif\" /></center>"; } break;
                 case  '2': {$data[$row][] ="<center><br/><br/><br/><img src=\"images/ilosc/3.gif\" /></center>"; } break;
                  case '3': {$data[$row][] ="<center><br/><br/><br/><img src=\"images/ilosc/2.gif\" /></center>"; } break;
                  case  '4': {$data[$row][] ="<center><br/><br/><br/><img src=\"images/ilosc/1.gif\" /></center>"; } break;
                  case '5': {$data[$row][] ="<center><br/><br/><br/><img src=\"images/ilosc/0.gif\" /></center>"; } break;
               }
			   }
 
 
 
		if( _SHOW_PRICES && $auth['show_prices'] ) {
			$data[$row][] = '<br/><br/><br/>'.$product['product_price'].'&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;';
 
		}
 
 
		if( $product['has_addtocart'] ) {
			$data[$row][] = '<br/><br/>'.$product['form_addtocart'];
		}
		else {
			$data[$row][] = '<br/><br/><a href="'.$product['product_flypage'].'" title="'.$product['product_name'].'">'
							.	$product['product_details']
							.	'</a>';
 
		}
 
 
		$row++;
 
}
 
 
// Loop through each row and build the table
foreach($data as $key => $value) {
 
	$table->addRow( $data[$key], 'class="sectiontableentry'.$i.'"', 'td', true );
	$i = $i == 1 ? 2 : 1;
}
// Display the table
echo $table->toHtml();
?>
<br class="clr" /><br />
<?php echo $browsepage_footer ?>
[PHP] pobierz, plaintext 

Ten post edytował saviola15 6.09.2012, 09:59:19