pretty weird problem

[Anon]

Hi,

has anyone seen this before?

start php code
// ......
$aantal = mysql_numrows($mydebs);
if($aantal == 0){
// do nothing
echo "NO DEBS <BR>";
}else{
// OH MY GOD! It's the funky @!#$!
$file = "";
for($u = 0;$u < $aantal; $u++){
if($u > 0){
$file .= "\n";
}
$regel = "";
for($y = 0;$y < sizeof($van);$y++){
$regel .= mysql_result(blah);
}
$bewerkt[] = mysql_result(blah);
$file .= $regel;
// BOOKMARK #1
}
// end of funky @!#$!
// BOOKMARK #2
}

When I echo $regel or $file at bookmark #1, I get a lot of text in the browser, and the script runs until it has shown everything.

When I echo $file outside the for it echo's nothing. Even a sizeof($bewerkt) doesn't show a zero, it just shows nothing!

Even worse: when I echo "i"; at bookmark 2, it doesn't do anything. Time-out is impossible, cause I've added a set_time_limit(0); like I always do with scripts that do big batch-conversions and stuff.

Can it be an memory problem or something?

Thanx!

[Anon]

With limit 10 in the query (small piece of information at a time) Nothing's wrong. Looks like to many characters in $file.

New problem:
I made $file an array -> same problem.

Is there a maximum on the number of elements in an array or something?

[[deleted]]

When I echo $regel or $file at bookmark #1, I get a lot of text in the browser,
and the script runs until it has shown everything.

Sounds ok.

When I echo $file outside the for it echo's nothing. Even a sizeof($bewerkt)
doesn't show a zero, it just shows nothing!

Error checking could help here.
When an echo returns nothing, it's usally becuase it's trying to echo a FALSE.
Instead if this:
$regel .= mysql_result(blah);

do this:
if (!$regel .= mysql_result(blah))
{
echo 'SQL ERROR: '.mysql_error();
};

That will tell you when the mysql command fails, and why.

Even worse: when I echo "i"; at bookmark 2, it doesn't do anything.

Are you sure it doesn't echo it? Is it possible that it is hidden between some HTML code that prevents you from seeing it?

[Anon]

I found some weird @!#$ inside the database. After removing it, it works perfectly!

[Anon]

even worse: I had all errors being inserted into a table, but stupid me does a rollback after inserting...

[[deleted]]

Loverly... :-)