IF NOT EXIST abfrage mit MySQL

[jfheins]

Code:

$result = mysql_query("SELECT COUNT(*) AS Anzahl FROM Tabelle WHERE username = $botname");
$usercount = mysql_result($result, 0, 0);

echo $usercount;

if ($usercount == 0) 
{ 
mysql_query("INSERT INTO Tabelle(Feldliste) VALUES(Wertliste)"); 
}