dont INSERT exact duplicate

[rayzun]

Im not so sure but PHP if statement kind of branches off. I need a more open and direct approach.
I think the query must do the work my example below ...

example: apple = "$mkrs";

$query = "INSERT INTO JS ( id , wrdprc , wrdnprc , pgld ) VALUES ('', '12', '$mkrs', '0') ";

BUT

In the table JS and field wrdnprc
"apple" exists already
I dont want to INSERT any exact duplicates

idis the primary key and set to autoincrement
additionally
"$mkrs" could be in the following format
%honey%76%345
or %8something%%
or something%45%45

I could however
$mkrs = str_replace ("%", "", $mkrs);
INSERT to another backup field wrdprc is for this scenerio.

[devinemke]

rayzun wrote:

In the table JS and field wrdnprc "apple" exists already I dont want to INSERT any exact duplicates

then do a SELECT query first to see if "apple" is already there. if it is not there then do the INSERT, if it is then don't.

[rayzun]

yep what an ordeal this has been

if (empty($dtrmn))
{
//do something empty
echo "nothing script filters and performs <- . . . . _<br>";
}
else
{

$query = "SELECT * FROM JS WHERE wrdnprc = '$mkrs' LIMIT 1";
$good_query=mysql_query($query);
if (mysql_num_rows($good_query) == 0) {

$query = "INSERT INTO JS ( id , wrdprc , wrdnprc , pgld ) VALUES ('', '', '$mkrs', '0') ";
$query=mysql_query($query) or die(mysql_error());

echo "a - result ??<br>";

}
else
{
echo "b - result ??<br>";
} }
resolved