help with php + mysql

Anon

I need the search result display a specific record. it is displaying all results containing any number..

example: i have records number in the table called 100-01 and 100-02.. if i put 100-01, it returns the two records.. but i need the 100-01 only.

this is a part of the code

if ($numero == "")
{$numero = '%';}

$result = mysql_query (" SELECT * FROM agrociencia WHERE numero LIKE '$numero'");

if ($row = mysql_fetch_array($result)) {

do {

Anon

try where numero = '$numero' instead of like.

Anon

it returns ...there is no results for this search..but the numero exists in the columm

Anon

I'm not a PHP guru but i'm not sure what this statment is supposed to do?
{$numero = '%';}
How do you know what record it is that you want returned is the value being returned from a form?

And try your sql statment like this:
SELECT * FROM agrociencia WHERE numero = 100-01'

and see how many values you get returned.

Anon

People will receive a number by e-mail. This is the protocol number of an article submited to editorial. They will go to the web and know about the situation of their article, searching by this number. the search must return only the exact record in the database.. and not others.

Anon

oh man..! what a simple mistake!
I forgot to change the name to "numero" in the input text tag.. !! 🙂 now its working
thanks everybody!