Loop input.

[IwnfuM]

hi , i have build an search engine .

i don't know really how to output the results.

i have done something like this .

 

$qry = mysql_fetch_assoc(mysql_query("SELECT `search2`FROM `search` WHERE `search1`='%".$search."%' "));
echo $qry['search2'];

 

but it output only 1 result , i wanna know to to output all the results he find.

thanks , Mor.

 

[coupe-r]

Do this:

 

$result = mysql_query("SELECT search2 FROM search`WHERE search1 = '%".$search."%' ");

$row = mysql_fetch_array($result);

 

echo $row['search2'];

[Psycho]

$query = "SELECT `search2`FROM `search` WHERE `search1`='%{$search}%'";
$result = mysql_query($query);
while($row = mysql_fetch_assoc($result))
{
    //Include code to output results for each record
}

[coupe-r]

Yes, what he said.  I forgot you wanted multiple rows.

[rwwd]

You need to loop through the results if you know that there is going to be more than one result. Ie:-

 

//I find it handy to build the sql outside the function, this makes debugging easier!
$searchTerms = "SELECT `search2`FROM `search` WHERE `search1`='%".$search."%' ";
$sqlSearch = mysql_query($searchTerms);

//start loop here
while($qry = mysql_fetch_assoc($sqlSearch)){

//you could do this as a method of debugging also:-
//echo "<pre>";
//print_r($qry);
//echo "</pre>";

//print the results to screen
echo $qry['search2']."<br>";

}
//close the loop

 

Hope that helps a little anyway,

 

Cheers,

Rw

 

I wish I could type faster on some days!! What they said anyway!!

[IwnfuM]

mjdamato ,

you write it like that : '%{$search}%'

and I wrote it like that : '%".$search."%'

is there a difference ?

and you'r code will print all the results that have founded?

how can i know how many have been found ?

thanks , Mor.

[Psycho]

mjdamato ,

you write it like that : '%{$search}%'

and I wrote it like that : '%".$search."%'

is there a difference ?

No difference. I don't like the look of code that concatenates variables how you had it. Besides, when using double quotes, the PHP parser will interpret variables in the string. If you are going to exit out of the string to concatenate a variable, why use double quotes. You can just put the variable inside the double quotes, but enclosing them in curly braces helps alleviate certain problems - such as using arrays.

 

and you'r code will print all the results that have founded?

how can i know how many have been found ?

 

The code I posted create a loop where YOU can insert the code for displaying the results. I don't know how you want to display them so I left it out. But, here is one example where each result is displayed on a separate line. I also added code to display the number of records returned.

$query = "SELECT `search2`FROM `search` WHERE `search1`='%{$search}%'";
$result = mysql_query($query);
if(mysql_num_rows($result)==0)
{
    echo "There were no results.";
}
else
{
    echo "There were " . mysql_num_rows($result) . " records found:<br />\n";
    while($row = mysql_fetch_assoc($result))
    {
        echo " - {$qry['search2']}<br />\n";;
    }
}

[IwnfuM]

helped me lot !

thanks , Mor.