Received: from localhost (postgresql.org [64.49.215.8]) by postgresql.org (Postfix) with ESMTP id ED55B475EF7 for ; Tue, 10 Dec 2002 12:19:27 -0500 (EST) Received: from nplex.globo.com (email.globo.com [200.208.9.53]) by postgresql.org (Postfix) with ESMTP id 2AC77475D87 for ; Tue, 10 Dec 2002 12:19:27 -0500 (EST) Received: from [200.219.69.252] by nplex.globo.com with HTTP; Tue, 10 Dec 2002 15:19:10 -0200 Date: Tue, 10 Dec 2002 14:19:10 -0300 Message-ID: <3DCBFE22000E98C7@riosf06.globoi.com> In-Reply-To: <3DCBFE22000E94C8@riosf06.globoi.com> From: angelo.rigo@globo.com Subject: Re: forms /selects solution 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/27 X-Sequence-Number: 1702 Here is the final working code:
">

<"); } else{ $row=3D0; printf (""); printf (""); do { $myrow =3D pg_fetch_array ($result,$row); if($row % 2) { $bgcolor=3D"#FFFF99"; } else { $bgcolor=3D""; } printf ("",$myrow[name]); $row++; } while ($row < $numrows); printf ("
Nome
%s
"); }//else pg_close($db); ?> '>'-- Mensagem Original -- '>'Date: Tue, 10 Dec 2002 13:52:45 -0300 '>'From: angelo.rigo@globo.com '>'Subject: Re: [PHP] forms /selects '>'To: pgsql-php@postgresql.org '>' '>' '>'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/w= ww/html/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 '>'
'>'
'>' '>'
'>' '$db =3D pg_connect("dbname=3Ddb user=3Duser"); '>'$query =3D"SELECT name FROM aprovados WHERE (nome like '$leter%') ORDER BY '>'name ASC "; '>'$result =3D pg_exec($db, $query); '>' '>'if (!$result) {printf ("N=E3o h=E1 nomes com esta letra inicial!"); exi= t;} '>'$numrows =3D pg_numrows($result); '>' '>' '>'/*********************** '>' actual problem '>'***********************/ '>' '>'if ($numrows=3D=3D'0') { '>' print("N=E3o foram encontrados nomes iniciados por : $letra"); '>' print("<"); '>'} '>'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 proble= m. '>' '>'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. '>' '>' '>' '>'---------------------------(end of broadcast)--------------------------- '>'TIP 6: Have you searched our list archives? '>' '>'http://archives.postgresql.org ________________________________________ A busca mais veloz e precisa da internet. Acesse agora: http://www.zoom.com= .br.