Welcome to Code Forum!

Join a community that supports you and your coding journey from day one. We strive to be a friendly, supportive community that empowers everyone to be better developers. By registering with us, you'll be able to discuss, share and private message with other members of our community.

SignUp Now!
  • Guest, before posting your code please take these rules into consideration:
    • It is required to use our BBCode feature to display your code. While within the editor click < / > or >_ and place your code within the BB Code prompt. This helps others with finding a solution by making it easier to read and easier to copy.
    • You can also use markdown to share your code. When using markdown your code will be automatically converted to BBCode. For help with markdown check out the markdown guide.
    • Don't share a wall of code. All we want is the problem area, the code related to your issue.

    GIF shows where to locate </> in the thread and or post editor toolbar.
    To learn more about how to use our BBCode feature, review our "How to post your code into threads" here.

    Thank you, Code Forum.

PHP Help with statement & query

C

chrisj

Bronze Coder
Can tell me if I have anything wrong with this:


PHP: 
$wallet = $user->wallet;


    if ($sell_video == 0 && $wallet >= 1) {
      $db->rawQuery("UPDATE ".T_USERS." SET `wallet` = `wallet`- 0.5 WHERE `id` = '".$video->user_id."'");
}
 
Sort by date Sort by votes
Thanks for your reply. I've tried that code, but no success. Success would be (upon a transaction) when sell_video is 0 and the wallet is >= 1 then deduct 0.5 from the wallet.

Any guidance with this is greatly appreciated.
 
Upvote 0 Downvote
"No success" does not mean anything to me. Do you get a PHP error ? A database error ? Any other kind of error ? Assuming that query was indeed executed, have you checked your database logs ?
 
Upvote 0 Downvote
Play Snayk 3+, higher dimensional snake game?

New Threads

Latest posts

Share this page

Buy us a coffee!

Buy me a coffee.
DataCamp Advertisement
Code Academy Advertisement

About Us

Code Forum is a community platform where coding enthusiasts can connect with other developers, engage in discussions, ask for help, and share their knowledge with a supportive community. It's a perfect place to improve your coding skills and to find a community of like-minded individuals who share your passion for coding.

Site links

Stay Connected

Back
Top Bottom