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 

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'";

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-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">
<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
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\"> 
<table summary="" border="0" cellpadding="5" cellspacing="0"
width="90%" align="center">
<td><br /><div align="center"><input type="submit" name="submit" 
value="Submit" /></div></td>

Reply via email to