not duplicate

[devil_online]

Hi,
I want to insert data(names) in the database
However I want to verify if there is some equal name in the database, and if it's equal It wont insert

how can I do this?

thanks

[Sayian]

$data = "data to check";

// check to see if the data is in SQL
$sql = mysql_query("SELECT data from tablename
WHERE data = '$data'
LIMIT 1") or die(mysql_error());
if(mysql_num_rows($sql) <> 0) {
// data was found
} else {
// data was not found
}

[devil_online]

thanks
however I think this code is something wrong because it prints:

0) { // data was found } else { // data was not found } ?>

thats strange...any help?

[scott300]

<?php
 $data = "data to check";

// check to see if the data is in SQL
$sql = mysql_query("SELECT data from tablename
WHERE data = '$data'
LIMIT 1") or die(mysql_error());
if(mysql_num_rows($sql) <> 0) {
// data was found
} else {
// data was not found
} 
?>

make sure you have <?php and ?>

[devil_online]

thanks i've just put ?>