MYSQL多个在哪里

im trying to use multiple WHERE ? = ? AND ? = ? AND ? = AND but i cant get it to work here is what ive tried soo far

$randuser = $sql->query("SELECT * FROM `brukere` WHERE `level`='1' AND `liv`>='0' AND NOT `brukernavn`='$spiller->brukernavn' `liv`>='0' ORDER BY RAND() LIMIT 1");

I dont know How i am going to do tHis soo i Hoped you Could Help me. also i dont know if AND NOT will work, soo if im doing tHat wrong i Hoped you Could tell me wat else i sHould do tere

• You have a condition without AND, since its a duplicate you may remove it (liv>='0') before ORDER BY
• AND NOT will also work by I suggest you use != for negation

So your query should look like

$randuser = $sql->query("SELECT * FROM `brukere` WHERE `level`='1' AND `liv`>='0' AND `brukernavn`!='$spiller->brukernavn' ORDER BY RAND() LIMIT 1");