Versiune printabilă
Asta ar trebui sa afiseze imaginile nevotate vreodata. Iar daca vrei sa extragi doar imaginile nevotate de 1 anumit IP...Cod PHP:SELECT A.* FROM images A LEFT JOIN vote B ON A.id = B.imgId WHERE B.imgID IS NULL;
Nu le-am testat, le-am scris direct in reply.Cod PHP:SELECT * FROM images
WHERE id NOT IN (SELECT imgId FROM ipvote WHERE ip = 'un_ip_anume');
LE: scuze @Dever, aveam deschis tabul si n`am vazut ca raspunsesesi deja.
Ceva de genul am facut si eu si a mers!
Multumesc oricum la toti cei care au raspunsCod PHP:$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";