[Resolved] Prob with double Insert only in Mozilla

PJNEW

Having a problem with a simple insert into a mysql table. In Mozilla (notIE5.5) it duplicates the insert. Anyone have any clues. This is the insert line.

$add = "INSERT INTO MyTable (Userid,imageid) values ('$Userid','$that')" ;

Am I doing something weird, or is a bug?

bubblenut

That's very bizare. Browser type shouldn't have an effect on his type of thing. How much have you tested this? Is it happening exactly the same every time in both browsers? Is the insert in any loops?
Cheers
Bubble

PJNEW

Yeah, I have been testing it all afternoon and on two different machines. Same thing every time. Baffled. And no it is not in a loop.

keith73

we need more code to find an answer. what's happening before this query is built and where is the code that executes the query?

your browser can't execute php code so it has to be something in the code causing the problem. Is the page somehow reloading itself? Does it redirect anywhere?

keith

PJNEW

Thanks Guys. This is the code before

session_start();
header("Cache-control: private"); 
error_reporting (E_ALL);

$Userid = session_id() ;

$var = @$_GET['ID'];

$trimmed = trim($var) ;

mysql_connect("localhost","user","pass"); 

mysql_select_db("dbase") or die("Unable to select database");

Afterwards, there is a big mess of a multidimensional array...So unless it is needed. However, there is no command to reload the page that I am aware of.

keith73

try commenting out the header command

//header("Cache-control: private");

and see if you still have that problem in mozilla.

if that is the culprit, try setting it to no-cache or instead use Pragma: no-cache.

keith

PJNEW

Have commented out the line, but it has made no difference. By the way, we have also noticed that if you refresh the page it only enters the data to the table once. If you wish you can try it out from here http://www.styleseating.co.uk/search2.php?q=CCH
click an item and add it to the quote basket. Use that page cos the search is a duplicate and the links to the other products use a different search page.

PJNEW

I suspect that it is something to do with this line

$Userid = session_id() ;

or the way that the variable is called in this line

$add = "INSERT INTO MyTable (Userid,imageid) values ('$Userid','$that')" ;

because, when I change $Userid to equal 1, it works fine. So it has something to do with the way that sessions are being handled...but I am not sure what. Also, it carried on with this intermittent behaviour until I removed sessions and cookies from the equation altogether.

PJNEW

I am absolutely amazed that no one has come across this problem before. I have since checked it in Opera and it works fine also. Just a problem with Mozilla. Saying that I have researched this solid and not come across a solution or even something similar

PJNEW

I isolated the insert query and could not get the problem. Therefore it has to be something to do with the script relaoding. So let's say that this one is resolved. Even though I do not yet know what caused it :-)