PHP/MySQL Left Join Question

[mduke]

CM: Finally getting back to this and maybe being in the middle of a bad flu
ain't helping, but I'm not getting the names to print and am wondering whether
I'm not using the right nomenclature in the table. My select statement (w/only
slight variation to yours) is:

$query_datetest = "SELECT DATE_FORMAT(alumni.last_modified, '%m/%d/%Y') as
lastDate, alumni.alumni_id, alumni.firstName, alumni.nickName, ...,
t1.lastName, t2.lastName, t3.lastName, t4.lastName FROM alumni LEFT OUTER JOIN
thesis_committee t1 ON alumni.committeeChair = t1.committee_id LEFT OUTER JOIN
thesis_committee t2 ON alumni.committee2 = t2.committee_id LEFT OUTER JOIN
thesis_committee t3 ON alumni.committee3 = t3.committee_id LEFT OUTER JOIN
thesis_committee t4 ON alumni.committee4 = t4.committee_id ORDER BY
alumni.lastName";

But I'm assuming that I need to modify how I invoke the printout from what I
have below:

<td><p><?php echo $row_datetest['thesisComm']; ?></p></td>
<td><p><?php echo $row_datetest['committee2']; ?></p></td>
<td><p><?php echo $row_datetest['committee3']; ?></p></td>
<td><p><?php echo $row_datetest['committee4']; ?></p></td>

No? I tried naming the <td> fields t1.lastName, etc., and as you likely would
know, that didn't work. I'm hoping there's an obvious oversight. Thanks for any
help you can provide.

[CMBergin]

You're almost there. You need to give each column with the same column name
an alias, as table names are no longer available when you've retrieved the
records.

SELECT ...snip..., t1.lastName AS Chairman, t2.lastName AS Member1,
t3.lastName AS Member2, t4.lastName AS Member3, ...snip...

Then, change your table to call the fields with those aliases:
<td><p><?php echo $row_datetest["Chairman"]; ?></p></td>
<td><p><?php echo $row_datetest["Member1"]; ?></p></td>
<td><p><?php echo $row_datetest["Member2"]; ?></p></td>
<td><p><?php echo $row_datetest["Member3"]; ?></p></td>

That's the final step. :)

"mduke" <webforumsuser@macromedia.com> wrote in message
news:cvo31u$ln0$1@forums.macromedia.com...

> CM: Finally getting back to this and maybe being in the middle of a bad

flu

> ain't helping, but I'm not getting the names to print and am wondering

whether

> I'm not using the right nomenclature in the table. My select statement

(w/only

> slight variation to yours) is:
>
> $query_datetest = "SELECT DATE_FORMAT(alumni.last_modified, '%m/%d/%Y')

as

> lastDate, alumni.alumni_id, alumni.firstName, alumni.nickName, ...,
> t1.lastName, t2.lastName, t3.lastName, t4.lastName FROM alumni LEFT OUTER

JOIN

> thesis_committee t1 ON alumni.committeeChair = t1.committee_id LEFT OUTER

JOIN

> thesis_committee t2 ON alumni.committee2 = t2.committee_id LEFT OUTER JOIN
> thesis_committee t3 ON alumni.committee3 = t3.committee_id LEFT OUTER JOIN
> thesis_committee t4 ON alumni.committee4 = t4.committee_id ORDER BY
> alumni.lastName";
>
> But I'm assuming that I need to modify how I invoke the printout from

what I

> have below:
>
> <td><p><?php echo $row_datetest['thesisComm']; ?></p></td>
> <td><p><?php echo $row_datetest['committee2']; ?></p></td>
> <td><p><?php echo $row_datetest['committee3']; ?></p></td>
> <td><p><?php echo $row_datetest['committee4']; ?></p></td>
>
> No? I tried naming the <td> fields t1.lastName, etc., and as you likely

would

> know, that didn't work. I'm hoping there's an obvious oversight. Thanks

for any

> help you can provide.
>

[mduke]

Hallelujah, that worked! Well, at least I was somewhat on the right track in
assuming I had to invoke the table output differently--just left out the other
"shoe" to that, obviously.

Thanks very much for your patience and assistance. Now I can leave work early
and try to recuperate from this rotten flu!

[CMBergin]

No problem. :)
Hope you feel better.

"mduke" <webforumsuser@macromedia.com> wrote in message
news:cvo7s8$s5n$1@forums.macromedia.com...

> Hallelujah, that worked! Well, at least I was somewhat on the right track

in

> assuming I had to invoke the table output differently--just left out the

other

> "shoe" to that, obviously.
>
> Thanks very much for your patience and assistance. Now I can leave work

early

> and try to recuperate from this rotten flu!
>