Re: discussion forum from j. meloni's book
| From: | Anthony Ritter | Date: | Wed, 13 Aug 2003 02:30:30 +0000 |
| Subject: | Re: discussion forum from j. meloni's book | ||
| References: | 1 | Groups: | php.general |
| Request: | Send a blank email to php-general+get-159383@lists.php.net to get a copy of this message | ||
Jennifer Goodie" <goodie@apollointeractive.com> writes:
They don't. ft is aliased to forum_topics.
........................
That's right.
ft is aliased to the forum_topics table.
The query reads:
...........
$verify = "select ft.topic_id, ft.topic_title from forum_posts as fp left
join forum_topics as ft on fp.topic_id = ft.topic_id where fp.post_id =
$_GET[post_id]";
.............
The question:
How can the column that is called:
ft.topic_title
in the select statement above
be taken from the table called forum_posts when it was not there in the
schema?
"SELECT ft.topic_id, ft.topic_title FROM forum_posts...[snipped]
Thank you.
TR
---
[This E-mail scanned for viruses by gonefishingguideservice.com]