MySQL - Can't update multiple columns

Question

Whenver i try to update my columms in a selected row from PHP, it passed through without error, but it doesn't update in the database.

$query = "UPDATE news SET title = '$title', 
                  cover = '$cover', desc = '$newz', category = '$category' 
        WHERE id = $newz_select_id";

Does a simple `SELECT` or `INSERT` query work? Also you should know that your query is vulnerable to [SQL injection attack](https://www.owasp.org/index.php/SQL_Injection) if any of the variables are obtained from the user. — Ranhiru Jude Cooray, Sep 23 '12 at 16:56

score 4 · Accepted Answer · edited May 23 '17 at 11:49

4

desc is a reserved keyword in MySQL. Escape it with backtick ( ` ) instead.

$query = "UPDATE news SET title = '$title', 
              cover = '$cover', `desc` = '$newz', category = '$category' 
    WHERE id = $newz_select_id";

by the way, your code is very susceptible to sql injection. in order to avoid it, please study and use PHP PDO or PHP mySQLi Extensions.

See this Link: Best way to prevent SQL Injection

edited May 23 '17 at 11:49

Community

1
1

answered Sep 23 '12 at 14:24

John Woo

249,283
65
481
481

Wow, thank you so much John, that's good to know. Btw it worked ;) – Kevin Jensen Petersen Sep 23 '12 at 14:26
@KevinJensenPetersen you're welcome! – John Woo Sep 23 '12 at 14:26

MySQL - Can't update multiple columns

1 Answers1