loop not success

[phui_99]

Hello,

I am building a search engine, also be able to do batch search. When I printed out my query, I know that my query take all batch input, but I dont know why my final result didn't print out all, in fact, only display last input's data.

Have anyone had insight?

[saltwater]

could you give a bit more explanation? I don't quite follow..

[Anon]

you're using a loop ...

and finally:

in fact, only display last input's data.

perhaps you overwrite the result in each pass of the loop - instead of appending the actual data.

e.g.:
$result = $thisdata;
instad of:
$result .= $thisdata;

[Anon]

Hi,

Html's textarea's name is "list". More than one subject will be pasted there.

echo "<table>";
$txt = explode("\n", $list);

$count = count($txt);
for ($i=0; $i<$count; $i++) {

$query = "select aaa, bbb from table where aaa = '$txt[$i]';

$result = safe_query ($query, $db);
if (isset($result)) {
while ($row = mysql_fetch_array($result))
{
echo("<tr><td>" .$row["aaa"]. "</td><td>" .$row["bbb"]. "</td></tr>");
}
}
echo "</table>";

So I thought that might be caused by mysql_fetch_array, so I tried to use mysql_fetch_row, same problems.

Only last subject's data was displayed even though my query took all subjects from textarea.

Have any ideas where I am doing wrong?