IMO, you don't WANT to change that behavior. The category_id should
remain as a auto-fill field for the database itself, then just sort the
results of your categories by name or order instead of by id when
displaying out to the page.
HTH,
Wolf
Stephen wrote:
I have created some PHP scripts that use MySQL to organize the
photographs on my web site.
They are grouped into categories and the table for categories has these
fields:
Category_id
Category_order
Category_name
Category_description
When creating a category, the category_id field is blank
I want to create another form to allow populating and/or changing this
field and then updating the database.
I will select all category rows, dynamically build the form and update
the database, of course.
But the next level of detail is not clear to me.
What should I make the form look like? Can I do it so that after the
update order values will always go from 1 to n where n is the number of
categories?
Thanks
Stephen
--
PHP General Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php