Failing to update Table
Hi,
I've Used DB to creat insert and update pages.
Its the update page which is causing me problems - as its not updating changes made by user.
I've attached the page code
Hi,
I've Used DB to creat insert and update pages.
Its the update page which is causing me problems - as its not updating changes made by user.
I've attached the page code
The update seamed to work for me when i filled in the property information?
I left out key piece of information.
In the table that lists the 'room type' records created under that account, goto edit a line.
The selected record is presented for editing in the update page, but make some changes and update and they are not saved!
The problem is caused by variable persistence.
The update page uses a URL Variable to filter the rsGetSelectedRoom recordset,for example:
eid=18
in the update record behavior the $row_rsGetSelectedRoom['RmConfigIdx'] is used to tell which record to update.
When the page first loads, the eid UTRL variable is present, so the recordset has a value, when the form posts, the eid URL is not included, so the recordset is empty, the iupdate does not know what record to update.
to fix this, chnage the forms action:
<form class="Basic_Default" id="UpdateRoom" name="AddRoom" method="post" action="<?php echo (htmlentities($_SERVER["PHP_SELF"], ENT_QUOTES)); ?>">
to:
<form class="Basic_Default" id="UpdateRoom" name="AddRoom" method="post" action="<?php echo(htmlentities($_SERVER["PHP_SELF"], ENT_QUOTES)."?".$_SERVER["QUERY_STRING"]); ?>">
this will pass the query string when the form is submitted.
Thanks Jason, that form mod resolved it.
Now updating perfectly.
Your friends over here at WebAssist! These Dreamweaver extensions will assist you in building unlimited, custom websites.
These out-of-the-box solutions provide you proven, tested applications that can be up and running now. Build a store, a gallery, or a web-based email solution.