Is there any error in my sql query?

Question

I want to update my user_info table but it's not working. In my user_info I have already taken some values from one activity and from another activity I want to take some more values but it's not working. I'm pretty sure that there is no error in my Java code.. is there any error in my query?

$db_name = "db";
$mysql_user = "root";
$mysql_pass = "";
$server_name = "localhost";

$con = mysqli_connect($server_name, $mysql_user, $mysql_pass, $db_name);

$name = $_POST["user"];
$user_email = $_POST["user_email"];
$Gender = $_POST["Gender"];
$contact = $_POST["contact"];
$address = $_POST["address"];

$sql_query = "UPDATE user_info SET name='$name', Gender='$Gender', contact='$contact', address='$address' WHERE user_email='$user_email'";
mysqli_query($con,$sql_query)

mysqli_close($con);

no... everything is fine but value is not changing in my database — Bebo, Mar 08 '16 at 23:57
As @fusion3k said, check your `$_POST` variables. You're also using a [Mysql Reserved Word](https://dev.mysql.com/doc/refman/5.5/en/keywords.html), which will cause your query to fail. Wrap `name` in back-ticks -> `\`name\``. — Darren, Mar 09 '16 at 00:05
Output your query and put it in phpMyAdmin. There you will see errors if some occur. But please, please do queries the right way (MySQL injection safe). — Kevin Lieser, Mar 09 '16 at 00:11
@Darren `NAME` no `(R)` next to it, unlike `NATURAL (R)`. `name` is a "keyword" and not a "reserved" word. *Two different animals* here ;-) — Funk Forty Niner, Mar 09 '16 at 00:50
the error's `mysqli_query($con,$sql_query)` <<< there. No semi-colon. probably in conjunction with your POST arrays too, so check that. http://php.net/manual/en/function.error-reporting.php - if it's POST array related, the missing form is guesswork. — Funk Forty Niner, Mar 09 '16 at 00:51
@Darren Make it count, and make it a double shot.... *of Espresso* ;-) — Funk Forty Niner, Mar 09 '16 at 00:52
possible duplicate of [PHP Parse/Syntax Errors; and How to solve them?](http://stackoverflow.com/questions/18050071/php-parse-syntax-errors-and-how-to-solve-them) — Funk Forty Niner, Mar 09 '16 at 00:55
possible duplicate of [PHP: Notice: Undefined variable and Notice: Undefined index](http://stackoverflow.com/questions/4261133/php-notice-undefined-variable-and-notice-undefined-index) — Funk Forty Niner, Mar 09 '16 at 00:55
and use this too http://php.net/manual/en/mysqli.error.php and post your HTML form while you're at it. I won't be staying here much longer. — Funk Forty Niner, Mar 09 '16 at 00:56
@Fred-ii- It's what makes stackoverflow.....stackoverflow ;-) — Darren, Mar 09 '16 at 00:59
*sigh* @Darren I guess so. well... check out my comment to the guy. I'm gone watching TV. *ciao!* — Funk Forty Niner, Mar 09 '16 at 01:00

score 0 · Answer 1 · answered Mar 08 '16 at 23:59

0

Im not sure without seeing you database table but "Gender" is capitalized while the other field names are lowercase. Just a shot in the dark here, otherwise your query looks fine.

answered Mar 08 '16 at 23:59

Justin Herter

590
4
17

the word Gender is capitalized also in database – Bebo Mar 09 '16 at 00:01

Is there any error in my sql query?

1 Answers1