StackOverflow2013

Note that there are some explanatory texts on larger screens.

plurals

POMy PHP SQL query is throwing errors, even though it works in the SQL console
text
Body
copied!<p>I'm trying to create a function for my forum that will increment my user's "Posts" attribute by 1. For whatever reason, the following PHP does not work.</p> <pre><code>function postCountIncrease($username) { //get the connection variable global $con; //change to the users database (this function works correctly) sqlconnect_users(); //get current post number (this is also working) $getCurrentPosts = "SELECT Posts\n" . "FROM users\n" . "WHERE Username='".$username."'"; $query1 = mysqli_query($con, $getCurrentPosts) or die(mysqli_error($con)); $currentPosts = mysqli_fetch_array($query1); //here is the problematic post. Assume that $username is a valid value, and that I've already done mysqli_real_escape_string() on it $incrementPostsQuery = "UPDATE users.users SET Posts=". $currentPosts[0]+1 ." WHERE Username='". $username ."'"; $query2 = mysqli_query($con, $incrementPostsQuery) or die(mysqli_error($con)); //return the result $result = mysqli_fetch_array($query2); return $result; } </code></pre> <p>I honestly don't see what I'm doing wrong, because the SQL works fine. If I use <code>UPDATE users.users SET Posts=1 WHERE Username='Lampitosgames'</code> in the console, it works with no errors. Help is much appriciated. Also, here is the error it is throwing at me:</p> <pre><code>You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '1 WHERE Username='Lampitosgames'' </code></pre>

Querying!

Guidance

An individual column

Larger individual text columns get their own page to allow for proper reading.

SQuiL has stopped working due to an internal error.

If you are curious you may find further information in the browser console, which is accessible through the devtools (F12).

Reload