Skip to main content
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

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
March 22, 2009
Hi David

Thanks for your help I will give this a try, it seems the most simple way to update and delete records in the database.

One question do I have to add a filter, using the field id to the recordset or will this work without the filter which is how it is now.

Cheers
Mark