This being the first time I have tried to do a JOIN statement (and still not
yet fully understanding it). If someone could take a look at the below code
and see what I may be doing wrong.
I have the actual code working and it displays the information from
$TableName2.notes, however in this table there are three records that are
being displayed (which it should) however it displays them all together.
i.e.
<DISPLAYED>
This is the first record This is the second record This is the thirdrecord
</DISPLAYED>
What I am wanting it to do is:
<DISPLAYED>
This is the first record
This is the second record
This is the thirdrecord
</DISPLAYED>
Here is the code I am using
<SNIPPET>
$Link = mysql_connect($Host, $User, $Password);
$Query="SELECT * from $TableName1 LEFT JOIN $TableName2 ON ($TableName1.id =
$TableName2.id) WHERE $TableName1.id=1";
$Result= mysql_db_query ($DBName, $Query, $Link);
while ($Row = mysql_fetch_array ($Result)){
print ("$Row[notes]");
}
</SNIPPET>
I have even tried putting a line break (\n) in at the end of the $Row[notes]
to see if that would do anything which it did not.
Thanks in advance for any possible assistance
Jess
---
Outgoing mail is certified Virus Free.
Checked by AVG anti-virus system (http://www.grisoft.com).
Version: 6.0.550 / Virus Database: 342 - Release Date: 12/9/03
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
