RE: [PHP] Re: Double entry into MySQL..

When they first click on the file their browser will make a request for type, size etc then when it display's the dialog box on the screen of the client it will make another request to start the download. I get around this by putting the session id into the database and if it is double requested within 5 seconds to discard. So you will need to do a select, num_rows then if below 1 insert. Timothy Hitchens (HiTCHO) Open Platform Consulting e-mail: tim@hitcho.com.au > -----Original Message----- > From: Altug Sahin [mailto:altug@bonsai-apart.com] > Sent: Wednesday, 8 January 2003 2:07 PM > To: php-general@lists.php.net > Subject: [PHP] Re: Double entry into MySQL.. > > > Another strange behaviour... When I send the name of the file > to be downloaded to this script, it works (still makes a > double entry into MySQL > though) with GET method but it doesn't work if the file's > name is sent with the POST method. > > Why? I am pulling my hair out here!!! > > Please help... > > Thanks again > > "Altug Sahin" <altug@bonsai-apart.com> wrote in message > news:20030107000217.7493.qmail@pb1.pair.com... > > Hi here, > > > > > I am sending a file to user's browser and logging the downloaded file > > into MySQL but everytime this script works, I see double > entry in the > > MySQL table... Why is this happening? > > > > Any ideas? > > > > Thanks > > > > <? > > $today = date("Y-m-d"); > > > > $conn = db_connect(); > > > > if(!$conn) > > echo "Can't connect to database..."; > > > > $query = "INSERT INTO track_dl (dldate, email, file) > > VALUES ('$today', 'user@email.com', 'file.ext')"; > > > > $result = mysql_query($query); > > > > if(!$result) > > echo "Can't execute query: " . mysql_error(); > > > > header("Content-type: application/pdf"); readfile("file.pdf"); > > exit(); > > ?> > > > > > > > > -- > PHP General Mailing List (http://www.php.net/) > To unsubscribe, visit: http://www.php.net/unsub.php >