second loop wrong?

[Anon]

Hi,

Hi,

I had loop problem. I tried one day to figure out where it is problem, just simply not work. $count and $query does take all input list, but $row seemed only take last input no matter how many input it was. My main partial code like

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?

[[deleted]]

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

is not good.
change it to this:

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

and change this:
$result = safe_query ($query, $db);
if (isset($result)) {

to

$result = mysql_query($query, $db);
if (!$result)
{
echo mysql_error();
}
else
{

[Anon]

Thanks for your answering.

I applied your suggestion to replace my code, same problem like used to.

My query takes all input and my $count is exact number what I input. But after
$result = mysql_query($query, $db), $row is just last input's data retrieved.

Do you think
$txt = explode("\n", $list) is right?

When I use explode("[\n\s+\t]", $list), all input data is recongized as a item, not multiple items even though they are seperated by "\n"...

I really confuse where it is problem for the code.

Need helps...

[[deleted]]

explode sounds ok,
try printing the $list and use print_r($txt) to print the content of the $txt array.
See what exactl you are putting into the queryies.

[Anon]

Yes, I think explode OK too. I test couple of things like these:

Supposed that my input is X, Y, Z

print $list; (Result is X Y Z)
print_r($txt); (Result is Array ( [0] => X [1] => Y [2] =>Z )
print $count; (Result is 3)

print $query; (Results are

select aaa, bbb from table where aaa = "X"
select aaa, bbb from table where aaa = "Y"
select aaa, bbb from table where aaa = "Z" )

print $i; (Result is 0 1 2)

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

print $row["aaa"] (Result is just Z, the last input).

How could like these?

[Anon]

Also when I start to test

$result = mysql_query ($query, $db);
print_r($result);

$row=mysql_fetch_array($result);
print $row["aaa"];

Results like

Resource id #2Resource id #3Resource id #4Y

$result is Resource id...
$row["aaa"] only display Y

It seems that some problem occur at $row or $result;

[[deleted]]

Give me the full code again.

[Anon]

Here is code:

$txt = explode("\n", $list);

$count = count($txt);

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

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

$result = mysql_query($query, $db);
if (!$result)
{
echo mysql_error();
}
else
{
while ($row=mysql_fetch_array($result))
{
print $row["aaa"];
}
}
}

[[deleted]]

And you are sure that your database contains the data you are looking for?
what does a
SELECT * FROM table
give you?

[Anon]

Yes, I am sure that my database contain what the query ask. In fact, I get all data from database if I have one input. But I only can get last input's data if I have more than one input.

I really don't understand that.