Check for existing record

[Anon]

how would i modify my code to check if there is already an existing record of the same coloumn name (field = option_name1) in the table?

I do have the option_name1 field already set as a unique and primary, but i would like to give user feeback via my code.

Thanks, much appreciated

-newbie

<?php include("dbconnect.php"); ?>
<?php

    $query = "insert into table name" 
            ." (option_name1, option_name2, option_name3) values " 
            ."('$option_name', '$$option_name2', '$option_name3')" 
    ; 
   $result = mysql_query($query); 

  if($result) { 
     echo "submission succesful"; } 
  else { 
     echo "error"; 
     } 

?>

[Anon]

<?php

include("dbconnect.php");

$query = "insert into table name"
." (option_name1, option_name2, option_name3) values "
."('$option_name', '$$option_name2', '$option_name3')"
;
$result = mysql_query($query);
if(mysql_num_rows($result)) {
// the record exists
} else {
// it doesn't exsits
}

if($result) {
echo "submission succesful"; }
else {
echo "error";
}

?>

[Anon]

I get an error:

Supplied argument is not a valid MySQL result resource on this line:-

if(mysql_num_rows($result)) {

[tony_l]

That basically can mean two things-

1. You have a syntax error somewhere in that line ($result). OR

2. The Query did not go through.

you can rememdy this like this-

1. Check for semicolons

2. Try to re-construct your SQL statement, I suggest-

   Instaed of delimiting the query, try this-

$query = "INSERT into tablename (option_name1, option_name2, option_name3) values('$option_name', '$$option_name2', '$option_name3')";