- Original Message -
From: "Rachel Rodriguez" <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Sent: Friday, April 23, 2004 3:55 AM
Subject: [PHP-DB] assigning variables after one-to-many query
> Hi!
>
> I have a one-to-many relationship between two tabl
> what i would do is add it into an array:
>
> $emails = Array();
> while ($row = mysql_fetch_array($result,MYSQL_NUM))
> {
> $emails[] = $row[0];
> }
>
> then u have an array with :
>
> $emails[0] = [EMAIL PROTECTED]
> $emails[1] = [EMAIL PROTECTED]
> etc...
>
>
Thanks, Uzi! This is ex
Hi,
I would try:
Select email
>From table2, table3
Where table3.emailID = table2.emailID
And id = "1"
This should give you
[EMAIL PROTECTED]
[EMAIL PROTECTED]
[EMAIL PROTECTED]
FG
--
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php
- Original Message -
From: "Rachel Rodriguez" <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Sent: Friday, April 23, 2004 3:55 AM
Subject: [PHP-DB] assigning variables after one-to-many query
> Hi!
>
> I have a one-to-many relationship between two tabl
Hi!
I have a one-to-many relationship between two tables
(table1 and table3) with a "linking" table between
them (table2):
table1: table2
+---++ +---++
|id | f_name | |id | emailID|
+---++ +---++
| 1 | bill | | 1 | 1|
| 2
