villas
-
Posts
1 -
Joined
-
Last visited
Never
We have placed cookies on your device to help make this website better. You can adjust your cookie settings, otherwise we'll assume you're okay to continue.
MySQL + PHP - UPDATE with do...while
in MySQL Help
Posted
I need UPDATE a NEW table with data of OLD table (only 2 columns) in all table (1600 regs) comparing with another diferent column
The script was an parser error in first UPDATE nd stop.
[code]
<?php require_once('../Connections/connNOR2.php'); ?>
<?php
//----recordset (OLD table)-------------
mysql_select_db($database_connNOR2, $connNOR2);
$query_rsREAJUSTAtudoVELHA = "SELECT * FROM tab082005_2";
$rsREAJUSTAtudoVELHA = mysql_query($query_rsREAJUSTAtudoVELHA, $connNOR2) or die(mysql_error());
$row_rsREAJUSTAtudoVELHA = mysql_fetch_assoc($rsREAJUSTAtudoVELHA);
$totalRows_rsREAJUSTAtudoVELHA = mysql_num_rows($rsREAJUSTAtudoVELHA);
//----------------------------------
$codTT=$row_rsREAJUSTAtudoVELHA['tab_cod'];
$velha_hier=$row_rsREAJUSTAtudoVELHA['tab_hier'];
//-----------------------------------
//----recordset (NEW table)---------------
mysql_select_db($database_connNOR2, $connNOR2);
$query_rsREAJUSTAtudoNOVA = "SELECT * FROM tab01022006_2 WHERE tab_cod='$codTT'";
$rsREAJUSTAtudoNOVA = mysql_query($query_rsREAJUSTAtudoNOVA, $connNOR2) or die(mysql_error());
$row_rsREAJUSTAtudoNOVA = mysql_fetch_assoc($rsREAJUSTAtudoNOVA);
$totalRows_rsREAJUSTAtudoNOVA = mysql_num_rows($rsREAJUSTAtudoNOVA);
?>
<?php do {
// put the "hhhh" and "eeee" where value is empty.
if ($velha_hier=='')
{
UPDATE tab01022006_2 SET tab_hier='hhhh',qtde_emb='eeee'; // <---PARSE ERROR ??
} else {
// put the OLD value in a NEW table
UPDATE tab01022006_2 SET tab01022006_2.tab_hier=$row_rsREAJUSTAtudoVELHA['tab_hier'], qtde_emb=$row_rsREAJUSTAtudoVELHA['qtde_emb'];
}
?>
<?php } while ($row_rsREAJUSTAtudoNOVA = mysql_fetch_assoc($rsREAJUSTAtudoNOVA)); ?>
<?php
mysql_free_result($rsREAJUSTAtudoVELHA);
mysql_free_result($rsREAJUSTAtudoNOVA);
?>
[/code]
Thanks and sory about the english
Villas