Page Doesn't Load All the way, screws up queries.

[Duskwalker]

Hey there,

Cool new layout, I havent been on here in ages. I need some help with a small project I was working on.

When ppl refresh the page really fast, or the page doesnt load all the way the second query isn't executed. This causes the tick not to be counted, which duplicates the entry. I can use it to add like 100+ entries for myself that aren't valid.

Hope Im making sense, here is the code.

mysql_query("INSERT INTO items (owner,itemid) VALUES ('$username','$finditem[itemid]')");
mysql_query("UPDATE store SET stocked = stocked - 1 WHERE itemid = '$finditem[itemid]' && owner = '$username'");

It doesnt take away one from being stocked, but puts more into the items table. Im sure there is a quick fix to this?

Thanks for checking out my problem,
-Dusk

[VirtualX]

maybe you could look into 'output buffering' so the info isn't sent to the browser before it has completely loaded.

<?php

// start output buffering
ob_start();

// query1
// query2

// send data to browser
ob_end_flush();

?>