Re: [EMAIL PROTECTED] Apache crashes when using WHILE loop to traverse SQL query results

2008-07-08 Thread Bonger O
Thanks for the advice guys. I'll go pester some PHP folks! On Tue, Jul 8, 2008 at 12:26 PM, Norman Peelman <[EMAIL PROTECTED]> wrote: > Bonger O wrote: > >> Hi guys, >> Thanks for getting back to me on this with your comments, but sadly I've >> still had no luck. >> I have managed to narrow t

Re: [EMAIL PROTECTED] Apache crashes when using WHILE loop to traverse SQL query results

2008-07-08 Thread Norman Peelman
Bonger O wrote: Hi guys, Thanks for getting back to me on this with your comments, but sadly I've still had no luck. I have managed to narrow the problem down to *$row = mysqli_fetch_assoc($result);* For some reason this is causing the crash. Would there be any reason that this function ca

Re: [EMAIL PROTECTED] Apache crashes when using WHILE loop to traverse SQL query results

2008-07-07 Thread Rich Schumacher
Note: This is turning more into a PHP issue than Apache... You must have the MySQLi extension already installed, otherwise it would complain about mysqli_connect() being an invalid function. Do you have command line access? If so, try running the script above from the command line to see if that

Re: [EMAIL PROTECTED] Apache crashes when using WHILE loop to traverse SQL query results

2008-07-07 Thread Bonger O
Hi guys, Thanks for getting back to me on this with your comments, but sadly I've still had no luck. I have managed to narrow the problem down to *$row = mysqli_fetch_assoc($result);* For some reason this is causing the crash. Would there be any reason that this function cant be found perhaps? I

Re: [EMAIL PROTECTED] Apache crashes when using WHILE loop to traverse SQL query results

2008-07-07 Thread Rich Schumacher
Bonger, Are you using Apache with the Worker MPM? If so, that could be your problem. It is fairly well documented and highly discussed that the Worker MPM on *nix is not a good combination, as explained here: http://us2.php.net/manual/en/faq.installation.php#faq.installation.apache2. The problem

Re: [EMAIL PROTECTED] Apache crashes when using WHILE loop to traverse SQL query results

2008-07-06 Thread Bradley Giesbrecht
With php when you include vars in double quotes don't you want to put curly braces around them like so? $query = "SELECT * FROM Pet WHERE petType='{$pettype}'"; That's how I do it but I've been doing it so long I don't remember why. Anyway, I would guess this is a php issue and not an apache

[EMAIL PROTECTED] Apache crashes when using WHILE loop to traverse SQL query results

2008-07-05 Thread Bonger O
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