<?php
/*
  ArabCart, Free E-Commerce Solutions
  http://www.arabcart.info

  Copyright (c) 2005 Mhd Zaher Ghaibeh

  Released under the GNU General Public License
  This program is free software; you can redistribute it and/or
  modify it under the terms of the GNU General Public License
  as published by the Free Software Foundation; either version 2
  of the License, or (at your option) any later version.

  This program is distributed in the hope that it will be useful,
  but WITHOUT ANY WARRANTY; without even the implied warranty of
  MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE.  See the
  GNU General Public License for more details.

  You should have received a copy of the GNU General Public License
  along with this program; if not, write to the Free Software
  Foundation, Inc., 51 Franklin Street, Fifth Floor, Boston, MA  02110-1301,
  USA.
*/


	//brings some products form the database

		$showTable=mysql_query("select pro.id , pro.name , pro.short_desc , pro.avaliable  , thu.thumb_img from products pro, img_thumb thu where pro.id=thu.product_id order by pro.id DESC limit 0,4") or die(mysql_error());

	if(mysql_num_rows($showTable)!=0)

	{

		$template -> setAttribute("product", "visibility", "visible");

		while($row_pro=mysql_fetch_object($showTable))

		{

			$template -> AddVar("product","PRO-NAME",$row_pro->name);

			$template -> AddVar("product","PRO-SHORT-DESC",stripslashes($row_pro->short_desc));

			$template -> AddVar("product","PRO-THUM-IMG",$row_pro->thumb_img);

			$template -> AddVar("product","PRO-ID",$row_pro->id);

			$template -> AddVar("product","MORE",morep);

			if($row_pro->avaliable==0)

					{

						$template -> AddVar("product","OUT-OF-STOCK",ofs);

						$template -> AddVar("product","ADD2CART",'');

					}

			elseif($row_pro->avaliable==1)

					{

						$template -> AddVar("product","OUT-OF-STOCK","");

						$template -> AddVar("product","ADD2CART",add2);

					}

			$template -> parseTemplate("product","a");

		}

	}

	else

	{

		$template -> AddVar("center","NO-PRODUCTS",nopro);

	}

?>