Alert System Help

Ok i have done up a alert system ok its llike dis:

PHP Code:

---

This is what is in part! of the panel Were u recive the alert ok now i want it when u send a alert it shows up only ONCE on dis one it shows up all da time help?


$showit = mysql_query("SELECT * FROM `ipalert`");
while($row = mysql_fetch_array($showit)){   
 $ip = $row["ip"];
 $message = $row["message"];
 $djname = $row["djname"];
}
if ($_SERVER["REMOTE_ADDR"] == $ip){
echo "<script>
alert ('Moderator $djname Says: $message\') 
</script>"; 


---

PHP Code:

---

$showit = mysql_query("SELECT * FROM `ipalert`");
while($row = mysql_fetch_array($showit)){   
 $ip = $row["ip"];
 $message = $row["message"];
 $djname = $row["djname"];
}
if ($_SERVER["REMOTE_ADDR"] == $ip){
echo "<script>
alert ('Moderator $djname Says: $message\') 
</script>";
mysql_query("DELETE FROM `ipalert` WHERE `ip` = '$ip'2) or die ("Error");
} 


---

PHP Code:

---

$showit = mysql_query("SELECT * FROM `ipalert`");
while($row = mysql_fetch_array($showit)){   
 $ip = $row["ip"];
 $message = $row["message"];
 $djname = $row["djname"];
}
if ($_SERVER["REMOTE_ADDR"] == $ip){
echo "<script>
alert ('Moderator ". $djname ." Says: ". $message ."') 
</script>";
mysql_query("DELETE FROM `ipalert` WHERE `ip` = '$ip'2") or die ("Error");
} 


---

Reina's code had an error, so this is the fixed version :)

PHP Code:

---

$showit = mysql_query("SELECT * FROM `ipalert`");
while($row = mysql_fetch_array($showit)){   
 $ip = $row["ip"];
 $message = $row["message"];
 $djname = $row["djname"];
}
if ($_SERVER["REMOTE_ADDR"] == $ip){
echo "<script>
alert ('Moderator ". $djname ." Says: ". $message ."') 
</script>";
mysql_query("DELETE FROM `ipalert` WHERE `ip` = '$ip'") or die ("Error");
} 


---

Invents Code had an error, Here is the fixed Version
Enjoy

Ah it did, good spotting :p

+Rep for no reason. :p

Quote:

---

Originally Posted by Invent

Ah it did, good spotting :p

+Rep for no reason. :p

---

Why thank you simon

Just a thought but shouldn't you delete the alerts by an ID (Primary Key) instead of by IP? Because if say you send 2 alerts to the same user then they both get deleted but only one is shown... wouldn't a mysql look work better?

EDIT: Wait nvm - you did that ;) my bad