- 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 tables
(table1 and table3) with a linking table
- 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 tables
(table1 and table3) with a linking table
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
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 exactly what I