php mysqli query won't work

Question

I'm trying to increase the value in the table by one but I don't really know mysql and I don't know whats wrong. It seems to go through no problem but when I check the database the number hasn't changed. Thanks in advance! :)

    $con = mysqli_connect($db_host, $db_user, $db_pass, $db_name);

if (mysqli_connect_errno()) {
    echo "Failed to connect to MySQL: " . mysqli_connect_error();
} else {
    echo "it works!";
}

switch ($_POST['found']) {
    case "facebook":
        mysqli_query($con,"UPDATE `found` SET `number` = 'number + 1' WHERE `id` = 'Facebook'");


        break;

this is erroring out `= 'number + 1'` and http://php.net/manual/en/mysqli.error.php would have told you about it. — Funk Forty Niner, Mar 31 '16 at 17:27
Hi sorry I'm only learning mysqli, how do i increment it by one so that is does error out? thanks a mill! — james, Mar 31 '16 at 17:29
just remove the quotes around that and you'll be good to go ;-) — Funk Forty Niner, Mar 31 '16 at 17:30
You have to remove the quotes around number+1, and i would work. When you are using a column name in your query, you shouldn't wrap it with quotes — bksi, Mar 31 '16 at 17:30
you are setting `number` to a string, `number + 1`, because of the quotes. — Jonathan Kuhn, Mar 31 '16 at 17:30

score 1 · Answer 1 · answered Mar 31 '16 at 17:30

1

Try this:

 case "facebook":
    mysqli_query($con,"UPDATE `found` SET number = number + 1 WHERE `id` = 'Facebook'") or die(mysqli_error($con));

Hope this helps.

answered Mar 31 '16 at 17:30

Indrasis Datta

8,692
2
14
32

Thank you so much! – james Mar 31 '16 at 17:32

php mysqli query won't work

1 Answers1