$selectBigthumbQueryOutput = @mysql_query($selectBigthumbQuery) or die(mysql_error());
        while ($selectBigthumbQueryresult = @mysql_fetch_assoc($selectBigthumbQueryOutput)) {
            $totalThumb[] = $selectBigthumbQueryresult;
        }
        $finalResult = @array_rand($totalThumb, 2);
        $finalShowThumb[] = $totalThumb[$finalResult[0]];
        $finalShowThumb[] = $totalThumb[$finalResult[1]];
        $finalShowThumb[2]['name'] = $randCate[1];
        return $finalShowThumb;
    }
    public function showThumbSmall()
    {
        $FeaturedCateQuery = "SELECT `cid` FROM `category` WHERE `featured`='Y'";
        $FeaturedCateQueryoutput = mysql_query($FeaturedCateQuery) or die(mysql_error());
        while ($FeaturedCateQueryResult = mysql_fetch_row($FeaturedCateQueryoutput)) {
            $getFeaturedCate[] = $FeaturedCateQueryResult;
        }
        $first = $getFeaturedCate[0][0];
        $getSmallThumbQuery = "SELECT `thumb_small`,`cid` FROM `scraps` WHERE `cid` LIKE '{$first}' ";
        for ($i = 1; $i < count($getFeaturedCate); $i++) {
            $getSmallThumbQuery .= " OR `cid` LIKE '" . $getFeaturedCate[$i][0] . "'";
        }
        $getSmallThumbQueryOutput = mysql_query($getSmallThumbQuery) or die(mysql_error());
        while ($getSmallThumbQueryResult = mysql_fetch_assoc($getSmallThumbQueryOutput)) {
            $getFinalSmallThumbb[] = $getSmallThumbQueryResult;
        }
        return $getFinalSmallThumbb;
    }
}
$ob = new orkutPapa();
$ob->showThumbBig();
Example #2
0
<?php

require "includes/OrkutPapaClass.php";
$orkutOb = new orkutPapa();
$pageType = "sms";
$catId = $_GET['slug'];
?>

<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd">
<html xmlns="http://www.w3.org/1999/xhtml">
<head>
<base href="<?php 
echo URL . "/";
?>
"/>
<meta http-equiv="Content-Type" content="text/html; charset=utf-8" />
<link rel="stylesheet" href="css/style2.css" type="text/css"/>
<link rel="shortcut icon" href="images/icon.ico"/>
<title>Orkut Papa-Home</title>
</head>
<body>
<div id="wrapper">

<div id="header">
    <div id="header-content">
    <img src="images/orkut-papa.jpg" alt="Orkut Papa, Orkut Scraps" width="200"/> 
    </div>
    <div id="ad"> </div>
</div>

<div id="menu"> <?php 
Example #3
0
<?php

require "includes/OrkutPapaClass.php";
$orkutOb = new orkutPapa();
$Bigthumb = $orkutOb->showThumbBig();
//$Smallthumb = $orkutOb->showThumbSmall();
?>


<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd">
<html xmlns="http://www.w3.org/1999/xhtml">
<head>
<meta http-equiv="Content-Type" content="text/html; charset=utf-8" />
<link rel="stylesheet" href="css/style2.css" type="text/css"/>
<link rel="shortcut icon" href="images/icon.ico"/>
<title>Orkut Papa-Home</title>
</head>
<body>
<div id="wrapper">
	<div id="header">
    	<div id="header-content">
	    <img src="images/orkut-papa.jpg" alt="Orkut Papa, Orkut Scraps" width="200"/> 
    	</div>
    	<div id="ad"> </div>
	</div>

	<div id="menu"><?php 
include "includes/menu.php";
?>
</div>
	<div id="container">