I have code that querys a mysql server and then presents the result in a
table.
The code works fine until I put it in a for loop to get one row at a time.
The problem is that I dont get the required result or any error message.
If I reduce the number of iterations or decrease the amount of data
requested per iteration then it works. But otherwise nothing.
Is there some maximum number of characters or something similar. It is only
a small select query that returns a char and about 15 ints. It works with 2
iterations all the time. Works with 3 very, very rarely and works with four
or more never.
Sample lines below.
for($i = 0; $i < 3; ++$i)
{
...
...
...
$result = mysql_query ("SELECT Name, EventTimes1Score,EventTimes2Score,
EventTimes3Score, EventTimes4Score, EventTimes5Score,EventAdd1Score,
EventAdd2Score, EventAdd3Score, EventAdd4Score, EventAdd5Score,
EventTake1Score, EventTake2Score, EventTake3Score, EventTake4Score,
EventTake5Score from leaguetest LIMIT $i,1", $connection);
...
....
}
--
PHP Windows Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php
