Mysql or PHP problem??

kbc1

Hi,

I am encountering a very bizarre problem so i thought I would post to see if anyone has come across it in the past.

I have a form which posts 1 text box and I run 1 INSERT query to enter a record into my table using the contents that was entered in the text box (very standard stuff).

	if (!empty($_POST['name'])) {
		$name = addslashes($_POST['name']);

	$sqlquery = "INSERT INTO tbllocations (name, id) VALUES ('$name', 4)";
	$dataresult = mysql_query($sqlquery);
}

Now the problem I am having is that when I post my form, 2 records get inserted instead of 1. I have for the life of me spent hours trying to figure out why but cannot resolve it. I have even dropped my mysql table and recreated it but to no avail and when I echo the query to the creen, the query is only displayed once.

Has any got any ideas as to what could be causing this?

Thanks

thepeccavi

Try this:

if (isset($_POST['name'])) {
        $name = addslashes($_POST['name']);

    $sqlquery = "INSERT INTO tbllocations (name, id) VALUES ('$name', 4)";
    $dataresult = mysql_query($sqlquery);
}

You could also try just leaving the "id" field as blank (make sure that it is auto-increment first)

Hope this helps

kbc1

Thanks for the suggestion thepeccavi but i have tried that also.

Very bizarre indeed.

thepeccavi

Maybe use single quotes and where you have variables use

$var = 'sime stuff' . $variable . 'more stuff';

Have you tried this?

etully

That is bizarre.

I would start to troubleshoot this by saying that the problem is either client side or server side. Maybe the HTML page is submitting twice? There are myriad techniques you can use to make it impossible to submit a form twice. Have you looked at your server side PHP script? Are there any more instances of "mysql_query($sqlquery);" For example, I made the mistake once of setting $query, executing the query on $query, and then setting $SQL_query but executing the query on $query again.

Also, is it possible that after you execute the query, you are including other files that could be executing the query again?

You might try this is a troubleshooting technique: At the top of your PHP script, say $m_time = microtime(); And insert that into the table too (to make it easy, you could append it to $name). Now, if the SCRIPT is the one that's inserting this twice, the two instances of $m_time will be exactly the same. If the HTML page is submitting twice, then the two instances will be different.

Start there - tell us what you figure out.

etully

Also, never rule out the print statement as a valid troubleshooting tool. Scatter your code with print statements that show which part of the code is currently running. If you submit your form and you find two instances of "Then it puts the $name in the table", then you might look for a loop or something that is making the same code execute twice.