X-Original-To: pgsql-php-postgresql.org@localhost.postgresql.org Received: from localhost (unknown [200.46.204.2]) by svr1.postgresql.org (Postfix) with ESMTP id 8303BD1B9EB for ; Sat, 10 Apr 2004 07:22:30 -0300 (ADT) Received: from svr1.postgresql.org ([200.46.204.71]) by localhost (neptune.hub.org [200.46.204.2]) (amavisd-new, port 10024) with ESMTP id 52803-08 for ; Sat, 10 Apr 2004 07:22:31 -0300 (ADT) Received: from hotmail.com (bay14-f26.bay14.hotmail.com [64.4.49.26]) by svr1.postgresql.org (Postfix) with ESMTP id 17382D1B8E4 for ; Sat, 10 Apr 2004 07:22:28 -0300 (ADT) Received: from mail pickup service by hotmail.com with Microsoft SMTPSVC; Sat, 10 Apr 2004 03:22:30 -0700 Received: from 195.92.67.65 by by14fd.bay14.hotmail.msn.com with HTTP; Sat, 10 Apr 2004 10:22:29 GMT X-Originating-IP: [195.92.67.65] X-Originating-Email: [yazkedoo@hotmail.com] X-Sender: yazkedoo@hotmail.com From: "Yasmine Kedoo" To: pgsql-php@postgresql.org Subject: Relating Tables - Search & Display Date: Sat, 10 Apr 2004 10:22:29 +0000 Mime-Version: 1.0 Content-Type: text/plain; format=flowed Message-ID: X-OriginalArrivalTime: 10 Apr 2004 10:22:30.0232 (UTC) FILETIME=[BABA1D80:01C41EE5] X-Virus-Scanned: by amavisd-new at postgresql.org X-Archive-Number: 200404/19 X-Sequence-Number: 2676 Hi there. I'd like to thank everyone who helped me with my previous problem, now I have a fresh one! I want to search for data using PHP from 2 different tables, though these tables are linked by an addressID, created using CHAR. The problem, is relating the tables, then being able to run a query to retrieve the data. Currently, I am running 2 queries to serach. I tried to use INHERITS, but it did not work. Does anybody have any ideas? Also, does anybody know how to display the result obtained from pg_fetch_object(), i am using this as part of the search? Thanx Again :-) _________________________________________________________________ Express yourself with cool new emoticons http://www.msn.co.uk/specials/myemo