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]
