Received: from viemta04.chello.at (viemta04.chello.at [195.34.133.54]) by postgresql.org (8.11.3/8.11.1) with ESMTP id f4A0X3A91582 for ; Wed, 9 May 2001 20:33:04 -0400 (EDT) (envelope-from cm@chello.at) Received: from server ([212.17.110.55]) by viemta04.chello.at (InterMail vK.4.03.02.00 201-232-124 license 6aea1bd1f01aef5a9a73363c16ebee43) with ESMTP id <20010510003259.ISWN2375.viemta04@server> for ; Thu, 10 May 2001 02:32:59 +0200 From: "Christian Marschalek" To: "[PHP] PostgreSQL" Subject: Variable question... Date: Thu, 10 May 2001 02:34:24 +0200 Message-ID: <000501c0d8e8$f6ab2f00$0200a8c0@server> MIME-Version: 1.0 Content-Type: text/plain; charset="iso-8859-1" Content-Transfer-Encoding: 7bit X-Priority: 3 (Normal) X-MSMail-Priority: Normal X-Mailer: Microsoft Outlook, Build 10.0.2616 Importance: Normal X-MimeOLE: Produced By Microsoft MimeOLE V5.50.4133.2400 X-Archive-Number: 200105/49 X-Sequence-Number: 358 Can anyone please tell me why this does not work: $result = pg_exec($c1,"SELECT o_plz FROM ort_tabelle WHERE o_plz = $HTTP_SESSION_VARS['user_tabelleXu_o_plz']"); And I have to do the following instead? $plz = $HTTP_SESSION_VARS['user_tabelleXu_o_plz']; $result = query_trans($c1, "SELECT o_plz FROM ort_tabelle WHERE o_plz = $plz"); Tia again Chris