Forum PHP Romania - Discutii despre PHP, MySQL, Javascript, AJAX, etc

Am si eu nevoie de ajutor la un select cu left join pentru al edita adica sa nu imi afiseze tot ci numai ce vreau.
Selectul este:

<?php
$dizibolumsor=@mysql_query("select video.adi as vidadi,video.resim,video.puan,video.toplamoy,video.hit,video.link as vidlinki,kategori.adi as katadi from video left join kategori on (video.kategori=kategori.id) where video.durum=1 order by video.id DESC limit 0,32");

while($dizibolumcek=@mysql_fetch_array($dizibolumsor)) :
$dizibolum_adi=stripslashes($dizibolumcek['vidadi']);
$dizibolum_resim=$dizibolumcek['resim'];
$dizibolum_link=$dizibolumcek['vidlinki'];
$dizibolum_puan=$dizibolumcek['puan'];
$dizibolum_toplamoy=$dizibolumcek['toplamoy'];
$dizibolum_hit=$dizibolumcek['hit'];
$dizibolum_katadi=stripslashes($dizibolumcek['katadi']);

echo '

<a href="'.$dizibolum_link.'.html" class="videobolumyazi" title="'.$dizibolum_adi.'">'.$dizibolum_adi.'</a>

';

endwhile;

?>

tabela kategori :

`id` int(11) NOT NULL auto_increment,
`adi` varchar(255) NOT NULL,
`uid` int(11) NOT NULL,
`title` tinytext NOT NULL,
`description` tinytext NOT NULL,
`keywords` tinytext NOT NULL,
`durum` int(2) NOT NULL,
`link` varchar(255) NOT NULL,
PRIMARY KEY (`id`)

tabela video:

`id` int(11) NOT NULL auto_increment,
`kategori` int(11) NOT NULL,
`adi` longtext NOT NULL,
`aciklama` mediumtext NOT NULL,
`etiket` longtext NOT NULL,
`resim` varchar(255) NOT NULL,
`embed` mediumtext NOT NULL,
`tarih` varchar(100) NOT NULL,
`puan` int(25) NOT NULL,
`toplamoy` int(25) NOT NULL,
`title` mediumtext NOT NULL,
`description` mediumtext NOT NULL,
`keywords` mediumtext NOT NULL,
`link` varchar(255) NOT NULL,
`durum` int(2) NOT NULL default '1',
`hit` int(15) NOT NULL,
PRIMARY KEY (`id`)

Eu pot extrage decat categoriile prin:

<?php
$yerlidizisor=mysql_query("select adi,link from kategori where (uid=10 and durum=1) order by adi ASC");
while ($yerlidizicek=mysql_fetch_array($yerlidizisor)) :
$yerli_kat_adi=$yerlidizicek['adi'];
$yerli_kat_linki=$yerlidizicek['link'];
echo'<li><a href="serial-online/'.$yerli_kat_linki.'/" title="'.$yerli_kat_adi.'">'.$yerli_kat_adi.'</a></li>';
endwhile;
?>

DAR EU VREAU SA EXTRAG NUMAI CE ESTE IN CATEGORIE. PRIMUL SELECT DE SUS DE TOT EXTRAGE SI CATEGORIILE SI CE ESTE IN CATEGORII SPER CA M-AM FACUT CAT DE CAT INTELES!

INTREBA-TI DACA ESTE NECLAR CEVA VA MULTUMESC!!!