Check in other table

[kei_ki7]

echo "<br/>New Picture<br/>";
    $nsql = "SELECT pid, aid, name FROM ibwf_albumpic WHERE aid='"$prch[0]"' ORDER BY time DESC LIMIT 1";
    $news = mysql_query($nsql);
    echo mysql_error();  
    if(mysql_num_rows($news)>0)
    {
    while ($new = mysql_fetch_array($news))
    {
                echo "<a href=\"album.php?action=pix&amp;pid=$new[0]\"><img src=\"../image.php?pid=$new[0]&s=50\"/></a><br/>";
                echo "<a href=\"album.php?action=pix&amp;pid=$new[0]\">$new[2]</a><br/>";
    }
    } 

i just want to take all pid in ibwf_albumpic but if aid of ibwf_albumpic is private=1 in aid of ibwf_album then that is not taken, but i dont have private in ibwf_albumpic

`ibwf_album` (`aid`, `uid`, `album`, `private`)
`ibwf_albumpic` (`pid`, `uid`, `aid`, `name`, `file`, `caption`, `time`)

they only have same in uid and aid

is this possible?

[thanatos]

aid is the pid from the ibwf_album ryt? try..

SELECT private FROM ibwf_album WHERE pid='aid'

[kei_ki7]

aid is the pid from the ibwf_album ryt? try..

SELECT private FROM ibwf_album WHERE pid='aid'

thanks, but im sorry, i didnt get where to put that

[kei_ki7]

`ibwf_album` (`aid`, `uid`, `album`, `private`)
`ibwf_albumpic` (`pid`, `uid`, `aid`, `name`, `file`, `caption`, `time`)

aid of ibwf_album = aid of ibwf_albumpic

i want to take all pid in ibwf_albumpic but if aid of ibwf_albumpic is private=1 in aid of ibwf_album then that is not taken

is that possible?

its like select pid from ibwf_albumpic where aid and private=0
but my problem is the private checker is in ibwf_album

i thought i saw somewhere using something like this

select pid from ibwf_albumpic where (select pid from ibwf_album where aid and private=0)

i just cnt remember

im sorry, i will edit the 1st post

[thanatos]

$nsql =mysql_query(mysql_fetch_array("SELECT pid, name FROM ibwf_albumpic WHERE aid='".$prch[0]."' ORDER BY time DESC LIMIT 1"); $priv8 = mysql_query(mysql_fetch_array("SELECT private FROM ibwf_album WHERE pid='".$prch[0]."'"); if($priv8[0]=='1'){ $show = "<img src=\"images/offlimits.jpg\"/>"; }else{ $show = "<img src=\"img.php?pid=$new[0]\"/>"; } echo $show;

[thanatos]

select pid from ibwf_albumpic where (select pid from album where aid and private=0)

i dnt knw hw 2 put it dat way.. bt u cn search gugel if u wnt ur query dat way..

[kei_ki7]

thanks again thana :D i will try this asap

btw im planning to change my query if i cannot make this work

[kei_ki7]

thanks thana for your time and replies

$nsql = "SELECT pid, aid, name FROM ibwf_albumpic WHERE aid = ANY (SELECT aid FROM ibwf_album WHERE private=0) ORDER BY time DESC LIMIT 1"; 

i use this and its works

[thanatos]

ur welcome..