Scriptcase 建立文字的會員編號

$tmp_str_id = str_pad({members_id}, 10, '0', STR_PAD_LEFT);
// SQL statement parameters
$update_table  = 'members';      // Table name
$update_where  = "members_id = {members_id}"; // Where clause
$update_fields = array(   // Field list, add as many as needed
     "members_ext_id = '$tmp_str_id'"
 );
// Update record
$update_sql = 'UPDATE ' . $update_table
    . ' SET '   . implode(', ', $update_fields)
    . ' WHERE ' . $update_where;
sc_exec_sql($update_sql);