Received: from localhost.localdomain (postgresql.org [64.49.215.8]) by localhost (Postfix) with ESMTP id 7D78447609F for ; Mon, 17 Jun 2002 15:01:58 -0400 (EDT) Received: from nplex.globo.com (email.globo.com [200.208.9.53]) by postgresql.org (Postfix) with ESMTP id 18DF3476296 for ; Mon, 17 Jun 2002 14:25:31 -0400 (EDT) Received: by nplex.globo.com (5.1.061) id 3D0539770002E26F for pgsql-php@postgresql.org; Mon, 17 Jun 2002 15:26:51 -0300 Message-ID: <3D05397800021FCD@nplex.globo.com> Date: Mon, 17 Jun 2002 15:26:50 -0300 From: angelo.rigo@globo.com Subject: results from a opinion form To: pgsql-php@postgresql.org MIME-Version: 1.0 Content-Type: text/plain; charset="ISO-8859-1" Content-Transfer-Encoding: quoted-printable X-Archive-Number: 200206/28 X-Sequence-Number: 1281 Hi I am working on a web form for, where i have 12 fields asking to enumerate to 5 to 1 to avaliate the weigth that feature have to people choose my comp= any. I have choosed the data type to be a smallint on postgresql and a input type text on html (php). And still i have 5 fields to indicate wich media the people have contact and helps or not wich i decide to be char on postgresql and input type chec= kbox on php where true is 1. How can i count take statistics and print in a php page from this form i try the following: SELECT count(metodo) FROM pesquisa where serie=3D 'a' || 'A' having '5'" thios give me the error; Warning: PostgreSQL query failed: ERROR: WHERE clause must return type bool, not type unknown in /var/www/html/pesquisa/mnivela_teste.php on line 21 ERROR =20 ________________________________________ A busca mais veloz e precisa da internet. Acesse agora: http://www.zoom.com= .br.