Jump to content

Accessing Foreign Key


Recommended Posts

Using Dreamweaver 8.0.2, PHP 5.1.4, & MySQL 5

What I have successfully done this far is pull all the records from table1 in my database and listed them on a page using the server behaviors (ie. Business Name, First Name, Last Name, etc.). Also in table one are foreign keys to two other tables (table2 and table3). Now I made two additional server behaviors to pull the values of these two table onto my page.

I can drag the values of these two queries onto my page list (trying to do what I did with table1), but they only show the result of the first record. How do I link primary keys of table2 & table3 to their foreign keys of table1 so that have that they display correct values?

I hope that was clear, thank is advance.
Link to comment
Share on other sites

[a href=\"http://www.interaktonline.com/\" target=\"_blank\"]http://www.interaktonline.com/[/a]
I know, I know, I've extolled them quite a bit, but their extensions are simply of the highest quality I've found for app development. It costs a bit of money, though it probably is worth it in the end. Judging from your post, it seems that you want to use a MySQL join, and this lets you do it fairly easily.
Link to comment
Share on other sites

Thank you. I've been "eyeballing" their products all day today wondering if the investment was worth it. Actually I met some of the reps from Interakt a couple of weeks ago at TODCon (Dreamweaver conference) and was impressed by their commitment to PHP development.

Just in case I can't get the powers that be to purchase their set of extensions, does anyone have any other suggestions? It seems to be that it's a matter of figuring the correct SQL syntax other than what Dreamweaver automaticlly writes. What that is.... I can't figure out
Link to comment
Share on other sites

This thread is more than a year old. Please don't revive it unless you have something important to add.

Join the conversation

You can post now and register later. If you have an account, sign in now to post with your account.

Guest
Reply to this topic...

×   Pasted as rich text.   Restore formatting

  Only 75 emoji are allowed.

×   Your link has been automatically embedded.   Display as a link instead

×   Your previous content has been restored.   Clear editor

×   You cannot paste images directly. Upload or insert images from URL.

×
×
  • Create New...

Important Information

We have placed cookies on your device to help make this website better. You can adjust your cookie settings, otherwise we'll assume you're okay to continue.