SQL syntax error php db class

Question

I have a form which needs to be updated I get a sql error. Cant see whats going on with my sql statement in my class file. Need assistance in finding where the issue is.

public function update(){
    global $database;
$sql = "UPDATE ".self::$table_name." SET when = '{$database->mysql_prep($this->when)}', where = '{$database->mysql_prep($this->where)}', howmuch = '{$database->mysql_prep($this->howmuch)}', contact = '{$database->mysql_prep($this->contact)}', daytimephone = '{$database->mysql_prep($this->daytimephone)}', emailqueries = '{$database->mysql_prep($this->emailqueries)}', websiteurl = '{$database->mysql_prep($this->websiteurl)}', description = '{$database->mysql_prep($this->description)}' WHERE id='{$database->mysql_prep($this->id)}'";
    $database->query($sql);
    return ($database->affected_rows() == 1) ? true:false;
}

jtheman · Accepted Answer · 2013-03-07 20:51:12Z

5

WHEN and WHERE are reserved keywords in MySQL. Enclose them in backticks if you need to use those as field names:

`where`
`when`

edited Mar 7, 2013 at 20:51

answered Mar 7, 2013 at 20:36

jtheman

7,5013 gold badges32 silver badges40 bronze badges

Sign up to request clarification or add additional context in comments.

3 Comments

prodigitalson Over a year ago

So is when... its used with CASE

prodigitalson Over a year ago

stupid formatting is messin' with yo' backicks - i fixed it up a bit, hope you dont mind :-)

jtheman Over a year ago

@prodigitalson Yeah I just went through hell trying to make the backticks look good and keep code formatting... Thanks for editing! (-:

Collectives™ on Stack Overflow

SQL syntax error php db class

1 Answer 1

3 Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

3 Comments

Your Answer

Sign up or log in

Post as a guest

Related