Mark Hensler — Sun, 05 May 2002 06:17:34 +0000

Ssorry, I made a boo boo.

<?php
function insert($table, $fields) {
    
    foreach ($fields as $key=>$val) {
        $field[$key] = \"$key='$val'\";
    }
    $insert = \"INSERT INTO $table SET \";
    $insert .= implode(\", \", $fields);

// . . . 
?>

nike_guy_man — Sun, 05 May 2002 01:03:06 +0000

I'm getting this error repeatedly... it never ends lol

Quote:
Warning: Variable passed to key() is not an array or object in /home/parrabal/project/clients_message.php on line 11

Line 11 is

<?php
$fields[$i] = key($fields[$i]) . \"='\" . $fields[$i] . \"'\"; 
?>

Mark Hensler — Sat, 04 May 2002 23:28:59 +0000

hmm...

<?php
function insert($table, $fields) {
    
    for ($i=0; $i<count($fields); $i++) {
        $fields[$i] = key($fields[$i]) . \"='\" . $fields[$i] . \"'\";
    }
    $insert = \"INSERT INTO $table SET \";
    $insert .= implode(\", \", $fields);
    
    $return = mysql_query($insert);
    if ($return) {
        print \"Message added to $account<br>\";
        echo $client_message_type;
        print \"<br>$account<br> $name<br>\";
    } else {
        print \"Error: It didn't work\";
        echo mysql_error();
    }
}

// table  : type
// fields : name, description, subject, email, content
$values = array(
                //field => value
                'name' => $name,
                'description' => $description,
                'subject' => $subject,
                'email' => $email,
                'content' => $content);

if ($type == \"New\") {
    insert('new', $values);
} elseif ($type == \"Update\") {
    insert('update', $values);
}
?>