[RESOLVED] mysqli query into an associative array?

[s0me0ne]

I want mysqli to give me an associative array, but I dont know how unless I loop through it. Is there a way for it to give me the array without looping?

// open connection
$mysqli = new mysqli($host, $user, $pass, $db);

// check for connection errors
if (mysqli_connect_errno())
{
    die("Unable to connect!");
}

$query = 'SELECT id, name FROM categories';

if ($result = $mysqli->query($query))
{
    // see if any rows were returned
    if ($result->num_rows > 0)
	{
		$row = $result->fetch_array();//give me associative array without looping - DOESNT WORK
	}
}
else
	$row = array();

print_r($row);

[laserlight]

Is there a way for it to give me the array without looping?

Yes, if you are talking about the array that corresponds to a row in your result set. No, if you are talking about an array that corresponds to your entire result set.

[s0me0ne]

How do I make it an associative row by looping?

[laserlight]

How do I make it an associative row by looping?

Something like this:

$query = 'SELECT id, name FROM categories';

if ($result = $mysqli->query($query))
{
    while ($row = $result->fetch_assoc())
    {
        print_r($row);
    }
}

[s0me0ne]

I was wanting to make an associative array that would have all the fields together.

$query = 'SELECT id, name FROM categories';

if ($result = $mysqli->query($query))
{
while ($row = $result->fetch_assoc())
{
$categories = array($row['id'] => $row['name']);
}
}

print_r($categories);//this prints out all my categories as an associative array
//example 1=> 'cars', 30=>'trucks', 120=>'vans'

[laserlight]

In that case you would write something along these lines:

$query = 'SELECT id, name FROM categories';

if ($result = $mysqli->query($query))
{
    $categories = array();
    while ($row = $result->fetch_assoc())
    {
        $categories[$row['id']] = $row['name'];
    }

print_r($categories);
// ...
}
else
{
    // Handle SQL error.
}