passing variables along url for database update of record?

[guypc]

Hi,

Over past few days i have been asking questions about dreamweaver CS4 database tools stating that i dont understand them.

Well things have change now and i am loving cs4 even more. I watched over 10 videos teaching how to use the database tools in dreamweaver and i have successully saved myself from buying something like datassist etc saving money and realising there is more functionality by using what is already built into dreamweaver.

I basically have a list page that lists all records from database, 15 records per page, a delete page, insert page and update page.

What i am focusing on with some help is the list page and update page.

Using dreamweaver tools built in when i click on the unique id on the list page it bines the id to the url and loads the update page with all user details intact great stuff. Now on the update page i set it to filter by id and url parameter which obviously works and needs to be as i am using the id link.

Thing i want to do now is link the username and email address to the update page like i did for the id, problem is when i create the link using dreamweaver tools same like i did for ID apart from this time it passes the username to the url which is good but it does not show the users information on update page.

Now i think this maybe something to do with on the update page that it is filtered to id and url paramenter, so how do i basically link the username and email address to the update page so when i click on the username or email address it shows there information on the update page?

it works fine for id but i think because it is set to filter via id url parameter why it wont work the username and email address so i am trying to figure out how to come over this so i can click on username or email address and let the same thing happen as when i do for ID.

Now sorry i don't think this may make any sence i am relatively new to dreamweaver and doing my best to explain.

Thank you

guypc

[bregent]

Your question is confusing. Is this a master/detail set you are working on? Is the username/email address something that is being retrieved from the database? If that's the case, then you don't want to pass the username or email in the url, you would retrieve from the db by the id value. You may want to post your workflow more clearly and concisely.

[guypc]

Hi i am sorry for confusing.

I have a database that has

id

status

username

first_name

last_name

email

password

ip

date_time

activation key

now on my list page i have it showin: ID / Status / Username / First Name / Last Name / Email

now after creating a recordset and making it show 15 records per page etc i then clicked on the id in table and choose from properties window browse (the folder icon) then selected the file update.php and then clicked on parameters gave the name id and value id so when i then click on a users id  it takes me to the update.php page and shows there information as it suppose to by passing the user id along the url.

This is fine. now i want to make the username and email address do the same so when i click on them it takes me to the update page and loads the user information from DB like it does with the ID. Basically same thing but different text link.

Is that better explained?

it just basically allows me to select either id, username or email address instead of just id, just preference really.

thank you

guypc

[David_Powers]

Thread moved to Dreamweaver Application Development forum.

[bregent]

>Basically same thing but different text link.

If I understand correctly, you want them to be able to click on different columns on the master page and open the same detail page? If so, then you still want to have the link pass the ID, since that is the attribute that uniquely identifies the user. And of course the detail page is already setup to retrieve based on ID. So you just need to modify the master page so that it passes the ID to the detail page when any column is clicked.

Now, how to accomplish this using the server behaviors is something I have not done in quite a while as I code everything manually. I'll bow out and let someone more familiar with the SB's take it from here.

[guypc]

Thanks i managed to figure it out now.