Divide multidimensional array into many arrays

[dmhall0]

I have a MySQL query that pulls multiple columns with many rows.  I want to break each column into its own array.

Here is what I have to this point but doesn't seem to be working.  Is this the right direction or is there something easier?

Thanks!

 

$query = "SELECT name, address, city, state FROM customers WHERE sku = '12345'";
$result = mysqli_query($dbc, $query) or die();

$name = array();
$address = array();
$city = array();
state = array();

while ($data = mysqli_fetch_assoc($result)) {
  $name = $data['name'];
  $address = $data['address'];
  $city = $data['city'];
  $state = $data['state'];
} 

[Muddy_Funster]

neerly there:

$query = "SELECT name, address, city, state FROM customers WHERE sku = '12345'";
$result = mysqli_query($dbc, $query) or die();

$name = array();
$address = array();
$city = array();
state = array();

while ($data = mysqli_fetch_assoc($result)) {
  $name[] = $data['name'];
  $address[] = $data['address'];
  $city[] = $data['city'];
  $state[] = $data['state'];
} 

[AyKay47]

The only thing you are missing is the correct syntax for pushing values onto an array using the [] operator.

 

$name[] = $data['name'];

 

Also, it's a good idea to instead have die(mysqli_error()); to be able to properly debug the query upon failure.

 

Edit: muddy beat me to it.

[dmhall0]

Devil in the details!

Thanks guys!