Facing Syntax error in SQL query

    $query = "UPDATE `$database`.`$member` SET `email` = '$rowmem['email']' WHERE `id` = $rowmem['mem_id']";

​x
 
    $query = "UPDATE `$database`.`$member` SET `email` = '$rowmem['email']' WHERE `id` = $rowmem['mem_id']";​

I don’t know why but this line is showing an error in my page.

It’s said there is an syntax error.

Can anyone correct it ??

Answer

    $query = "UPDATE `$database`.`$member` 
              SET `email` = '".$rowmem['email']."' 
              WHERE `id` = ".$rowmem['mem_id'];

 
    $query = "UPDATE `$database`.`$member`               SET `email` = '".$rowmem['email']."'               WHERE `id` = ".$rowmem['mem_id'];​

I am sure it will be correct one.

Basically you added slashes which are not needed but you need to do concatenation.