Re: How to do an update with arithmetic from a user input

On Thu, 12 Aug 2004 12:46:19 -0700, Chip Wiegand <chip.wiegand@simrad.com> wrote: > I have an existing database and web page showing the query results. I have > added another field to allow a user to input a two digit number. I want > that number to change the number in one of the existing columns for the > item it was input next to. > I have these columns - > > Part Number Description Quantity List Price Put on > hold > > I want the Quantity column changed according to the number the user input > in the Put on hold column. > I'm stuck in the query to write, trying to do > > $sql1 = "update refurbs set qty(qty - $qty) order by 'description'"; Perhaps: $sql1 = "update refurbs set qty = qty - $qty"; Also, 1) you have no WHERE there, so this will update *all* records. 2) why are you trying to order an update?? > > but that doesn't work. I have pasted in the main part of the code below... > Thanks for any help you can provide, > > Chip Wiegand > Computer Services > Simrad, Inc > 425-778-8821 > 425-771-7211 (FAX) > > BTW, thanks for the replys to the first message, I was expecting the list > to be much more busy. > ======================================================================================= > > <form action="<? PHP_SELF ?>" method="post" > name="refurbs"> > > <table summary="" border="1" cellpadding="5" > cellspacing="0" > width="90%" align="center"> > <tr> > <td class="small" bgcolor="#ffffff">Part Number</td> > <td class="small" bgcolor="#ffffff">Description</td> > <td class="small" bgcolor="#ffffff">Quantity</td> > <td class="small" bgcolor="#ffffff">List Price</td> > <td class="small" bgcolor="#ffffff">Special Price</td> > <td class="small" bgcolor="#ffffff">Put on Hold > </td> > </tr> > <? > if (isset($submit)): > > $sql = "update refurbs set qty(qty - '$buy') order by > 'description'"; > > $result = mysql_query($sql); > > $Colors = array('#ffcc99','#ffcc33'); > $I = 0; > > while ( $row = mysql_fetch_array($result)) > { > printf("<tr bgcolor=" . $Colors[ $I ++ % count( $Colors ) ] . > "><td>%s\n</td>\n", $row["part_number"]); > printf("<td>%s\n</td>\n", $row["description"]); > printf("<td>%s\n</td>\n", $row["qty"]); > printf("<td>%s\n</td>\n", $row["list"]); > printf("<td>%s\n</td>\n", $row["special"]); > printf("<td><input type=\"text\" name=\"buy\" > size=\"2\" maxlength=\"2\"> > </td></tr>\n"); > } > ?> > </table> > <table summary="" border="0" cellpadding="5" > cellspacing="0" > width="90%" align="center"> > <tr> > <td><br /><div align="center"><input type="submit" > name="submit" > value="Submit" /></div></td> > </tr> > </table> > </form> > -- DB_DataObject_FormBuilder - The database at your fingertips http://pear.php.net/package/DB_DataObject_FormBuilder paperCrane --Justin Patrin--