[[SOLVED] apache crashes when php runs MySQLi_Result->fetch_array(MYSQLI_ASSOC) or ...]

I'm a new to php and web development.

I can't seem to figure out why my app crashes when calls to certain methods of the mysqli are made.

 

 

MySQLi_Result->fetch_object or MySQLi_Result->fetch_assoc. Both these fail and apache crashes.

 

but both MySQLi_Result->fetch_row() and MySQLi_Result->fetch_array(MYSQLI_NUM) works fine .

 

here is my code..

$query = 'Select * from user_accounts where user_name = '."'".$_SESSION["username"]."'";

 

//echo $query;

$results = $conn->query($query);

if (!$results) {

throw new Exception('Could not execute query');

}

$row = $results->fetch_array(MYSQLI_ASSOC); <- fails here

 

 

any ideas? I searched, and there was someone else who had a similiar problem. They apparently downgraded, rebooted and their problem was solved. I haven't downgraded, but I have rebooted.

 

php 5.2.9

mysql 5.1.30