From angelo.rigo@globo.com Tue Dec 10 12:30:08 2002 Received: from localhost (postgresql.org [64.49.215.8]) by postgresql.org (Postfix) with ESMTP id CBC83475E2B for ; Tue, 10 Dec 2002 07:30:08 -0500 (EST) Received: from nplex.globo.com (email.globo.com [200.208.9.53]) by postgresql.org (Postfix) with ESMTP id 2B974475D93 for ; Tue, 10 Dec 2002 07:30:08 -0500 (EST) Received: from [200.219.69.252] by nplex.globo.com with HTTP; Tue, 10 Dec 2002 10:29:38 -0200 Date: Tue, 10 Dec 2002 09:29:38 -0300 Message-ID: <3DCBFE22000E6871@riosf06.globoi.com> From: angelo.rigo@globo.com Subject: forms /selects To: pgsql-php@postgresql.org MIME-Version: 1.0 Content-Type: text/plain; charset="ISO-8859-15" Content-Transfer-Encoding: quoted-printable X-Virus-Scanned: by AMaViS new-20020517 X-Archive-Number: 200212/22 X-Sequence-Number: 1697 Hi all I am trying to do a select from a table after the user has choosen the first letter of the name and it must display only the names with that letter sele= cted in a select box. The message i get is if i select a for example is: "the atribute 'a' not found" I would like some help to know what?s going wrong! Thank?s in advance =C2ngelo Rigo Here is my code: Search names by the first letter
">

"); printf ("Name"); do { $myrow =3D pg_fetch_array ($result,$row); if($row % 2) { $bgcolor=3D"#FFFF99"; } else { $bgcolor=3D""; } printf ("%s",$myrow[nome]); $row++; } while ($row < $numrows); printf (""); pg_close($db); ?> ________________________________________ A busca mais veloz e precisa da internet. Acesse agora: http://www.zoom.com= .br. From jco@cornelius-olsen.dk Tue Dec 10 14:04:11 2002 Received: from localhost (postgresql.org [64.49.215.8]) by postgresql.org (Postfix) with ESMTP id 3B78C475EBD for ; Tue, 10 Dec 2002 09:04:11 -0500 (EST) Received: from cornelius-olsen.dk (0x50c4f773.arcnxx7.adsl-dhcp.tele.dk [80.196.247.115]) by postgresql.org (Postfix) with ESMTP id C2DB6475E6F for ; Tue, 10 Dec 2002 09:04:07 -0500 (EST) To: pgsql-php@postgresql.org Subject: Re: forms /selects MIME-Version: 1.0 X-Mailer: Lotus Notes Release 5.0.9 November 16, 2001 Message-ID: From: jco@cornelius-olsen.dk Date: Tue, 10 Dec 2002 15:03:33 +0100 X-MIMETrack: Serialize by Router on sonic/cgroup(Release 5.0.11 |July 24, 2002) at 12/10/2002 03:03:36 PM, Serialize complete at 12/10/2002 03:03:36 PM Content-Type: multipart/alternative; boundary="=_alternative 004D482BC1256C8B_=" X-Virus-Scanned: by AMaViS new-20020517 X-Archive-Number: 200212/24 X-Sequence-Number: 1699 This is a multipart message in MIME format. --=_alternative 004D482BC1256C8B_= Content-Type: text/plain; charset="iso-8859-1" Content-Transfer-Encoding: quoted-printable I see a couple of errors, one of which is the source of your problem. You write: "SELECT name FROM thetable WHERE (nome=3D$leter%) ORDER BY nome ASC= "; This would evaluate to "SELECT name FROM thetable WHERE (nome=3DA%) ORDER BY nome ASC"; What you need to write is: "SELECT name FROM thetable WHERE (nome like '$leter%') ORDER BY nom= e ASC"; "like" is required to make regular expression match. The quotes are always required when dealing with strings (and a few other= =20 types). You could have just debugged this by echo $query; Also: Letter contains two t's. :) Regards /J=F8rn Cornelius Olsen --=_alternative 004D482BC1256C8B_= Content-Type: text/html; charset="iso-8859-1" Content-Transfer-Encoding: quoted-printable
I see a couple of errors, one of whi= ch is the source of your problem.
You write:
        <= font size=3D2 face=3D"Courier New">"SELECT name FROM thetable WHERE (n= ome=3D$leter%) ORDER BY nome ASC";
