WordPress, Shopify ir PHPFusion programuotojų bendruomenė

Parašė megar· 2011 Rugp. 16 14:08:09

kaip padaryti kad rodytu nuotraukas tik is vienos kategorijos ? pvz album_id 14 ?

openside ("Earth's Special Forces Latest Media");

$uzklausa = dbquery("SELECT panel_name FROM ".$db_prefix."panels WHERE panel_filename = 'latest_images_panel'");
if (dbrows($uzklausa) != 0) {
$data = dbarray($uzklausa);
$panel_name = $data['panel_name'];
}

$uzklausa = dbquery("SELECT * FROM ".$db_prefix."photos ORDER BY photo_id DESC LIMIT 1");
$album_id = 14;

echo "";
if (dbrows($uzklausa) != 0) {
while($data = dbarray($uzklausa)) {
echo "<center>
<a href='".BASEDIR."photogallery.php?photo_id=".$data['photo_id']."' title='".$data['photo_title']."'class='gallery'>

<img src='".BASEDIR."images/photoalbum/album_".$album_id."/".$data['photo_thumb1']."' style='margin:5px' align='center'></a><br>

<a href='".BASEDIR."photogallery.php?photo_id=".$data['photo_id']."'>".$data['photo_title']."</a>

";
}

}

closeside();
?>

Parašė Žmogus· 2011 Rugp. 16 14:08:13

Jei kerti šiek tiek PHP gaL PAts pasidarysi

$result = dbquery("SELECT * FROM ".$db_prefix."downloads WHERE download_cat='3' ORDER BY download_count DESC LIMIT 0,10");