Databases
StackOverflow2013
Postsdbo
POhow to update a specific row that has the same values as the other row?
Body
 

Note that there are some explanatory texts on larger screens.

plurals
  1. POhow to update a specific row that has the same values as the other row?
    text
    copied!<p>I'm having a hard time figuring this one out. I have this database that will get bigger sooner or later and it looks like this.</p> <pre><code>est_id |mat_id | est_qty | qty_rec 2 | 29 | 50 | 0 3 | 29 | 70 | 0 8 | 29 | 100 | 0 </code></pre> <p>Now, what I want to accomplish is to update a single row until est_qty and qty_rec are equal then move to the other one after. I started a code but its not working.</p> <pre><code> foreach($mat_id as $mat_id_key =&gt; $mat){ while($rec_qty &gt; 0){ $remBal = $est_qty[$mat_id_key] - $qty_rec[$mat_id_key]; if(($remBal - $rec_qty) &gt;= 0){ mysql_query('UPDATE `estimates` SET `qty_rec` = `qty_rec` + '.$rec_qty.' WHERE `proj_id` = "'.$proj_id.'" AND `mat_id` = "'.$mat[$mat_id_key].'"'); } } } </code></pre> <p>In this code, each row will go in to loop, until its going to satisfy the condition which is the difference between est_qty and <code>$rec_qty</code> is a greater than or equal to zero it will update that row.</p> <p>For instance, the user input 30 as the <code>$rec_qty</code>, the database will now look like:</p> <pre><code>est_id |mat_id | est_qty | qty_rec 2 | 29 | 50 | 30 3 | 29 | 70 | 0 8 | 29 | 100 | 0 </code></pre> <p>When the user inputs the second time around, for instance 40 as <code>$rec_qty</code>, the database will now look like:</p> <pre><code>est_id |mat_id | est_qty | qty_rec 2 | 29 | 50 | 50 3 | 29 | 70 | 20 8 | 29 | 100 | 0 </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