PHP Returns no results

Anon

Hi all

I use PHP to gather data from a MySQL database and present then on the Web. The problem is that on specific datasets the PHP does nothing and the returned HTML page conatins only the part of the file before
the PHP code which is plain HTML as if the PHP code was never executed.

How can i determine what goes wrong ?
please help.

Anon

view the source that is produced and you will likely see the error.

Anon

Is it possible that PHP cannot haddle very big tables ???
more than 50.000 rows?
Could this be the reason ?
Can this problem make PHP return no results at all.???

Anon

PHP should handle large amounts of rows pretty well. I've done 40 rows without a trouble, and I'm reasonably sure PHP can handle far more than that.

One thing to do is rather than the "<?" opening tag, use "<?php". Some PHP installations are set to be strict about what tags are allowed.

Another thing is echo out information every few lines in your code. So something like:

// Some code.
echo "One ";
// Some more code.
echo "Two ";

etc.

That way you can know more or less exactly where the page died, which is usually half the battle.

Also, ensure all your php tags are closed off with a "?>" or your equivalent.

Anon

When I said 40 rows, I meant to say "columns".

Many thousands of rows are just fine, but when using SELECT you should use LIMIT with it.

Otherwise MySQL chokes on occasion with huge amounts of data to return (multiple thousand rows), and your server connection could also time out.

Anon

The strange think about my problem is this :

Assume i put an echo "Starting ..."
at the very befining of my php code. The first command!!!.

The follow all the rest. It is very likely that the problem is the large amount
of rows php tries to handle. If the rows are few it works fine. If they are too many, i get nothing , not even the "Starting ...". Could someone explain it to me ? The problem is that in this way i cannot debug the process .....

Thanx in advance

Lambis Douvletis