error in sql syntax
Posted: Thu Mar 06, 2008 12:13 pm
Hi
I cannot find the error in the sql code below. can you help me?
thanks
the sql code:
the parent code:
I cannot find the error in the sql code below. can you help me?
thanks
the sql code:
Code: Select all
$sql = "UPDATE member SET " .
"name = $processed[fullname], email = $processed[email],accounttype = $processed[accounttype],bankaccount = $processed[bankaccount], email_priv = $email_priv " .
"WHERE id = $_SESSION[uid]";Code: Select all
if ($form->valid() ) {
$processed = $form->getProcessed();
$email_priv = isset($processed['email_priv']) ? "'y'" : "'n'";
$sql = "UPDATE member SET " .
"name = $processed[fullname], email = $processed[email],accounttype = $processed[accounttype],bankaccount = $processed[bankaccount], email_priv = $email_priv " .
"WHERE id = $_SESSION[uid]";
$result = $db->query($sql);