Simple one

illushinz

About 2/3 of the way through this little script are lines of stars. Those mark comments for this post. I have a small error checking line for duplicate records, however, I would like the user to have the ablility to go ahead and add the record if they want, even if its a duplicate.

$query=("SELECT * FROM Info WHERE first = '$first'");
$data=mysql_query($query);
$returned = mysql_num_rows($data);
if ($returned == 0){
$insert = ("INSERT INTO Info (first, last, street1, street2, city, state, zip, email, parent_id, dob, spouse, hphone, wphone, cphone, fax, spouse_dob, mdate) VALUES('$first', '$last', '$street1', '$street2', '$city', '$state', '$zip', '$email', '$parent', '$dob', '$spouse', '$hphone', '$wphone', '$cphone', '$fax', '$spousedob', '$mdate')");
mysql_query($insert)
or die(mysql_error());
echo "Record Added.<br>";
echo "<p><a href=enteradd.php>Add Another?</a><br>";
} else {
echo "We already show a record for $first. Add this one anyway?

I am trying to make this a link that will go ahead and perform the mysql_query function to insert this record
<a href=mysql_query($insert)>Yes</a>";

}
echo "<p><a href=search.html>Return to search screen.</a>";

jowatkins

Firstly, why do you want to duplicate records. This is bad practice. Perhaps you should look at narrowing down your search so that you don't get so many matches?

Anyway, if you really want to do it, the following function will help you do a hidden form:

function find_record_button($postto, $fieldsarray, $button)
{
  //dynamically build hidden forms with button links to records
  echo "<form action=\"$postto\" method=\"post\">";
  foreach ($fieldsarray as $item)
  {
    $name = $item["name"];
    $value = $item["value"];
    echo "<input type=\"hidden\" name=\"$name\" value=\"$value\">";
  }
  echo "<input type=\"image\" border=\"0\" name=\"$button\" src=\"/Buttons/$button.gif\">";
	echo "</form>";
}

now, just alter your else statement:


else { 
  $fieldsarray = array (
    array (name="field1", value="$field1"),
    array (name="field2", value="$field2")
  );
  echo "We already show a record for $first. Add this one anyway? ";
  find_record_button(fieldname, $fieldsarray, buttonname);
}

Hope this helps