Php wont run MySQL update query, But the query works in MySQL console

Question

My php script seems to not want to update my table although the exact query im trying to run works when i use it directly in the MySQL console. Also I have to say that selection querys have worked for me, its only updates that dont work..

heres my code:

ConnectToMySQL();

function ConnectToMySQL() {
    /* First Connects to the Server */
$link = mysql_connect("localhost", "root", "*******");
    if (!$link) {
        die("Could not connect: " . mysql_error());
    }
    /* Than chooses the DB */
$db_selected = mysql_select_db("irina", $link);
    if (!$db_selected) {
        die ("Can't use internet_database : " . mysql_error());
    }                
}

$Query = "UPDATE subtopics SET SubTopic_Name =  'spirit' WHERE SubTopic_ID='spirituality';";
mysql_query($Query);

again I want to point out to you that the query has proven to work in the MySQL console, and that other querys work for me.

PSA: The mysql_* functions are deprecated in PHP 5.5. It is not recommended for writing new code as it will prevent you from upgrading in the future. Instead, use either MySQLi or PDO and be a better PHP Developer. — Jason McCreary
– Jason McCreary, Commented Sep 22, 2013 at 2:02
Try removing the trailing ; in the query. Queries through mysql_query should not end in a semicolon: "An SQL query: The query string should not end with a semicolon. Data inside the query should be properly escaped." (php.net/manual/en/function.mysql-query.php) But as the others said, don't use mysql_query() as it's been depreciated. — Taj Morton
– Taj Morton, Commented Sep 22, 2013 at 2:10

Community · Accepted Answer · 2017-05-23 12:19:47Z

2

you have an unwanted character in query UPDATE remove ``

Good read

edited May 23, 2017 at 12:19

CommunityBot

11 silver badge

answered Sep 22, 2013 at 2:01

john wright

435 bronze badges

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

1 Comment

Avriel Moscovitz Over a year ago

Thats funny, I dont see the character you're talking about.

user2246924 · Accepted Answer · 2018-08-24 21:59:44Z

1

I had the same issue but with code that had previously worked. Turned out to be an invalid character in the field name. A couple things that helped find it. When I echoed query and copied from the webpage view into Navicat for MySQL, it worked fine but when I "viewed source" then copied it, it got an error with the field name. If anyone is having similar issues, try that. The browser could be fixing something in the display view. Adding ` around field names also helped narrow it down.

answered Aug 24, 2018 at 21:59

user2246924

1053 bronze badges

Comments

Angel · Accepted Answer · 2013-09-22 04:10:11Z

0

remove the ; in the variable $Query

answered Sep 22, 2013 at 4:10

Angel

1463 silver badges11 bronze badges

Collectives™ on Stack Overflow

Php wont run MySQL update query, But the query works in MySQL console

3 Answers 3

1 Comment

Comments

Comments

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

3 Answers 3

1 Comment

Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Linked

Related