$sSQL");
$ii=0;
$jsImage=" var arrImage=Array(); ";
$n_lenth=0;
while($row = mysql_fetch_assoc($result)){
if(is_file($_SERVER['DOCUMENT_ROOT'].$row['filePath'])){
//echo $row['imagePath'];
$imgSource[$ii]= $row['filePath'];
list($ww, $hh)=@getimagesize($_SERVER['DOCUMENT_ROOT'].$row['filePath']);
if(!empty($hh))$ww1=(int)($ww*64/$hh);
$n_lenth+=$ww1+4;
if($ww>400){$hh=(int)($hh*400/$ww);$ww=400; }
if($hh>400){$ww=(int)($ww*400/$hh);$hh=400; }
$img_h[$ii]=' ';
$jsImage.="arrImage[$ii]='![](\"".) '; ";
$ii++;
}
}
$nn1="0";
if(!empty($imgSource))$nn1=count($imgSource);
//t.features, t.warranty, t.similar, t.parts
$sSQL="SELECT c.productsID, c.title, c.description,
l.description l_description, n.description n_description,
l.features l_features, n.features n_features,
l.warranty l_warranty, n.warranty n_warranty,
l.similar l_similar, n.similar n_similar,
l.parts l_parts, n.parts n_parts, l.title l_title
FROM (productsLanguages n
RIGHT JOIN products c ON (c.productsID=n.productsID AND n.languagesID='1') LEFT JOIN manufacturer m USING(manufacturerID))
LEFT JOIN productsLanguages l ON (c.productsID=l.productsID AND l.languagesID='$languagesID') ";
//$sSQL="SELECT p.*, m.title m_title FROM products p LEFT JOIN manufacturer m USING(manufacturerID) ";
$sSQL.=" WHERE c.productsID='".toSQL($productsID)."'";
$result=mysql_query($sSQL) or die ("MySQL err: ".mysql_error()."
".$sSQL);
$total=mysql_num_rows($result);
while($row = mysql_fetch_assoc($result)){
$s_description=empty($row['l_description'])?stripslashes($row['n_description']):stripslashes($row['l_description']);
$s_features=empty($row['features'])?stripslashes($row['n_features']):stripslashes($row['l_features']);
$s_warranty=empty($row['l_warranty'])?stripslashes($row['n_warranty']):stripslashes($row['l_warranty']);
$s_similar=empty($row['l_similar'])?stripslashes($row['n_similar']):stripslashes($row['l_similar']);
$s_parts=empty($row['l_parts'])?stripslashes($row['n_parts']):stripslashes($row['l_parts']);
?>
".$sSQL);
if(mysql_num_rows($result2)>0){
?>  | | ".$sSQL);
while($row2 = mysql_fetch_assoc($result2)){
?> | | | | For price contact us |
|
| | Warranty |
| Similar Products |
| Parts & Accessories |
| ".$sSQL);
if(mysql_num_rows($result3)>0){$arr_tabs[]="Forum";
?>In Forum |
|
".$sSQL);
while($row3 = mysql_fetch_assoc($result3)){$ii++;
//if($ii>$pageItems)break;
?>| - January 01, 1970 | |
| | |
All messages
|
| |
