RE: [PHP] discussion forum from j. meloni's book
| From: | Jennifer Goodie | Date: | Wed, 13 Aug 2003 02:09:44 +0000 |
| Subject: | RE: [PHP] discussion forum from j. meloni's book | ||
| References: | 1 | Groups: | php.general |
| Request: | Send a blank email to php-general+get-159382@lists.php.net to get a copy of this message | ||
>
> // the query
>
> $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]";
> ...........................
>
> My question: why - or how can - the columns ft.topic_id and ft.topic_title
> come from the table forum_posts?
>
> In the original schema, there is no column called topic_title in the table
> called forum_posts.
They don't. ft is aliased to forum_topics.