Thanks for the reply Chris. The query does work when I type it into the mysql console. But it wouldn't be a size issue because the table I am querying is tiny. There is only four records in it. This happens for any query that I enter whenever I use the mysqli_fetch_assoc() function. Thanks again! On 7/10/08, Chris <dmagick@xxxxxxxxx> wrote: > > Bonger O wrote: > > 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 traverses the results array of the > query > > and should display on screen. However, there seems to be a problem with > my > > environment and as every time I run the program I get the error "*Apache > > HTTP server stopped working and was closed*". > > > > Below is the code I am using, but 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 really have no clue!!! > > If the function doesn't exist php gives that error, not a random crash. > > Does the query work outside of php (type it in to the mysql console > directly) ? > > Does it happen for a particular record? ie it gets up to record #5 > before it crashes. What's in record #5? > > How many records are returned by the query? Maybe you're selecting too > much data and the srever is killing it because it's taking too much > memory (random guess :P). > > Do you have another environment you can try it in? > What happens there when you: > - use the same database > - use a different database > > -- > Postgresql & php tutorials > http://www.designmagick.com/ >
