We value your feedback.
Take our survey and automatically be enter to win anyone of the following:
Yeti Cooler, Amazon eGift Card, and Movie eGift Card!
Solved
PHP MySQL update supquery
Posted on 2011-02-24
I'm sure this is a pretty simple question, but I can't think of a solution at the moment. I'm trying to update a decimal value, based on the current value of the field.
I want to reduce the amount in the field by the amount in a variable... something like this...
"currentrequest" is the current field... So, basically I want to update current request to be it's current value minus 100.00.
I've tried using a select subquery in there, and it tells me that I can't select the same table...
The error I receive is: "You can't specify target table 'budget' for update in FROM clause".
Thanks for any shoves in the right direction!
I want to reduce the amount in the field by the amount in a variable... something like this...
"currentrequest" is the current field... So, basically I want to update current request to be it's current value minus 100.00.
I've tried using a select subquery in there, and it tells me that I can't select the same table...
The error I receive is: "You can't specify target table 'budget' for update in FROM clause".
Thanks for any shoves in the right direction!
$reqAmt=100.00;
$removeFromBudget=@mysql_query("
UPDATE budget
SET currentrequest='currentrequest-".$reqAmt."'
WHERE acct='".$acctNum."' LIMIT 1");
[X]
Welcome to Experts Exchange
Add your voice to the tech community where 5M+ people just like you are talking about what matters.
- Help others & share knowledge
- Earn cash & points
- Learn & ask questions
-
4
3
7 Comments
Just found the answer... Posting in case anyone else needs it...
$removeFromBudget=@mysql_query("
UPDATE budget
SET currentrequest=((SELECT currentrequest)-".$reqAmt.")
WHERE acct='".$acctNum."' LIMIT 1");
That is the whole query... The sub query is in the SET currentrequest..... line...
Are you not seeing that line? Or am I describing it incorrectly?
Are you not seeing that line? Or am I describing it incorrectly?
Interesting... I was always taught that anything like that inside another query would be considered a subquery. Would you know what it should be called, then?
Featured Post
We value your feedback.
Take our survey and automatically be enter to win anyone of the following:
Yeti Cooler, Amazon eGift Card, and Movie eGift Card!
Question has a verified solution.
If you are experiencing a similar issue, please ask a related question
Containers like Docker and Rocket are getting more popular every day. In my conversations with customers, they consistently ask what containers are and how they can use them in their environment. If you’re as curious as most people, read on. . .
There are times when I have encountered the need to decompress a response from a PHP request.
This is how it's done, but you must have control of the request and you can set the Accept-Encoding header.
Learn how to match and substitute tagged data using PHP regular expressions. Demonstrated on Windows 7, but also applies to other operating systems. Demonstrated technique applies to PHP (all versions) and Firefox, but very similar techniques will w…
In this video, Percona Solution Engineer Rick Golba discuss how (and why) you implement high availability in a database environment.
To discuss how Percona Consulting can help with your design and architecture needs for your database and infrastr…
Suggested Courses
Course of the Month4 days, 9 hours left to enroll
661 members asked questions and received personalized solutions in the past 7 days.
Join the community of 500,000 technology professionals and ask your questions.