Que tal, estoy insertando registros con este script, la verdad no sé por qué razon me inserta de a 2 registros en vez de a uno como es normal...........pueden ayudarme ?
Código PHP:
<?php
$host="localhost";
$user="root";
$password="";
mysql_connect($host,$user,$password);
$result2 = mysql_db_query("mi_bd","SELECT country, company_name,
provider_id FROM provider
WHERE provider_id=".$_GET['provider_id']."");
if($row = mysql_fetch_array($result2))
{
$provider_id=$row["provider_id"];
$country=$row["country"];
$company_name=$row["company_name"];
}
$file_name= "Agreement.doc";
$path="../../files/empresas/$country/Providers/$company_name/$file_name";
$upload_date = date("Y/m/d");
$file_size= "1234";
$uploaded_by=$_SESSION['usuario_name'];
$insercion=mysql_db_query ("mi_bd","INSERT INTO provider_file
(provider_id, path, file_name, upload_date, file_size, uploaded_by)VALUES
('$provider_id','$path','$file_name','$upload_date',
'$file_size','$uploaded_by')");
echo "<script>window.opener.location.reload(); window.close();</script>";exit;
?>