Fwd: Apache crashes when using WHILE loop to t...

Also, please see messages I have copied from the Apache error log:

[Sun Jul 06 09:38:30 2008] [notice] Parent: child process exited with status 3221225477 -- Restarting.
[Sun Jul 06 09:38:30 2008] [notice] Apache/2.2.6 (Win32) PHP/5.2.4 configured -- resuming normal operations
[Sun Jul 06 09:38:30 2008] [notice] Server built: Sep 5 2007 08:58:56
[Sun Jul 06 09:38:30 2008] [notice] Parent: Created child process 4372
[Sun Jul 06 09:38:31 2008] [notice] Child 4372: Child process is running
[Sun Jul 06 09:38:31 2008] [notice] Child 4372: Acquired the start mutex.
[Sun Jul 06 09:38:31 2008] [notice] Child 4372: Starting 250 worker threads.
[Sun Jul 06 09:38:31 2008] [notice] Child 4372: Starting thread to listen on port 80.

Any help would be much apprecieted.

Thanks,

Bonger

---------- Forwarded message ----------
From: Bonger O <bongero@gmail.com>
Date: Sat, Jul 5, 2008 at 6:55 PM
Subject: Apache crashes when using WHILE loop to traverse SQL query results
To: users@httpd.apache.org

Hi,

I have set up an environment on my Vista laptop comprising of Apache 2.2, MySQL Server 5.1 and Php 5.2.5.

I'm using a simple php program that I found in a PHP/SQL book. The PHP program queries a MySQL table and uses a WHILE loop to traverse the results array of the query and display on screen. However, there seems to be a problem with my environment and using a WHILE loop as every time I run the program I get the error "Apache HTTP server stopped working and was closed".

I have no problems using a FOR loop but every time I use a WHILE loop Apache seems to crash. Please see below for the code I have used.

I would be extremely for any suggestions of why this is happening and any solutions offered.

Thanks.

<?php
/* Program: petDisplay.php
* Desc:    Displays all pets in selected category.
*/
?>
<html>
<head><title>Pet Catalog</title></head>
<body>
<?php

$user="root";
$host="localhost";
$password="PASSWORD";
$database = "am";
$cxn = mysqli_connect($host,$user,$password,$database)
         or die ("couldn't connect to server");
$pettype = "horse"; //horse was typed in a form by user
$query = "SELECT * FROM Pet WHERE petType='$pettype'";
$result = mysqli_query($cxn,$query)
            or die ("Couldn't execute query.");

/*Display results in a table */
$pettype = ucfirst($pettype)."s";

echo "<h1>$pettype</h1>";
echo "<table cellspacing='15'>";
echo "<tr><td colspan='3'><hr /></td></tr>";
while($row = mysqli_fetch_assoc($result))
{
     extract($row);

     $f_price = number_format($price,2);
     echo "<tr>\n
            <td>$petName</td>\n
            <td>$petDescription</td>\n
            <td style='text-align: right'>\$$f_price</td>\n
           </tr>\n";
     echo "<tr><td colspan='3'><hr /></td></tr>\n";
}
echo "</table>\n";
?>
</body></html>

[users@httpd] Fwd: Apache crashes when using WHILE loop to traverse SQL query results

Bonger O

2008-07-06