I am creating a form for editing records output from a mysql db (edit as an
html form). I've done this many times, but have never run into this issue.
I have code like this for the query:
$edit_list = mysql_query("SELECT general_inventory.quantity FROM
products_to_categories, general_inventory WHERE
products_to_categories.categories_id = $cat AND
products_to_categories.products_id = general_inventory.product_id ORDER BY
general_inventory.name");
And like this for getting the output, inside a while loop:
$edit_details = mysql_fetch_array ($edit_list);
$qty = $edit_details['quantity'];
<td align='center'><input type=text name='qty$ed' value='$qty'
size='3'></td>
Now, I get more than one column in a row, but I abbreviated it for here and
for testing. Every column comes out and fills in the form properly except
this one.
The issue I am having is that the value of the input text box is being
listed as '1', even if the database shows either a value of nothing
(meaning, blank) or a value of zero.
Anyone have any idea why this might be?
Thanks,
-Mike
--
PHP General Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php
