MySQL Inserting Data TWICE?

[sexydawg]

I am submitting information to a MySQL database through a PHP form. For some reason when I submit the form, it inserts the data into the database TWICE. I can not figure this one out for the life of me.. anybody ever run up against this problem? Anybody have ANY ideas what might be causing it? This is the code I am using for the submission:

		$query = "INSERT INTO reg_buyer VALUES (NULL,'$breg_date','$breg_name','$breg_address','$breg_city','$breg_state','$breg_zip','$breg_dayphone','$breg_evephone','$breg_fax','$breg_email','$breg_whymove','$breg_specarea','$breg_whenbuy','$breg_budget','$breg_financing','$breg_findsite','$breg_land','$breg_homesize','$breg_beds','$breg_baths','$breg_specialreq','$breg_amenities','$breg_comments')";
		mysql_query($query);

Rather simplistic code and this bit of code is definately only called once per page load (I loaded it up with echo() statements and checked).

TIA...

• sexy

[cgraz]

that is odd. What other code is on the page? Could you post more code?

Cgraz

[sexydawg]

Complete page text:

<?PHP
// Page Variables
$pagevarpageadoptout = 0;
$pagevarsectionicon = "house";
$pagevarsectiontitle = "Listing Services";

// Include Header and Functions
	include("/home/islands/public_html/includes/include-header.php");

?>
<table background="#ffffff" border="0" cellpadding="15" cellspacing="0" width="547"><tr><td>
<!-- BEGIN CONTENT -->

<?php
	dbconnect();
	$breg_date = time();
	$query = "INSERT INTO reg_buyer VALUES (NULL,'$breg_date','$breg_name','$breg_address','$breg_city','$breg_state','$breg_zip','$breg_dayphone','$breg_evephone','$breg_fax','$breg_email','$breg_whymove','$breg_specarea','$breg_whenbuy','$breg_budget','$breg_financing','$breg_findsite','$breg_land','$breg_homesize','$breg_beds','$breg_baths','$breg_specialreq','$breg_amenities','$breg_comments')";
	mysql_query($query);

	echo($success . "<br>");
	echo($breg_date . "<br>");
	echo($query);
?>

blah
<!-- END CONTENT -->

<?php vspace(2); ?>

<?php include("/home/islands/public_html/includes/include-logobar.php"); ?>

	</td></tr></table>

<?PHP
// Include Footer
include("/home/islands/public_html/includes/include-footer.php");
?>

[sexydawg]

And here is the dbconnect() function I refer to in the code:

function dbconnect() {
	mysql_connect('localhost','xxxxxx','xxxxx');
	mysql_select_db('xxxx');
}

Also, there are NO references to any MySQL functions in either those header or footer includes.

The page this is happening with is at:

<snipped to prevent people from submitting info to the database to diagnose a problem that has already been fixed>

Go ahead and play with it if you want....

[cgraz]

This is rather odd. I'm going to take a few guesses here, hopefully one of these will solve your problem.

I submitted a sample entry at the link you gave me and it only printed out an sql query once. . .

Well I briefly looked through your html code. You have two forms

First one: <form action="breg_submit"> (btw no method specified). You end that form, then you have

<form>
<input class="text" type="text" value="Your Email Address">
</form>

Which I'm not even seeing appear on your page anywhere. But anyways, this form doesn't have an action either, so maybe something is happening there when you hit submit. I would get rid of this second form, and also add an action on that first form.

Cgraz

[sexydawg]

That second form is a remnant of something I had on there a while back.. will take that out.

And I also just looked at the database after you submitted... it still submitted the data twice...

[sexydawg]

Update... taking out the extra form tag didn't help. 🙁

[sexydawg]

Fixed both items and now it still submits twice but the second submission is blank.. wtf???

[cgraz]

ah sorry, meant method (looks like you already added one).

So when you hit submit, it inserts 2 rows with identical information? I dont' know, never seen this before. Are you printing $query right now? seems as if it should print twice if you are. Maybe someone else has an idea or experience.

Cgraz

[sexydawg]

Ok, how's this for weird.. when I take out the HTML with the table tags in it.. it works fine....

[cgraz]

😕

BTW, how do you go about creating a site that has a search on mls? I know a real estate agent who wanted something similar, but I wasn't sure how to access mls database. Do you know how this works or if it can even be done? She didn't like the thought of having to create and maintain her own database of houses, she'd rather search the existing mls database.

Cgraz

[sexydawg]

How is this for quirky??? The two lines of HTML directly above my PHP code said:

<table bgcolor="#ffffff" border="0" cellpadding="0" cellspacing="0" width="711">
<tr>
<td bgcolor="#ffffff" valign="top" align="left" width="547">
<table bgcolor="#FFFFFF" border="0" cellpadding="0" cellspacing="0" height="58" width="547"><tr><td align="left" bgcolor="#FFFFFF" height="58" valign="top" width="209"><a href="/index.php"><img src="/images/layout/layout-logobottom4.jpg" width="209" height="58" alt="Islands Real Estate and Appraisal Company - Logo" border="0"></a></td><td width="100%" valign="middle" height="58" bgcolor="#ffffff" align="right"><div class="text-header">Listing Services&nbsp;&nbsp;</div></td><td width="30" valign="middle" height="58" bgcolor="#ffffff" align="right"><img src="/images/layout/icon-house.jpg" width="30" height="28" alt="Listing Services" border="0">&nbsp;&nbsp;</td></tr></table>

<!-- BEGIN CONTENT -->

And after I changed the "#ffffff" in the table tags to "white", it works fine. All this time spent trying to fix this problem and all I had to do was rename a stinking background color.

Why did that screw it up??????