Google Groups no longer supports new Usenet posts or subscriptions. Historical content remains viewable.

Dismiss

Accessing data from multiple MySQL tables with NOF8

1 view

Skip to first unread message

unread,

Oct 26, 2005, 6:15:08 PM10/26/05

I have a database in mysql with the following tables

names, phones, emails

In the names table I have a contactID that is used to link multiple
phones and multiple emails to the name.

I'm trying to set up access to this using the NOF8 PHP capability for
mysql, so that I can for example display the data like this

name1 phone1 email1
phone2 email2
email3

name2 phone1 email1

name3 phone1 email1
phone2

I think i need to nest recordset interators, and be able to pass the
contactid from the name to each loop

Is this possible - or is there another way to achieve this - hope you
can help

Thanks
Steve

unread,

Oct 26, 2005, 6:43:36 PM10/26/05

Dear user at an invalid domain....

You may want to post this in the Fusion 8 components newsgroup.

Not many people hanging out in here these days.

--
Chuck Joslin - Team NetObjects
BeyondFusion.com - Your Fusion Community
www.beyondfusion.com

<us...@domain.invalid> wrote in message
news:djov5g$hc...@news01.netobjects.com...

unread,

Oct 26, 2005, 6:57:44 PM10/26/05

Thanks for the tip ... Chuck

I only noticed my name wasn't set once i posted the mail

Steve

0 new messages