[SOLVED] how to makesure no duplicate entries with alert box

[girlzz]

i need some help... newbie and not very familiar with php... how to write a code using php if want to check there is data in database or not so that there is no duplicate entry in the database with alert message...

[pocobueno1388]

<?php

$query = mysql_query("SELECT COUNT(*) FROM table WHERE data='$data'");
$num = mysql_num_rows($query);

if ($num > 0){
   echo "Duplicate!!";
}

?>

[revraz]

There is also a nice little Function I posted awhile back called checkUnique.

 

I'm sure if you search for it, you'll find it.

[trq]

<?php

$query = mysql_query("SELECT COUNT(*) FROM table WHERE data='$data'");
$num = mysql_num_rows($query);

if ($num > 0){
   echo "Duplicate!!";
}

?>

 

mysql_num_rows() will always return 1 row using this method, unless of course the query fails. Try...

 

if ($result = mysql_query("SELECT COUNT(*) FROM table WHERE data='$data'")) {
  if (mysql_result($res,0) > 0) {
    echo "Duplicate!!";
  }
}

[girlzz]

thanks a lot... i had change my table field with unique.. but just incase i want to make an alert popup box just to remind user if they had enter duplicate entries...

[trq]

Is that another question? Pop-up boxes are done client-side using javascript.

[girlzz]

that is not a question.. sorry...