Get array of rows with mysqli result?

It means the block following wasn't executed in a loop. Get rid of that and it should work Also, you may want to check that the query actually works: $sql = new mysqli($config'host', $config'user', $config'pass', $config'db_name'); if (mysqli_connect_errno()) { printf("Connect failed: %s\n", mysqli_connect_error()); exit; } $query = "SELECT domain FROM services"; $result = $sql->query($query); if (!$result) { printf("Query failed: %s\n", $mysqli->error); exit; } while($row = $result->fetch_row()) { $rows=$row; } $result->close(); $sql->close(); return $rows.

You had a slight syntax problem, namely an errant semi-colon. While($row = $result->fetch_row()); Notice the semi-colon at the end? It means the block following wasn't executed in a loop.

Get rid of that and it should work. Also, you may want to check that the query actually works: $sql = new mysqli($config'host', $config'user', $config'pass', $config'db_name'); if (mysqli_connect_errno()) { printf("Connect failed: %s\n", mysqli_connect_error()); exit; } $query = "SELECT domain FROM services"; $result = $sql->query($query); if (!$result) { printf("Query failed: %s\n", $mysqli->error); exit; } while($row = $result->fetch_row()) { $rows=$row; } $result->close(); $sql->close(); return $rows.

Oh... how embarrassing I shouldn't work that late (it's 2:30 am here:) THANKS cletus this worked out :) – Yaniv Oct 1 '09 at 0:45.

I had to declare $rows = array(); before the loop.

I cant really gove you an answer,but what I can give you is a way to a solution, that is you have to find the anglde that you relate to or peaks your interest. A good paper is one that people get drawn into because it reaches them ln some way.As for me WW11 to me, I think of the holocaust and the effect it had on the survivors, their families and those who stood by and did nothing until it was too late.

Related Questions