THE BORE

General => The Superdeep Borehole => Topic started by: GilloD on July 08, 2009, 04:30:58 PM

Title: Can you spot my SQL error? I can't!
Post by: GilloD on July 08, 2009, 04:30:58 PM

Code: [Select]

$queryall="SELECT * FROM new_batch WHERE po_num='$curr_po_num'";
$result=mysql_query($queryall) or die(mysql_error());
while($row=mysql_fetch_array($result)){
$delivery_num=$row[deliverynum];
$swapbatch="INSERT INTO archive_batch SELECT * FROM new_batch WHERE po_num='$curr_po_num'";
$deletebatch="DELETE FROM new_batch WHERE po_num='$curr_po_num'";
// echo "PO NUM SWAPPED: '$row[po_num]'";
$swapbatchresult = @mysql_query($swapbatch);
$deletebatchresult = @mysql_query($deletebatch);
// echo "RECORD SWAPPED 1 line";

}
$queryall_bol="SELECT * FROM bol_new WHERE po_num='$curr_po_num'";
$result_bol=mysql_query($queryall_bol) or die(mysql_error());
while($row_bol=mysql_fetch_array($result_bol)){
[b]$swapbatch="INSERT INTO bol_archive SELECT * FROM bol_new WHERE po_num='$curr_po_num'";[/b] //WON'T ARCHIVE
$deletebatch="DELETE FROM bol_new WHERE po_num='$curr_po_num'"; //WILL DELETE
// echo "PO NUM SWAPPED: '$row_bol[po_num]'";
$swapbatchresult = @mysql_query($swapbatch);
$deletebatchresult = @mysql_query($deletebatch);
}

$queryall_lots="SELECT * FROM lots_new WHERE lot_rec='$curr_po_num'";
$result_lots=mysql_query($queryall_lots) or die(mysql_error());
while($row_lot=mysql_fetch_array($result_lots)){
$swapbatch="INSERT INTO lots_archive SELECT * FROM lots_new WHERE lot_rec='$curr_po_num'";
$deletebatch="DELETE FROM lots_new WHERE lot_rec='$curr_po_num'";
//echo "PO NUM SWAPPED: '$row[po_num]'";
$swapbatchresult = @mysql_query($swapbatch);
$deletebatchresult = @mysql_query($deletebatch);
//echo "RECORD SWAPPED 1 line";

}
Everything works EXCEPT that bold line. I can't fucking figure it out. What am I missing?

Title: Re: Can you spot my SQL error? I can't!
Post by: GilloD on July 08, 2009, 05:53:40 PM

Quote from: Borys on July 08, 2009, 05:52:35 PM

BOL_ARCHIVE and BOL_NEW have the same number of columns and same data types?

Yeah. That was my thought. I;'ll double check, but I don't think I've made any changes in like a month

Title: Re: Can you spot my SQL error? I can't!
Post by: GilloD on July 08, 2009, 06:27:24 PM

ADOY. That was it. Stupid. Thanks BORYS.