cat_name;
if($_REQUEST['category'])
$sql = "SELECT * FROM tbl_portlogos AS t1, tbl_logo_photo AS t2 WHERE t1.name = t2.name and t1.category='".$catname."'";
else
$sql = "SELECT * FROM tbl_portlogos AS t1, tbl_logo_photo AS t2 WHERE t1.name = t2.name";
$res=mysql_query($sql) or die(mysql_error());
$row_tot=mysql_num_rows($res);
$row_tot;
if ($pg == "")
{
$pg = 1;
}
$image_per_page = 3;
$from = ($pg - 1) * $image_per_page;
if($_REQUEST['category'])
{
$sql = "SELECT t1.title as title,t2.file as pfile, t2.filename as filename FROM tbl_portlogos AS t1, tbl_logo_photo AS t2 WHERE t1.name = t2.name and t1.category = '".$catname."'";
}
else
{
$sql = "SELECT t1.title as title,t2.file as pfile, t2.filename as filename FROM tbl_portlogos AS t1, tbl_logo_photo AS t2 WHERE t1.name = t2.name ";
}
$sql .= "LIMIT $from, $image_per_page";
$res=mysql_query($sql) or die("Can't open the Table".mysql_error());
$no=mysql_num_rows($res);
if($no == 0)
{
$port.="