problema la un query MySQL

[casperel]

SELECT A.* FROM images A LEFT JOIN vote B ON A.id = B.imgId WHERE B.imgID IS NULL; 

Asta ar trebui sa afiseze imaginile nevotate vreodata. Iar daca vrei sa extragi doar imaginile nevotate de 1 anumit IP...

SELECT * FROM images
WHERE id NOT IN (SELECT imgId FROM ipvote WHERE ip = 'un_ip_anume'); 

Nu le-am testat, le-am scris direct in reply.

LE: scuze @Dever, aveam deschis tabul si n`am vazut ca raspunsesesi deja.

[Cristi G]

Ceva de genul am facut si eu si a mers!

$fetch = "select imgId from ipvote where ip='$ip'";
$resultf = mysqli_query($connect, $fetch);
$sql = "SELECT id,title,filename,voteNr,voteValue FROM images INNER JOIN vote ON id = imgId WHERE ";
while ($q = mysqli_fetch_array($resultf)) {
$id = $q['imgId'];
$sql .= "id!='$id' and ";
}
$sql .= " enabled='yes' ORDER BY rand() LIMIT 1"; 

Multumesc oricum la toti cei care au raspuns