$asql = "SELECT batch_line, row_id FROM test_batch_lines WHERE exe_c = 'N' "; $bsql = "UPDATE test_batch_lines SET exe_c = 'Y' WHERE exe_c = 'N' " AND row_id = '$XYZ' " ;