[RESOLVED] Fatal Error

jkarr

The following piece of code displays the same result over and over until I get the this error:

Fatal error: Maximum execution time of 60 seconds exceeded in /home/datamt/public_html/15517/mystudentsenrolled.php on line 25

<?
include 'db-customers.php';
$enrolled=mysql_query("SELECT * FROM 15517ClassHistory WHERE Completed='No'") or die(mysql_error());
while($row2=mysql_fetch_array($enrolled)){
$studentid = $row2['UserID'];
include 'db-login.php';
$student_get=mysql_query("SELECT * FROM Users WHERE UserID='$studentid' ORDER BY LastName asc");
while($row=mysql_fetch_array($student_get)){
$fname=$row['FirstName'];
$lname=$row['LastName'];
$name = $lname . ", " . $fname;
$user=$row['UserID'];
include 'db-customers.php';
$enrolled=mysql_query("SELECT * FROM 15517ClassHistory WHERE UserID='$user' AND Completed='No'") or die(mysql_error());
$numenrolled=mysql_num_rows($enrolled);
$completed=mysql_query("SELECT * FROM 15517ClassHistory WHERE UserID='$user' AND Completed='Yes'") or die(mysql_error());
$numcompleted=mysql_num_rows($completed);
?>
<tr>
<td align=left><? echo $name; ?></td>
<td><? echo $numenrolled; ?></td>
<td><? echo $numcompleted; ?></td>
</tr>
<?
} }
?>

line 25 is:

$numenrolled=mysql_num_rows($enrolled);

Does anyone know what I'm doing wrong?

Thanks,
Johnie Karr

rish1103

Edit the 'maximum_execution_time' in your php.ini file to a number greater than 60 seconds.
I would assume the cause is the query taking a while to finish. I hope that helps.

rish1103

oh and also you can change that in your php configuration file too if you continue to have the problem. that may help.

jkarr

but there is only 1 record in the database that matches the criteria and it displays that same result like a million times. There is something not allowing the script to stop the loop.

Thanks for the reply though.

rish1103

try something along the lines of this

$i=0;
while ($i < $numenrolled)
{
	echo $numenrolled;

$i++;
}

jkarr

rish,

the same code I use here is the same code I use on another page and it works correctly. Is that what's causing the loop in the code?

Thanks,

rish1103

jkarr wrote:
rish,

the same code I use here is the same code I use on another page and it works correctly. Is that what's causing the loop in the code?

Thanks,

that should not cause any problems because i assume the codes are independent. If its the exact same variables it could have reprocussions but i'm not totally positive on that although you could try to change the variable names within the two codes if they are the same.

the method i suggested just makes sure that when the values within $numenrolled are 0 meaning its empty with nothing more to print it exits the loop and stops printing that may help your problem. did you try that?

jkarr

i did not, but I will

rish1103

cool, let me know how it goes and if hte problem still persists i'll try to see what else i can come up with.

jkarr

After reading your reply I went back and looked at my code again.

The problem was duplicate variable names.

I changed the first $enrolled to $enrolled2 and that fixed it.

Thanks for pointing me in the right direction,

Johnie Karr

rish1103

sweet, glad i could be of help.