$id_user2=mysqli_query($dblink, "SELECT id FROM users
RIGHT JOIN user_dating ON (user_dating.user_id!=$id and user_dating.dating='NULL')
where users.photo='1' and users.gender='$search_gender' ORDER BY rand()");
вывести из таблицы где нет значений второй таблицы
SELECT t1.* FROM t1 LEFT JOIN t2 ON t1.id=t2.id WHERE t2.id IS NULLSELECT id FROM users u LEFT JOIN user_dating ud ON ud.user_id=u.id
WHERE ud.user_id IS NULL
AND u.photo='1' and u.gender='1'
ORDER BY rand()
Простой
Простой
Средний
Средний
