PHP programming forum. Ask questions or help people concerning PHP code. Don't understand a function? Need help implementing a class? Don't understand a class? Here is where to ask. Remember to do your homework!
I am trying to update the amount of postings remaining down everytime a user posts so if the user had a limit of 200 posts then when the user posts it counts down by 1 and updates the table field for that user to 199.
Now the error that I am getting is that it does not count down correctly and puts 20 instead and then the next time the user posts after that it will put 0.
$remain = mysql_query("SELECT postings_remaining FROM ".TBL_USERS." WHERE username = '$session->username' limit 1");
$postings = $remain; //Count the number of postings remaining the user has
$postingsremain = $postings - 1; //Remove 1 to the users posting remainings
$sqlcountdown = mysql_query("UPDATE ".TBL_USERS." SET postings_remaining = '$postingsremain' WHERE username = '$session->username'");
If someone can help me with this function I would very much appreciate it.
Hey when a user posts you must be storing his id somewhere in database. just count all those records using his id and deduct them from 200 or whatever is the limit. You will get the remaining posts.
You need to fetch the data from the query using mysql_fetch_row first. Try this code, be sure to add error checking in case the user doesn't exist, etc...
$remain = mysql_query("SELECT postings_remaining FROM ".TBL_USERS." WHERE username = '$session->username' limit 1");
$remain = mysql_fetch_row($remain);
$postings = $remain[0]; //Count the number of postings remaining the user has
$postingsremain = $postings - 1; //Remove 1 to the users posting remainings
$sqlcountdown = mysql_query("UPDATE ".TBL_USERS." SET postings_remaining = '$postingsremain' WHERE username = '$session->username'");