Foreach help

[fubowl]

 

    public function update($data, $table, $where) {

        foreach ($data as $column => $value) {

            $sql = "UPDATE $table SET $column = $value WHERE $where";

print "table: ".$table." column: ".$column." where: ".$where;

            mysql_query($sql) or die(mysql_error());

        }

        return true;

    }

 

 

$data:

$data = array(

    "username" => "Jack",

    "email" => "jack.gmail@gmail.com"

);

 

 

$db->update($data, "users", 'id=1');

 

Working on this code that updates a column from a class. Everything is fine except for one issue.

 

As of right now $column is set to "Jack" which outputs an error, instead of what it should be as "username". I'm sure it's something really simple, so any assistance is appreciated. Any ideas? Problem area is listed in red.

[fubowl]

Whoops, that wasn't the issue.

$sql should have =

$sql = "UPDATE $table SET $column='$value' WHERE $where";