php-windows Digest 21 May 2005 06:02:03 -0000 Issue 2676
Topics (messages 26040 through 26041):
Re: Database Problem
26040 by: graeme
Re: Help with windows 2003 iis6, exec() and permissions
26041 by: Leo G. Divinagracia III
Administrivia:
To subscribe to the digest, e-mail:
[EMAIL PROTECTED]
To unsubscribe from the digest, e-mail:
[EMAIL PROTECTED]
To post to the list, e-mail:
[email protected]
----------------------------------------------------------------------
--- Begin Message ---
In short, there isn't a restriction to the number of iterations.
So I suspect it's something to do with you code.
Can I make the following suggestions
1) assign the SQL statement into a variable $SQL, for example. Print
that out before your call to mysql_query()
echo $SQL . "<br>";
$result = mysql_query($SQL,$connection);
2) Check on the result returned from MySQL.
try the last successful and the first failed query through the command
line. You might learn something, at least I hope you do!
all the best,
graeme.
John wrote:
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);
...
....
}
--
Experience is a good teacher, but she sends in terrific bills.
Minna Antrim
--- End Message ---
--- Begin Message ---
Jean-Philippe Palha wrote:
Hi,
Put a copy of cmd.exe on your PHP dir and give it the good permissions...
dont forget to rename it... mess with crackers some more...
if you check your logs, you'll see a bunch of script kiddies running the
same cracking scripts over and over, and one of them is trying to run
CMD.EXE... well at least for my apache install...
--
Leo G. Divinagracia III
[EMAIL PROTECTED]
--- End Message ---