error in sql syntax

PHP programming forum. Ask questions or help people concerning PHP code. Don't understand a function? Need help implementing a class? Don't understand a class? Here is where to ask. Remember to do your homework!

Moderator: General Moderators

Post Reply
m2babaey
Forum Contributor
Posts: 364
Joined: Sun May 20, 2007 9:26 am

error in sql syntax

Post by m2babaey »

Hi
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]";
the parent code:

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);
kryles
Forum Contributor
Posts: 114
Joined: Fri Feb 01, 2008 7:52 am

Re: error in sql syntax

Post by kryles »

try

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]. "'";
 
 
m2babaey
Forum Contributor
Posts: 364
Joined: Sun May 20, 2007 9:26 am

Re: error in sql syntax

Post by m2babaey »

thanks but didn't work
kryles
Forum Contributor
Posts: 114
Joined: Fri Feb 01, 2008 7:52 am

Re: error in sql syntax

Post by kryles »

try using

Code: Select all

 
 
print $sql
 
 
to make sure the SQL looks the way you want (with the right variables)
misteryyy
Forum Newbie
Posts: 5
Joined: Mon Mar 03, 2008 11:45 am
Location: Czech republic

Re: error in sql syntax

Post by misteryyy »

Try this :

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];
 
 
kryles
Forum Contributor
Posts: 114
Joined: Fri Feb 01, 2008 7:52 am

Re: error in sql syntax

Post by kryles »

i suppose I should have asked if it is a number or string :oops:
zjstandup
Forum Newbie
Posts: 1
Joined: Tue Apr 24, 2007 11:03 pm

Re: error in sql syntax

Post by zjstandup »

I used to write as:

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]. "'";
 
every variable quoted by " ' " :P
Post Reply