Skip to main content
A
Anonymous
March 20, 2009
Question

Creating Update and deleting Records Forms

  • March 20, 2009
  • 1 reply
  • 1242 views
Hi Guys

Hopefully some one can help me with this, I am using php and mysql, I already have a page that shows all the records of customers details, which I can navigate through the pages of records.

I have created a update page, using the update wizard, which works but only shows the first record. I have added a repeat region and page navigation which allows me to choose individual records but wont update those records.

I also took a look at a tutorial video that had you adding an extra column and add the word update to add a hyperlink that took you to the update form with that particular record for updating, the video was using cold fusion the link was update page address then this ?ID=#ID#, I tried different versions of this with no success.

I also tried to alter the record set and added a filter using Member_ID and = paramater URL, this made my cusomter detail page stop working.

can some one help please

Cheers
Mark
This topic has been closed for replies.

1 reply

N
Newsgroup_User
Inspiring
March 20, 2009
burkeslaw wrote:
> I also took a look at a tutorial video that had you adding an extra column and
> add the word update to add a hyperlink that took you to the update form with
> that particular record for updating, the video was using cold fusion the link
> was update page address then this ?ID=#ID#, I tried different versions of this
> with no success.

That's ColdFusion syntax. The correct syntax for PHP is shown on this
Dreamweaver help page:

http://help.adobe.com/en_US/Dreamweaver/10.0_Using/WScbb6b82af5544594822510a94ae8d65-78b3a.html

--
David Powers
Adobe Community Expert, Dreamweaver
http://foundationphp.com
N
Newsgroup_User
Inspiring
March 22, 2009
burkeslaw wrote:
> when the members update page opens with the update form it always shows the
> first record, wont show the record of the ID in the URL. How do I fix this?

Before applying the update record server behavior, you need to create a
recordset that uses the URL parameter as a filter.

--
David Powers
Adobe Community Expert, Dreamweaver
http://foundationphp.com
A
Anonymous
March 23, 2009
Hi David

Thanks for helping with this, I have actually already tried this using the URL paramenter in the recordset that I used for creating an Update form, I used Update Form wizard which was based on this particular recordset with a URL parameter. When you clicked on the update hyperlink from the recordset display page, it opened the update form put with no record data of the record I selected, all fields where blank. When I moused over the individual records update links, the URL in the bottom left hand corner would'nt show the record ID number, as it did before when I used the recordset I created for the recordset display page, I mentioned this earlier.

Is it that I have to create the update form manually and then select it and add the update form behaviour? Is there an Go to Detailed Page server behaviour for php, or is this just for ASP technology.

Cheers
Mark
Terms & ConditionsAccessibility statement
Using the community Terms of use Privacy Cookie preferences Do not sell or share my personal information ad choicesAdChoices