I managed to figure out where I was going wrong (or at least I think I have. I was playing around with the syntax and decided to add a <BR> after the $Row[notes] and it displayed the records line by line. I don't know if this was the best way to do it but it worked.
Thanks Jess > -----Original Message----- > From: Hunter, Jess [SMTP:[EMAIL PROTECTED] > Sent: Sunday, December 14, 2003 11:34 AM > To: [EMAIL PROTECTED] > Subject: Help with "JOIN" and Record Display > > 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] > > --- > Incoming 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 > > --- 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]