Jump to content

Divide multidimensional array into many arrays


dmhall0

Recommended Posts

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'];
} 

Link to comment
Share on other sites

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'];
} 

Link to comment
Share on other sites

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.

Link to comment
Share on other sites

This thread is more than a year old. Please don't revive it unless you have something important to add.

Join the conversation

You can post now and register later. If you have an account, sign in now to post with your account.

Guest
Reply to this topic...

×   Pasted as rich text.   Restore formatting

  Only 75 emoji are allowed.

×   Your link has been automatically embedded.   Display as a link instead

×   Your previous content has been restored.   Clear editor

×   You cannot paste images directly. Upload or insert images from URL.

×
×
  • Create New...

Important Information

We have placed cookies on your device to help make this website better. You can adjust your cookie settings, otherwise we'll assume you're okay to continue.