|
|
Posted by BBFish on 06/05/05 04:42
$sql15 ="SELECT * FROM ".$table['clie']."ripa WHERE ir_contr = 'P';";
$result15 = $db->sql_query($sql15);
while($row15=$db->sql_fetchrow($result15)){
$sdl ="INSERT INTO ".$table['maga']."ordini SET
wh_mz='".$row15['ir_mz']."',
wh_ci='".$row15['ir_ci']."',
wh_quantita='".$row15['ir_qty']."',
wh_prezzo='".$row15['ir_list']."',
wh_iv='".$row15['ir_iv']."',
wh_daordine=NOW(),
wh_ru='".$row15['ir_ru']."',
wh_fp='".$row15['ir_fp']."',
wh_condiz='P'
";
$ddl=$db->sql_query($sdl);
if($ddl == TRUE){
echo $upd = "UPDATE ".$table['clie']."ripa SET ir_contr = 'O' WHERE
IR='".$row15['IR']."';";
$db->sql_query($upd);
}
}
they give of the errors if the script comes in a hurry refresh,
exists the possibility one to make it in an only one query?
trancks
Navigation:
[Reply to this message]
|