Problemas con bucle while

tumbero_x · #1 (**permalink**) 20/12/2011, 06:39

Hola Amigos
se me presento un problema y necesito de su ayuda
tengo este codigo

Código PHP:

Ver original$sql4=mysql_query("SELECT M.marca_id, M.marca_detalle FROM marcas M",Conectar::con())or die (mysql_error()) ;
while($fila4=mysql_fetch_array($sql4))
{       
        $sql5 = mysql_query("SELECT MR.manufacturer_id FROM manufacturer MR ",Conectarse::remota())or die (mysql_error()) ;
        while($fila5=mysql_fetch_array($sql5))
        {       
        
            if($fila4['marca_id']==$fila5['manufacturer_id'])
                    { 
                        mysql_query("UPDATE manufacturer SET  name='".$fila4['marca_detalle'] ."' WHERE manufacturer_id = ".$fila4['marca_id'],Conectarse::remota())or die (mysql_error()) ;
                    }
                    else 
                    {   
                        mysql_query("INSERT INTO manufacturer VALUES('".$fila4['marca_id']."','".$fila4['marca_detalle']."','','0')",Conectarse::remota())or die (mysql_error());
                        //mysql_query("DELETE FROM manufacturer WHERE manufacturer_id WHERE manufacturer_id = ".$fila5['manufacturer_id'] ,Conectarse::remota());
                    }
        }
}

mi problema es que cuando lo ejecuto la bd me da este error
Duplicate entry '1' for key 'PRIMARY'
es obvio que el while esta queriendo hacer siempre lo mismo
pero no se como resolverlo para que se ejecute una sola vez por cada registro que tenga el array
MUchas gracias por ayudar a este novato
Saludos

bUllan9ebrio · #2 (**permalink**) 20/12/2011, 06:49

Hola tumbero_x, puedes mostrar la estructura de tu base de datos , tienes algun campo autoincrementable?

Saludos

tumbero_x · #3 (**permalink**) 20/12/2011, 06:52

Hola bUllan9ebrio
Si, hay uno que es autoincrementable
la idea de ese codigo es que si los registros son iguales haga un update y si que haga un insert

SirDuque · #4 (**permalink**) 20/12/2011, 06:55

La estructura del while-while-if esta bien.

¿Este es el codigo original, o lo editaste para que lo entendamos?

tumbero_x · #5 (**permalink**) 20/12/2011, 06:57

si si , es el codigo original
(esta re mal no? jaja)

SirDuque · #6 (**permalink**) 20/12/2011, 07:14

Provemos algo distinto:

Código PHP:

  $sql4=mysql_query("SELECT M.marca_id, M.marca_detalle FROM marcas M",Conectar::con())or die (mysql_error()) ; 
$fila4=mysql_fetch_row($sql4); 
// cerra la conexion local. 
$sql5 = mysql_query("SELECT MR.manufacturer_id FROM manufacturer MR ",Conectarse::remota())or die (mysql_error()) ; 
$fila5=mysql_fetch_row($sql5); 
 
