Skip to main content
October 20, 2008
Question

edit recordset form not populating info

  • October 20, 2008
  • 1 reply
  • 248 views
I have a demo site that properly generates pages / displays recordsets, searches, additions to database, etc.

The one thing that I can't seem to get is how to pass on the values from a search result (or page data) to an edit page.

Let's say a user has entered in a new record but finds that they need to edit or update the info. I have provided an "edit" link on both the base detail page along with a link on a search result page. A user should be able to click on this link go to the edit page and see a number of form fields that are populated with the recordset that they want to edit.

Everything in the database has an ID associated to it, so that should...SHOULD be easy enough to pass along however that seems to be something i'm not glommming on to.

For example, on the search result page I have the following as an "edit" link:

<a href="edit_kaiju.php?recordID=<?php echo $row_SearchResult['kaijuID']; ?>"><?php echo $row_SearchResult['kaijuname']; ?></a>

however when a user clicks on the link the URL doesn't show an ID.

on the search form I have the ID as a hidden field - which could be where the problem starts...

Any suggestions?

Thanks!
This topic has been closed for replies.

1 reply

October 23, 2008
In DW I always apply the go to details page which will send the record ID to the edit page. One the edit page create a form for all of the datafields and bind them to a query that uses the record ID as the filter. Then use the update record behavour.