Why isn't this working?
I have this line on one page..
..and it works fine. I have an if statement echoing "success, bla bla.." if it works and it's great. So why is it that this:
..doesn't work? What am I missing/not doing?
RESOLVED thanks everyone :)
$update_totals = "UPDATE stock SET qty = $add, count = $newtotal WHERE barcode = $barcode";
$update = mysql_query($update_totals, $connect);..and it works fine. I have an if statement echoing "success, bla bla.." if it works and it's great. So why is it that this:
$update_details = "UPDATE stock SET barcode = $barcode, prod_code = '$prodcode', printer_model = '$print_mod', desc = '$type', qty = $qty, count = $count, colour = '$colour', order_level = $reorder WHERE barcode = $old_bcode";
$update_qry = mysql_query($update_details, $connect);..doesn't work? What am I missing/not doing?
RESOLVED thanks everyone :)