This would evaluate to
        "S= ELECT name FROM thetable WHERE (nome=3DA%) ORDER BY nome ASC";

What you need to write is:
        "S= ELECT name FROM thetable WHERE (nome like '$leter%') ORDER BY nome ASC"= ;;

"like" is required to mak= e regular expression match.
The quotes are always required when= dealing with strings (and a few other types).

You could have just debugged this b= y
        echo $q= uery;

Also: Letter contains two t's. :)

Regards
/J=F8rn Cornelius Olsen --=_alternative 004D482BC1256C8B_=-- From angelo.rigo@globo.com Tue Dec 10 16:53:09 2002 Received: from localhost (postgresql.org [64.49.215.8]) by postgresql.org (Postfix) with ESMTP id 1FC264760F5 for ; Tue, 10 Dec 2002 11:53:09 -0500 (EST) Received: from nplex.globo.com (email.globo.com [200.208.9.53]) by postgresql.org (Postfix) with ESMTP id 888C44760DB for ; Tue, 10 Dec 2002 11:53:08 -0500 (EST) Received: from [200.219.69.252] by nplex.globo.com with HTTP; Tue, 10 Dec 2002 14:52:45 -0200 Date: Tue, 10 Dec 2002 13:52:45 -0300 Message-ID: <3DCBFE22000E94C8@riosf06.globoi.com> In-Reply-To: From: angelo.rigo@globo.com Subject: Re: forms /selects To: pgsql-php@postgresql.org MIME-Version: 1.0 Content-Type: text/plain; charset="ISO-8859-15" Content-Transfer-Encoding: quoted-printable X-Virus-Scanned: by AMaViS new-20020517 X-Archive-Number: 200212/26 X-Sequence-Number: 1701 Hi I see my error was not using the "like" but now i fall in other problem: I have made an if else to display a message if have no name with the selected leter as initial it works but disply too: Warning: Unable to jump to row 0 on PostgreSQL result index 2 in /var/www/h= tml/inscricao/resultado_a1.php on line 80 how could i handle this? Thank?s in advance: here is my actual code: Pesquisa de nome por letra inicial
">

<"); } else $row=3D0; printf (""); printf (""); do { $myrow =3D pg_fetch_array ($result,$row); if($row % 2) { $bgcolor=3D"#FFFF99"; } else { $bgcolor=3D""; } printf ("",$myrow[nome]); $row++; } while ($row < $numrows); printf ("
Nome
%s
"); pg_close($db); ?> '>'-- Mensagem Original -- '>'To: pgsql-php@postgresql.org '>'Subject: Re: [PHP] forms /selects '>'From: jco@cornelius-olsen.dk '>'Date: Tue, 10 Dec 2002 15:03:33 +0100 '>' '>' '>'I see a couple of errors, one of which is the source of your problem. '>'You write: '>' "SELECT name FROM thetable WHERE (nome=3D$leter%) ORDER BY nome ASC"; '>'This would evaluate to '>' "SELECT name FROM thetable WHERE (nome=3DA%) ORDER BY nome ASC"; '>' '>'What you need to write is: '>' "SELECT name FROM thetable WHERE (nome like '$leter%') ORDER BY nome '>'ASC"; '>' '>'"like" is required to make regular expression match. '>'The quotes are always required when dealing with strings (and a few other '>' '>'types). '>' '>'You could have just debugged this by '>' echo $query; '>' '>'Also: Letter contains two t's. :) '>' '>'Regards '>'/J=F8rn Cornelius Olsen ________________________________________ A busca mais veloz e precisa da internet. Acesse agora: http://www.zoom.com= .br.