mysql duplicate entry error show

[Black Tiger]

i have problem i have show error on my site
Duplicate entry 'some tag' for key #
its change every reffesh page. i want its not show ignor it..
i use this mysql coomand in my php code
for insert

$remote_ip = $_SERVER['REMOTE_ADDR']; 
mysql_query("INSERT IGNORE INTO search (tag, ip_address) VALUES ('$query', '$remote_ip')");

and for select

$query1 = "SELECT `tag` FROM  `search` ORDER BY RAND() LIMIT 10"; 
$query1 = mysql_query($query1);

 

[Lock Down]

Simplest way for you is to use

mysql_query("REPLACE INTO search (tag, ip_address) VALUES ('$query', '$remote_ip')");

 

[Black Tiger]

not working already show Duplicate entry 'some tag name' for key 'tag'

 

[valley]

not working already show Duplicate entry 'some tag name' for key 'tag'

Make sure either "ip_address" or "tag" is set as a unique key in the database. This will allow you to make queries if one of the key value is a duplicate entry.

 

[Black Tiger]

yes its both unique key

 

[Lock Down]

Replace into will not show duplicate entry......

 

[Black Tiger]

Simplest way for you is to use

mysql_query("REPLACE INTO search (tag, ip_address) VALUES ('$query', '$remote_ip')");

sir i already use this command you give but its not working

 

[Lock Down]

Show me the table structure and the index structure for this table.

 

[Black Tiger]

fixed it

 

[Lock Down]

Glad it worked for you.