[SOLVED] prevent from REPETITIVE ENTRANCEs in DB

[msafvati]

Hi my friends

I have a question!

How can I prevent from REPETITIVE ENTRANCEs such as username that we want to don’t repititive in my database

Please help me

 

 

$a=odbc_result($res,'username');

                  if ($a==$_POST['t9']){

                  echo "Repititve!!!! in DB";

                  }

[Mchl]

Set a field as UNIQUE

[BlueSkyIS]

that will certainly cause an error when you try to insert a duplicate. but to prevent an error, you need to check to see if the record exists first, then warn the user and require them to use a different value.

[Mchl]

Errors can be parsed, which often will be faster, than executing extra query.

[BlueSkyIS]

heh. maybe i'll get out a stopwatch and check some day. until then, i'll make sure i'm not trying to insert a duplicate record.

[Mchl]

Sure.

Whatever works better for you.

[msafvati]

thanks

but do imposible for u to more guide me?

do that suorce is correct?

[ankhmor]

I can show you how its done in mysql but ur not using mysql are u.

[.josh]

google for any registration script tutorial and you will find method(s) for checking if there is duplicate data in your db.

[msafvati]

My problem is solved .

I write this script and test it and it answer  to me.

Thanks my friend

<?php
  $conn=odbc_connect("test","","");
      $name=$_GET['txt'];
      $username=$_GET['un'];
  if (isset($_GET['txt'])){
            $qu="select * from tblTest where username like '".$_GET['un']."'";
            $res=odbc_do($conn,$qu);
            $a=odbc_result($res,'username');
            if ($a == $_GET['un']){
            echo "Duplicate Data";
            }
            else
            {
      $query="insert into tblTest(name,username)"."values ('$name','$username')";
            $res=odbc_do($conn,$query);
            if (odbc_num_rows($res) >= 1){
            echo "user has benn registered";
            }
            }
      odbc_close($conn);
      }
      
  ?>