Error when trying to update only one column of MySQL table using php query?

Question

I am trying to update only one column of MySQL table using the code below, but for some reason it always fails and gives me Invalid query error! What am I doing wrong here?

$query = "UPDATE dbTester SET username ='$MediaUserName' WHERE ID = '".$row['ID']."'"; 
$result2 = mysql_query( $con, $query ); 
echo $query; 
if (!$result2) {
   die('Invalid query: ' . mysql_error());
}

Error:

UPDATE dbTester SET username ='cindy' WHERE ID = '10796'Invalid query:

thanks all for reply. If i copy and paste same query from echo to phpmyadmin the query updates the record successfully! so what might be the problem that it doesn't work in php ? — user1788736
– user1788736, Commented Nov 25, 2013 at 6:03

hjpotter92 · Accepted Answer · 2013-11-25 06:04:04Z

2

The error occurs because mysql_query expects first argument to be your query in string format and an optional second argument to be connection resource.

resource mysql_query ( string $query [, resource $link_identifier = NULL ] )

answered Nov 25, 2013 at 6:04

hjpotter92

81.1k36 gold badges148 silver badges188 bronze badges

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

2 Comments

user1788736 Over a year ago

could you tell me why(mysqli_affected_rows($result2) == 1){ echo "success";} is not working even i know that one row is updated?

hjpotter92 Over a year ago

@user1788736 Because you are confusing between mysql_* functions and mysqli_* ones.

Krish R · Accepted Answer · 2013-11-25 06:04:56Z

0

you should use, mysql_query($query); instead of mysql_query( $con, $query );

Your syntax suits for mysqli_query($con, $query );

answered Nov 25, 2013 at 6:04

Krish R

22.7k7 gold badges54 silver badges60 bronze badges

Collectives™ on Stack Overflow

Error when trying to update only one column of MySQL table using php query?

2 Answers 2

2 Comments

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

2 Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Related