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 selected
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
Ângelo Rigo
Here is my code:
Search names by the first letter
">
");
printf ("
",$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.
Re: forms /selects
От:
jco@cornelius-olsen.dk
Дата:
I see a couple of errors, one of which is the source of your problem. You write: "SELECT name FROM thetable WHERE (nome=$leter%) ORDER BY nome ASC"; This would evaluate to "SELECT name FROM thetable WHERE (nome=A%) 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ørn Cornelius Olsen
Re: forms /selects
От:
angelo.rigo@globo.com
Дата:
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/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
">
<");
}
else
$row=0;
printf ("
",$myrow[nome]);
$row++;
}
while ($row < $numrows);
printf ("
");
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=$leter%) ORDER BY nome
ASC";
'>'This would evaluate to
'>' "SELECT name FROM thetable WHERE (nome=A%) 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ørn Cornelius Olsen
________________________________________
A busca mais veloz e precisa da internet. Acesse agora: http://www.zoom.com.br.
Re: forms /selects solution
От:
angelo.rigo@globo.com
Дата:
Here is the final working code:
">
<");
}
else{
$row=0;
printf ("
",$myrow[name]);
$row++;
}
while ($row < $numrows);
printf ("
");
}//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/www/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 = pg_connect("dbname=db user=user");
'>'$query ="SELECT name FROM aprovados WHERE (nome like '$leter%') ORDER
BY
'>'name ASC ";
'>'$result = pg_exec($db, $query);
'>'
'>'if (!$result) {printf ("Não há nomes com esta letra inicial!"); exit;}
'>'$numrows = pg_numrows($result);
'>'
'>'
'>'/***********************
'>' actual problem
'>'***********************/
'>'
'>'if ($numrows=='0') {
'>' print("Não foram encontrados nomes iniciados por : $letra");
'>' print("<");
'>'}
'>'else
'>'
'>'$row=0;
'>'printf ("
");
'>'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=$leter%) ORDER BY
nome
'>'ASC";
'>' '>'This would evaluate to
'>' '>' "SELECT name FROM thetable WHERE (nome=A%) 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ørn 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.