/**
 * Update a record on another table
 */

// SQL statement parameters
$update_table  = 'greigepo';      // Table name
$update_where  = "P_O_NUMBER = '[var_po]'"; // Where clause
$update_fields = array(   // Field list, add as many as needed
     "STATUS = 'TEST'"
    
 );

// Update record
$update_sql = 'UPDATE ' . $update_table
    . ' SET '   . implode(', ', $update_fields)
    . ' WHERE ' . $update_where;
sc_exec_sql($update_sql);


NOTE THE FOLLOWING CHECK FOR AN EMPTY FIELD-  USE != NOT <>



/**
 * Update a record on another table
 */

// SQL statement parameters
$update_table  = 'grpcs';      // Table name
$update_where  = "p_o_number = '[var_po]'"; // Where clause
$update_and = "dye_order != '' ";
$update_fields = array(   // Field list, add as many as needed
     "lbs_used = lbs_recd "
 );

// Update record
$update_sql = 'UPDATE ' . $update_table
    . ' SET '   . implode(', ', $update_fields)
    . ' WHERE ' . $update_where . ' AND ' . $update_and;
sc_exec_sql($update_sql);



THis SQL WORKS TO ADD A PRIMARY KEY AND FILL IT IN

ALTER TABLE greigepo ADD ID2 INT PRIMARY KEY AUTO_INCREMENT;