Increase and decrease row value by 1 in MySQL

Posted by Elliott on Stack Overflow See other posts from Stack Overflow or by Elliott
Published on 2010-05-14T14:25:20Z Indexed on 2010/05/14 14:34 UTC
Read the original article Hit count: 236

Filed under:
|
|

Hi I have a MySQL database table "points" the user can click a button and a point should be removed from their account, the button they pressed has an ID of another user, therefore their account must increase by one.

I have it working in jQuery and checked the varibles/posts in Firebug, and it does send the correct data, such as:

userid= 1 
posterid = 4

I think the problem is with my PHP page:

<?php


include ('../functions.php');

$userid=mysql_real_escape_string($_POST['user_id']);
$posterid=mysql_real_escape_string($_POST['poster_id']);

if (loggedin()) 
{
include ('../connection.php');
$query1 = "UPDATE `points` SET `points` = `points` - 1 WHERE `userID` = '$userid'";
$result1=mysql_query($query1);


$query2 = "UPDATE `points` SET `points` = `points` + 1 WHERE `userID` = '$posterid'";
$result2=mysql_query($query2);


if ($result1 && result2)
{
    echo "Successful";  
    return 1;
}
else
{

    echo mysql_error();
    return 0;   
}
}
?>

Any ideas? Thanks :)

© Stack Overflow or respective owner

Related posts about sql

Related posts about mysql