String Problem!

[BenPWheeler]

Ok, im baffeled!
For example:
$count = 0;
while ($row = mysql_fetch_array($result))
{
$user[$count] = $row["User"];
echo($user[$count]);
echo("<BR>");
$count ++;
}
This prints out the user id 1111 <BR> 1112 <BR> 1113 which is as expected and what i want!

for($countB = 0; $countB < $sizeOfAnalysedClosed; $countB ++)
{
echo("$user[$countB]<BR>");
echo $user[$countB];
$subject = $user[$countB];
echo("<BR>SELECT * FROM $tableName WHERE User = '$subject' ORDER BY QNo");;
echo("<BR>");
...

This prints out 1111 the first time through the loop and the 1 <BR> 1

So why isnt the string complete??? Why does it get shortened????

[suntra]

What is $sizeOfAnalysedClosed ? Where does it come from ?

[BenPWheeler]

its the size of the array of users which is currently 3

[suntra]

Why don't you simply do that :

$user[$count] = $row["User"];
-- can be replaced with --
$user[] = $row["User"];

-- and --

for($countB = 0; $countB < $sizeOfAnalysedClosed; $countB ++)
-- can be replaced with --
for($countB = 0; $countB < count($users); $countB ++)

Explanations :

$array[] = "value" : [] means "add"... so you don't have to calculate the dimension... it is automatic.

count($array) : count the number of items in an array.

[BenPWheeler]

I know i could improve the code, but whats puzzling me is that when i echo in the while loop the contents of $users[0] is 1111, $users[1] is 1112 and $users[3] is 1113.

When in the for loop and i query the db, the contents of $users[0] is 1111, $users[1] is 1 and $users[3] is 1.

Why is it truncated?

[suntra]

Is there any code between the two parts of code you posted ?