for( $i = 0; $i < count($fila4); $i++) 
{ 
 if( in_array($fila4[$i], $fila5) 
 { 
 mysql_query("UPDATE manufacturer SET  name='".$fila4[$i][1] ."' WHERE manufacturer_id = ".$fila4[$i][0],Conectarse::remota())or die (mysql_error()) ; 
 }else{ 
 mysql_query("INSERT INTO manufacturer VALUES('".$fila4[$i][0]."','".$fila4[$i][1]."','','0')",Conectarse::remota())or die (mysql_error()); 
 
 } 
} 
// cerra la conexion remota.

tumbero_x · #7 (**permalink**) 20/12/2011, 07:23

Buenisimo gracias!!!
pero me esta tirando un error el codigo
Parse error: syntax error, unexpected '{' in /home/sincroni/public_html/sv/act_web.php on line 99
y la verdad yo lo veo perfecto tenes idea que puede ser la linea 99 es esta
if(in_array($fila4[$i],$fila5)
{ // esta es la linea99
muchas gracias

SirDuque · #8 (**permalink**) 20/12/2011, 07:29

Me faltaba cerrar el if

Código PHP:

  $sql4=mysql_query("SELECT M.marca_id, M.marca_detalle FROM marcas M",Conectar::con())or die (mysql_error()) ;  
$fila4=mysql_fetch_row($sql4);  
// cerra la conexion local.  
$sql5 = mysql_query("SELECT MR.manufacturer_id FROM manufacturer MR ",Conectarse::remota())or die (mysql_error()) ;  
$fila5=mysql_fetch_row($sql5);  
 
for( $i = 0; $i < count($fila4); $i++)  
{  
 if( in_array($fila4[$i], $fila5) ) 
 {  
 mysql_query("UPDATE manufacturer SET  name='".$fila4[$i][1] ."' WHERE manufacturer_id = ".$fila4[$i][0],Conectarse::remota())or die (mysql_error()) ;  
 }else{  
 mysql_query("INSERT INTO manufacturer VALUES('".$fila4[$i][0]."','".$fila4[$i][1]."','','0')",Conectarse::remota())or die (mysql_error());  
 
 }  
}

tumbero_x · #9 (**permalink**) 20/12/2011, 07:31

ya esta me faltaba cerrar el if
y ME FUNCIONO PERFECTO!!!!
gracias
AHora necesito eliminar los id que no estan en la tabla marcas pero si en la tabla manufacturer
como lo podria lograr?

SirDuque · #10 (**permalink**) 20/12/2011, 07:38

Agregale este for abajo:

Código PHP:

  for( $i = 0; $i < count($fila5); $i++)  
{  
 if( !in_array($fila5[$i], $fila4) ) 
 {  
mysql_query("DELETE FROM manufacturer WHERE manufacturer_id WHERE manufacturer_id = ".$fila5[$i] ,Conectarse::remota()); 
 }  
}

tumbero_x · #11 (**permalink**) 20/12/2011, 07:49

Perdon pero me equivoque, no me esta funcionando como necesito
no hace el update y hace un insert vacio
disculpame mi ignorancia pero que podria ser?
Muchas gracias!!!

SirDuque · #12 (**permalink**) 20/12/2011, 09:09

[QUOTE=SirDuque;4073086]Agregale este for abajo:

[PHP]
echo "<pre>";
print_r($fila5);
echo "</pre>";
echo "<pre>";
print_r( $fila4);
echo "</pre>";

Para ver los resultados. de los dos select

tumbero_x · #13 (**permalink**) 20/12/2011, 09:15

me esta dando este resultado , pero me faltan registros , en total son 40 y solamente esta tomando el primero
Array
(
[0] => 1
)
Array
(
[0] => 1
[1] => hp
)
Array
(
[0] => 1
)
Array
(
[0] => 1
[1] => hp
)

SirDuque · #14 (**permalink**) 20/12/2011, 09:57

Eso no me sirve...

OK Pone este codigo, en ves usar los Query los imprimimos.

Código PHP:

  $sql4=mysql_query("SELECT M.marca_id, M.marca_detalle FROM marcas M",Conectar::con())or die (mysql_error()) ;   
$fila4=mysql_fetch_row($sql4);   
// cerra la conexion local.   
$sql5 = mysql_query("SELECT MR.manufacturer_id FROM manufacturer MR ",Conectarse::remota())or die (mysql_error()) ;   
$fila5=mysql_fetch_row($sql5);   
 
for( $i = 0; $i < count($fila4); $i++)   
{   
 if( in_array($fila4[$i], $fila5) )  
 {   
 echo "UPDATE manufacturer SET  name='".$fila4[$i][1] ."' WHERE manufacturer_id = ".$fila4[$i][0]."<br>";   
 }else{   
 echo "INSERT INTO manufacturer VALUES('".$fila4[$i][0]."','".$fila4[$i][1]."','','0') <br>"; 
 }   
}

tumbero_x · #15 (**permalink**) 20/12/2011, 10:00

me imprimio esto

UPDATE manufacturer SET name='' WHERE manufacturer_id = 1
INSERT INTO manufacturer VALUES('h','p','','0')

Gracias por tu paciencia!!!

SirDuque · #16 (**permalink**) 20/12/2011, 10:19

Cita:

Iniciado por tumbero_x

me imprimio esto

UPDATE manufacturer SET name='' WHERE manufacturer_id = 1
INSERT INTO manufacturer VALUES('h','p','','0')

Gracias por tu paciencia!!!

¿Y como seria correcto?

tumbero_x · #17 (**permalink**) 20/12/2011, 10:28

Perdon
lo correcto seria asi

UPDATE manufacturer SET name='' WHERE manufacturer_id = 1
INSERT INTO manufacturer VALUES('1','hp','','0')
pero igualmente esta recorriendo un solo elemento del array
tenes idea porque?
Gracias

SirDuque · #18 (**permalink**) 20/12/2011, 10:33

volvamos al bucle, y mostrame lo que imprime:

Código PHP:

  $sql4=mysql_query("SELECT M.marca_id, M.marca_detalle FROM marcas M",Conectar::con())or die (mysql_error()) ; 
while($fila4=mysql_fetch_array($sql4)) 
{        
        $sql5 = mysql_query("SELECT MR.manufacturer_id FROM manufacturer MR ",Conectarse::remota())or die (mysql_error()) ; 
        while($fila5=mysql_fetch_array($sql5)) 
        {        
         
            if($fila4['marca_id']==$fila5['manufacturer_id']) 
                    {  
                        echo "UPDATE manufacturer SET  name='".$fila4['marca_detalle'] ."' WHERE manufacturer_id = ".$fila4['marca_id']."<br>"; 
                    } 
                    else  
                    {    
                        echo "INSERT INTO manufacturer VALUES('".$fila4['marca_id']."','".$fila4['marca_detalle']."','','0') <br>"; 
 
                       } 
        } 
}

tumbero_x · #19 (**permalink**) 20/12/2011, 10:38

te pongo todo lo que me imprimio

UPDATE manufacturer SET name='hp' WHERE manufacturer_id = 1
INSERT INTO manufacturer VALUES('1','hp','','0')
INSERT INTO manufacturer VALUES('1','hp','','0')
INSERT INTO manufacturer VALUES('1','hp','','0')
INSERT INTO manufacturer VALUES('1','hp','','0')
INSERT INTO manufacturer VALUES('1','hp','','0')
INSERT INTO manufacturer VALUES('1','hp','','0')
INSERT INTO manufacturer VALUES('1','hp','','0')
INSERT INTO manufacturer VALUES('1','hp','','0')
INSERT INTO manufacturer VALUES('1','hp','','0')
INSERT INTO manufacturer VALUES('1','hp','','0')
INSERT INTO manufacturer VALUES('1','hp','','0')
INSERT INTO manufacturer VALUES('1','hp','','0')
INSERT INTO manufacturer VALUES('1','hp','','0')
INSERT INTO manufacturer VALUES('1','hp','','0')
INSERT INTO manufacturer VALUES('1','hp','','0')
INSERT INTO manufacturer VALUES('3','epson','','0')
UPDATE manufacturer SET name='epson' WHERE manufacturer_id = 3
INSERT INTO manufacturer VALUES('3','epson','','0')
INSERT INTO manufacturer VALUES('3','epson','','0')
INSERT INTO manufacturer VALUES('3','epson','','0')
INSERT INTO manufacturer VALUES('3','epson','','0')
INSERT INTO manufacturer VALUES('3','epson','','0')
INSERT INTO manufacturer VALUES('3','epson','','0')
INSERT INTO manufacturer VALUES('3','epson','','0')
INSERT INTO manufacturer VALUES('3','epson','','0')
INSERT INTO manufacturer VALUES('3','epson','','0')
INSERT INTO manufacturer VALUES('3','epson','','0')
INSERT INTO manufacturer VALUES('3','epson','','0')
INSERT INTO manufacturer VALUES('3','epson','','0')
INSERT INTO manufacturer VALUES('3','epson','','0')
INSERT INTO manufacturer VALUES('3','epson','','0')
INSERT INTO manufacturer VALUES('5','hasar','','0')
INSERT INTO manufacturer VALUES('5','hasar','','0')
UPDATE manufacturer SET name='hasar' WHERE manufacturer_id = 5
INSERT INTO manufacturer VALUES('5','hasar','','0')
INSERT INTO manufacturer VALUES('5','hasar','','0')
INSERT INTO manufacturer VALUES('5','hasar','','0')
INSERT INTO manufacturer VALUES('5','hasar','','0')
INSERT INTO manufacturer VALUES('5','hasar','','0')
INSERT INTO manufacturer VALUES('5','hasar','','0')
INSERT INTO manufacturer VALUES('5','hasar','','0')
INSERT INTO manufacturer VALUES('5','hasar','','0')
INSERT INTO manufacturer VALUES('5','hasar','','0')
INSERT INTO manufacturer VALUES('5','hasar','','0')
INSERT INTO manufacturer VALUES('5','hasar','','0')
INSERT INTO manufacturer VALUES('5','hasar','','0')
INSERT INTO manufacturer VALUES('5','hasar','','0')
INSERT INTO manufacturer VALUES('7','samsung','','0')
INSERT INTO manufacturer VALUES('7','samsung','','0')
INSERT INTO manufacturer VALUES('7','samsung','','0')
INSERT INTO manufacturer VALUES('7','samsung','','0')
UPDATE manufacturer SET name='samsung' WHERE manufacturer_id = 7
INSERT INTO manufacturer VALUES('7','samsung','','0')
INSERT INTO manufacturer VALUES('7','samsung','','0')
INSERT INTO manufacturer VALUES('7','samsung','','0')
INSERT INTO manufacturer VALUES('7','samsung','','0')
INSERT INTO manufacturer VALUES('7','samsung','','0')
INSERT INTO manufacturer VALUES('7','samsung','','0')
INSERT INTO manufacturer VALUES('7','samsung','','0')
INSERT INTO manufacturer VALUES('7','samsung','','0')
INSERT INTO manufacturer VALUES('7','samsung','','0')
INSERT INTO manufacturer VALUES('7','samsung','','0')
INSERT INTO manufacturer VALUES('7','samsung','','0')
INSERT INTO manufacturer VALUES('9','Asus','','0')
INSERT INTO manufacturer VALUES('9','Asus','','0')
INSERT INTO manufacturer VALUES('9','Asus','','0')
INSERT INTO manufacturer VALUES('9','Asus','','0')
INSERT INTO manufacturer VALUES('9','Asus','','0')
INSERT INTO manufacturer VALUES('9','Asus','','0')
UPDATE manufacturer SET name='Asus' WHERE manufacturer_id = 9
INSERT INTO manufacturer VALUES('9','Asus','','0')
INSERT INTO manufacturer VALUES('9','Asus','','0')
INSERT INTO manufacturer VALUES('9','Asus','','0')
INSERT INTO manufacturer VALUES('9','Asus','','0')
INSERT INTO manufacturer VALUES('9','Asus','','0')
INSERT INTO manufacturer VALUES('9','Asus','','0')
INSERT INTO manufacturer VALUES('9','Asus','','0')
INSERT INTO manufacturer VALUES('9','Asus','','0')
INSERT INTO manufacturer VALUES('9','Asus','','0')
INSERT INTO manufacturer VALUES('11','Gygabyte','','0')
INSERT INTO manufacturer VALUES('11','Gygabyte','','0')
INSERT INTO manufacturer VALUES('11','Gygabyte','','0')
INSERT INTO manufacturer VALUES('11','Gygabyte','','0')
INSERT INTO manufacturer VALUES('11','Gygabyte','','0')
INSERT INTO manufacturer VALUES('11','Gygabyte','','0')
INSERT INTO manufacturer VALUES('11','Gygabyte','','0')
INSERT INTO manufacturer VALUES('11','Gygabyte','','0')
UPDATE manufacturer SET name='Gygabyte' WHERE manufacturer_id = 11
INSERT INTO manufacturer VALUES('11','Gygabyte','','0')
INSERT INTO manufacturer VALUES('11','Gygabyte','','0')
INSERT INTO manufacturer VALUES('11','Gygabyte','','0')
INSERT INTO manufacturer VALUES('11','Gygabyte','','0')
INSERT INTO manufacturer VALUES('11','Gygabyte','','0')
INSERT INTO manufacturer VALUES('11','Gygabyte','','0')
INSERT INTO manufacturer VALUES('11','Gygabyte','','0')
INSERT INTO manufacturer VALUES('13','creative','','0')
INSERT INTO manufacturer VALUES('13','creative','','0')
INSERT INTO manufacturer VALUES('13','creative','','0')
INSERT INTO manufacturer VALUES('13','creative','','0')
INSERT INTO manufacturer VALUES('13','creative','','0')
INSERT INTO manufacturer VALUES('13','creative','','0')
INSERT INTO manufacturer VALUES('13','creative','','0')
INSERT INTO manufacturer VALUES('13','creative','','0')
INSERT INTO manufacturer VALUES('13','creative','','0')
UPDATE manufacturer SET name='creative' WHERE manufacturer_id = 13
INSERT INTO manufacturer VALUES('13','creative','','0')
INSERT INTO manufacturer VALUES('13','creative','','0')
INSERT INTO manufacturer VALUES('13','creative','','0')
INSERT INTO manufacturer VALUES('13','creative','','0')
INSERT INTO manufacturer VALUES('13','creative','','0')
INSERT INTO manufacturer VALUES('13','creative','','0')
INSERT INTO manufacturer VALUES('15','Intel','','0')
INSERT INTO manufacturer VALUES('15','Intel','','0')
INSERT INTO manufacturer VALUES('15','Intel','','0')
INSERT INTO manufacturer VALUES('15','Intel','','0')
INSERT INTO manufacturer VALUES('15','Intel','','0')
INSERT INTO manufacturer VALUES('15','Intel','','0')
INSERT INTO manufacturer VALUES('15','Intel','','0')
INSERT INTO manufacturer VALUES('15','Intel','','0')
INSERT INTO manufacturer VALUES('15','Intel','','0')
INSERT INTO manufacturer VALUES('15','Intel','','0')
UPDATE manufacturer SET name='Intel' WHERE manufacturer_id = 15
INSERT INTO manufacturer VALUES('15','Intel','','0')
INSERT INTO manufacturer VALUES('15','Intel','','0')
INSERT INTO manufacturer VALUES('15','Intel','','0')
INSERT INTO manufacturer VALUES('15','Intel','','0')
INSERT INTO manufacturer VALUES('15','Intel','','0')
INSERT INTO manufacturer VALUES('17','Amd','','0')
INSERT INTO manufacturer VALUES('17','Amd','','0')
INSERT INTO manufacturer VALUES('17','Amd','','0')
INSERT INTO manufacturer VALUES('17','Amd','','0')
INSERT INTO manufacturer VALUES('17','Amd','','0')
INSERT INTO manufacturer VALUES('17','Amd','','0')
INSERT INTO manufacturer VALUES('17','Amd','','0')
INSERT INTO manufacturer VALUES('17','Amd','','0')
INSERT INTO manufacturer VALUES('17','Amd','','0')
INSERT INTO manufacturer VALUES('17','Amd','','0')
INSERT INTO manufacturer VALUES('17','Amd','','0')
UPDATE manufacturer SET name='Amd' WHERE manufacturer_id = 17
INSERT INTO manufacturer VALUES('17','Amd','','0')
INSERT INTO manufacturer VALUES('17','Amd','','0')
INSERT INTO manufacturer VALUES('17','Amd','','0')
INSERT INTO manufacturer VALUES('17','Amd','','0')

UPDATE manufacturer SET name='kodak' WHERE manufacturer_id = 27
INSERT INTO manufacturer VALUES('27','kodak','','0')
INSERT INTO manufacturer VALUES('27','kodak','','0')
INSERT INTO manufacturer VALUES('29','Viewsonic','','0')
INSERT INTO manufacturer VALUES('29','Viewsonic','','0')
INSERT INTO manufacturer VALUES('29','Viewsonic','','0')
INSERT INTO manufacturer VALUES('29','Viewsonic','','0')
INSERT INTO manufacturer VALUES('29','Viewsonic','','0')
INSERT INTO manufacturer VALUES('29','Viewsonic','','0')
INSERT INTO manufacturer VALUES('29','Viewsonic','','0')
INSERT INTO manufacturer VALUES('29','Viewsonic','','0')
INSERT INTO manufacturer VALUES('29','Viewsonic','','0')
INSERT INTO manufacturer VALUES('29','Viewsonic','','0')
INSERT INTO manufacturer VALUES('29','Viewsonic','','0')
INSERT INTO manufacturer VALUES('29','Viewsonic','','0')
INSERT INTO manufacturer VALUES('29','Viewsonic','','0')
INSERT INTO manufacturer VALUES('29','Viewsonic','','0')
UPDATE manufacturer SET name='Viewsonic' WHERE manufacturer_id = 29
INSERT INTO manufacturer VALUES('29','Viewsonic','','0')
INSERT INTO manufacturer VALUES('31','Apple','','0')
INSERT INTO manufacturer VALUES('31','Apple','','0')
INSERT INTO manufacturer VALUES('31','Apple','','0')
INSERT INTO manufacturer VALUES('31','Apple','','0')
INSERT INTO manufacturer VALUES('31','Apple','','0')
INSERT INTO manufacturer VALUES('31','Apple','','0')
INSERT INTO manufacturer VALUES('31','Apple','','0')
INSERT INTO manufacturer VALUES('31','Apple','','0')
INSERT INTO manufacturer VALUES('31','Apple','','0')
INSERT INTO manufacturer VALUES('31','Apple','','0')
INSERT INTO manufacturer VALUES('31','Apple','','0')
INSERT INTO manufacturer VALUES('31','Apple','','0')
INSERT INTO manufacturer VALUES('31','Apple','','0')
INSERT INTO manufacturer VALUES('31','Apple','','0')
INSERT INTO manufacturer VALUES('31','Apple','','0')
UPDATE manufacturer SET name='Apple' WHERE manufacturer_id = 31
ahora si esta trayendo todo

SirDuque · #20 (**permalink**) 20/12/2011, 10:53

Tenes un grabe problema en el Servidor Remoto.

fijate:
SELECT MR.manufacturer_id FROM manufacturer MR WHERE manufacture_id ='1'
Y decime cuantos registros aparecen.

tumbero_x · #21 (**permalink**) 20/12/2011, 10:56

ya te digo

tumbero_x · #22 (**permalink**) 20/12/2011, 11:01

me dio esto
MySQL ha devuelto un conjunto de valores vacío (es decir: cero columnas). ( La consulta tardó 0.0085 seg )
pero esta bien porque no hay ningun registro con esa id
empieza des el 5 y va hasta el 10 solamente tengo 5 registros
te agradezco toda la ayuda que me estas brindando
ahora, todos estos problemas que tengo se me solucionan vaciando la tabla manufacturer y volver a llenarla con los registros de marcas
pero el otro dia en el foro me dijeron que no haga eso ni loco, y con la poca experiencia que tengo , segui ese consejo
vos que opinas al respecto
si vacio la tabla y despues la vuelvo a llenar , tender algun problema?

vicman · #23 (**permalink**) 20/12/2011, 11:20

La verdad mi amigo, yo toda esas tareas las resumiria en 3 simples querys de SQL ejecutados en ese orden.

Código SQL:

Ver original//UPDATE
UPDATE manufacturer  
SET name = ( 
  SELECT  M.marca_detalle FROM marcas M WHERE M.marca_id = manufacturer.manufacturer_id
);
 
//INSERT
INSERT INTO manufacturer (manufacturer_id,name)
SELECT M.marca_id, M.marca_detalle FROM marcas M WHERE M.marca_id NOT IN( SELECT  manufacturer_id FROM manufacturer)
 
 
//DELETE
DELETE FROM manufacturer WHERE manufacturer_id NOT IN(SELECT M.marca_id FROM marcas M)

Código PHP:

Ver original//actualizo los registros comunes
$sql=mysql_query("UPDATE manufacturer  
SET name = ( 
  SELECT  M.marca_detalle FROM marcas M WHERE M.marca_id = manufacturer.manufacturer_id
)",Conectar::con())or die (mysql_error()) ; 
 
//Ingreso los registros que no existan en manufacurer
$sql =mysql_query("INSERT INTO manufacturer (manufacturer_id,name)
SELECT M.marca_id, M.marca_detalle FROM marcas M WHERE M.marca_id NOT IN( SELECT  manufacturer_id FROM manufacturer)",Conectar::con())or die (mysql_error()) ; 
 
 
//Elimino los id que no estan en la tabla marcas pero si en la tabla manufacturer
$sql=mysql_query("DELETE FROM manufacturer WHERE manufacturer_id NOT IN(SELECT M.marca_id FROM marcas M)",Conectar::con())or die (mysql_error()) ;

Un saludo.

tumbero_x · #24 (**permalink**) 20/12/2011, 11:28

Hola vicmanya estube probandolo asi pero el problema es que para hacer una subconsulta necesito que las 2 bases de datos esten en el mismo servidor y yo las tengo separadas
Gracias!!!!

SirDuque · #25 (**permalink**) 21/12/2011, 07:26

tumbero_x

En el servidor A (seria el local) cuantos registros tenes.

En el servidor B (seria el remoto) cuantos registros tenes.

Para eliminar el doble Bucle, lo elimnamos de la siguiente manera:

Código PHP:

  $SQL_A = "SELECT id,detalle FROM tablaA"; 
$QUERY_A = mysql_query( $SQL_A )or die( "Query A: ".mysql_error() ); 
while($a = mysql_fetch_row( $QUERY_A ) ) 
{ 
 $SQL_B = "SELECT id,detalle FROM tablaB WHERE id='{$a[0]}'"; 
 $QUERY_B = mysql_query( $SQL_B ) or die( "Query B: ".mysql_error()); 
 $row = mysql_num_rows($QUERY_B);  
 if( $row > 1 ) 
 { 
    echo "El id: {$d[0]} esta duplicado en el servidor Remoto"; 
 }elseif( $row == 0 ) 
 { 
  $SQL_B = "SELECT id,detalle FROM tablaB WHERE id='{$d[0]}'"; 
  $QUERY_Bis = mysql_query( $SQL_B ) or die( "Query B: ".mysql_error()); 
  $d = mysql_fetch_row($QUERY_Bis); 
 
   $SQL_INSERT = "INSERT INTO tablaB VALUES ('{$d[0]}','{[1]}',NULL,'0')"; 
   mysql_query( $SQL_INSERT ) or die( "Error al Insert: ".mysql_error()); 
   echo "Se agrego el id: {$d[0]}"; 
 }elseif( $row == 1 ) 
 { 
  $SQL_B = "SELECT id,detalle FROM tablaB WHERE id='{$d[0]}'"; 
  $QUERY_Bis = mysql_query( $SQL_B ) or die( "Query B: ".mysql_error()); 
  $d = mysql_fetch_row($QUERY_Bis); 
 
   $SQL_UPDATE = "UPDATE tablaB SET detalle = '{$d[1]}' WHERE id='{$d[0]}'"; 
   mysql_query( $SQL_UPDATE ) or die( "Error al Update: ".mysql_error()); 
   echo "Se actualizo el id: {$d[0]}"; 
 } 
}

tumbero_x · #26 (**permalink**) 21/12/2011, 07:30

Hola SirDuque
segui viendo como lo podia solucionar
y en algun lado descubri una sentencia mysql que no tenia ni idea que existia

Código PHP:

Ver originalmysql_query("INSERT INTO manufacturer (manufacturer_id,name,image,sort_order)VALUES('".$fila4['marca_id']."','".$fila4['marca_detalle']."','','0') ON DUPLICATE KEY UPDATE name='".$fila4['marca_detalle']."' ",Conectarse::remota());

y me ahorro unos cuantos if y else en PHP
asi que esta es my solucion
te agradezco infinitamente todo el tiempo que me has dedicado
Saludos!!!

SirDuque · #27 (**permalink**) 21/12/2011, 09:12

Cita:

Iniciado por tumbero_x

Hola SirDuque
segui viendo como lo podia solucionar
y en algun lado descubri una sentencia mysql que no tenia ni idea que existia

Código PHP:

Ver originalmysql_query("INSERT INTO manufacturer (manufacturer_id,name,image,sort_order)VALUES('".$fila4['marca_id']."','".$fila4['marca_detalle']."','','0') ON DUPLICATE KEY UPDATE name='".$fila4['marca_detalle']."' ",Conectarse::remota());

y me ahorro unos cuantos if y else en PHP
asi que esta es my solucion
te agradezco infinitamente todo el tiempo que me has dedicado
Saludos!!!

Excelente, yo tampoco la conocia. XD!