Location: PHPKode > scripts > MySQL/HTML-Client > mysqlhtml-client/modules/update.inc.php
<?php
    $fieldnames_new_array = explode("#", $fieldnames);
    $query_text = "UPDATE " . $table . " SET ";
    for ($i = 0; $i < count($fieldnames_new_array); $i++) {             
        $query_text .= $fieldnames_new_array[$i] . (($quotes[$i] == "$i") ? "=\"" . $textarea[$i] . "\"" : "=" . $textarea[$i]);        
        if ($i < count($fieldnames_new_array) - 1) $query_text .= ", ";
    }
    
    if ((strstr($primary_key_field, "__"))&&(strstr($radio_name, "__"))) {
        $primary_key_field_array = explode("__", $primary_key_field);
        $radio_name_array = explode("__", $radio_name);
        $query_text .= " WHERE";
        for ($i = 0; $i < sizeof($primary_key_field_array); $i++) {
            $query_text .= " " . $primary_key_field_array[$i] . "=\"" . $radio_name_array[$i] . "\"";
            if ($i < sizeof($primary_key_field_array)-1)
                $query_text .= " AND";
        }
    } else {
        $query_text .= " WHERE " . $primary_key_field . "=\"" . $radio_name . "\"";
    }
    @mysql_db_query($database, $query_text, $db_link) or mysql_client_error_msg($query_text, __FILE__, __LINE__);
?>
Return current item: MySQL/HTML-Client