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]