[reshma]

hi

I have a table with id,name and address. I do not want the user to store the same address more than once aganist his name. I tried a couple of things to prevent duplicate entries, but still not able to get any result. It would be great if someone could help me out with this.

Thanks !!!

[mdhall]

Show us what you tried that didn't work so far.

[reshma]

i tried something like this using INSERT IGNORE

PHP Code:

mysql_query("INSERT  IGNORE INTO ListOfAdresses (VinNo, UserName, Nickname)VALUES('$vno', '$uname', '$name')") or die(mysql_error()); 

[End User]

Originally Posted by reshma

hi

I have a table with id,name and address. I do not want the user to store the same address more than once aganist his name. I tried a couple of things to prevent duplicate entries, but still not able to get any result. It would be great if someone could help me out with this.

The simple ("crude") way of doing this is to make that column a UNIQUE column.

[Keith]

WHen the user submits their data, query for the info you do not want duplicated, LIMITing to 1... and if a row is returned, you know that already exists... then tell them about it.

PHP Code:

// clean_post() -> pseudo magic_quotes cleansing function
$address = clean_post( 'address' );

// build the query
$sql = sprintf(
    'SELECT `address_id` FROM `address` WHERE `address` = \'%s\' LIMIT 1',
    mysql_real_escape_string( $address )
);

// send the query
$result = mysql_query( $sql );

// $exists is TRUE if any rows are found, otherwise FALSE
$exists = ( bool ) mysql_num_rows( $result );

if ( $exists )
{
    // tell them there's a duplicate
}
else
{
    // INSERT $address
} 

I would also set a UNIQUE index on the column as End User suggested... juuust in case.

[reshma]

i tried using the unique key end user....the problem if i use UNIQUE is that it will not allow another user to enter the same address if one user has already entered it...i tried making the username also a unique key, but it dint show any results...

and i tried to use what u suggested keith, but i couldnt get it right, i dint quite understand the cleaning part of the code....

[Keith]

Originally Posted by reshma

and i tried to use what u suggested keith, but i couldnt get it right, i dint quite understand the cleaning part of the code....

[reshma]

what i meant was that i dint understand why u are doing clean_post() and the escape string part....and i dont really know what these functions do....sorry about the previous thread...

[Keith]

Pseudo means fake. It's just an example. I certainly hope you're not copying and pasting example code snippets into your application.

The cleanse_post() function could be anything means that sanitizes the input, including removing any slashes added when magic_quotes is enabled, making it suitable for display.

PHP: mysql_real_escape_string - Manual

[reshma]

thanks a lot !!!! i am definitely not copying and pasting the example code mentioned.... thanks again...