How to separate an array

[eluser]danmontgomery[/eluser]

Code:

$row = $query->row_array();

http://ellislab.com/codeigniter/user-gui...sults.html

This function returns a single result row. If your query has more than one row, it returns only the first row.

[eluser]JayArias[/eluser]
Array
(
[tags] => business, masters, music, sound, grey
)

@CroNiX

[eluser]JayArias[/eluser]
result->array();

[eluser]JayArias[/eluser]
bump

[eluser]CroNiX[/eluser]
Its like noctrum tried to point out to you. You are using

Code:

$row = $query->row_array();

which is doing exactly what it says...only getting the ROW.
Look how you did it in your first post...why you changed it I don't know.

[eluser]JayArias[/eluser]
Yeah, I understand that but if I use

Code:

$query->result();

It errors out.

[eluser]CroNiX[/eluser]
Yes, because $query->result() returns an object, not an array.

Use $query->result_array(); like you did in your FIRST post

[eluser]JayArias[/eluser]
I did but then it gives me a huuuuuuuugeee error.

Code:

A PHP Error was encountered

Severity: Warning

Message: explode() expects parameter 2 to be string, array given

Filename: models/catalog_model.php

Line Number: 39

A PHP Error was encountered

Severity: Warning

Message: Invalid argument supplied for foreach()

Filename: models/catalog_model.php

Line Number: 40

A PHP Error was encountered

Severity: Warning

Message: explode() expects parameter 2 to be string, array given

Filename: models/catalog_model.php

Line Number: 39

A PHP Error was encountered

Severity: Warning

Message: Invalid argument supplied for foreach()

Filename: models/catalog_model.php

Line Number: 40

A PHP Error was encountered

Severity: Warning

Message: explode() expects parameter 2 to be string, array given

Filename: models/catalog_model.php

Line Number: 39

A PHP Error was encountered

Severity: Warning

Message: Invalid argument supplied for foreach()

Filename: models/catalog_model.php

Line Number: 40

A PHP Error was encountered

Severity: Warning

Message: explode() expects parameter 2 to be string, array given

Filename: models/catalog_model.php

Line Number: 39

A PHP Error was encountered

Severity: Warning

Message: Invalid argument supplied for foreach()

Filename: models/catalog_model.php

Line Number: 40

A PHP Error was encountered

Severity: Warning

Message: explode() expects parameter 2 to be string, array given

Filename: models/catalog_model.php

Line Number: 39

A PHP Error was encountered

Severity: Warning

Message: Invalid argument supplied for foreach()

Filename: models/catalog_model.php

Line Number: 40

A PHP Error was encountered

Severity: Warning

Message: explode() expects parameter 2 to be string, array given

Filename: models/catalog_model.php

Line Number: 39

A PHP Error was encountered

Severity: Warning

Message: Invalid argument supplied for foreach()

Filename: models/catalog_model.php

Line Number: 40

A PHP Error was encountered

Severity: Warning

Message: explode() expects parameter 2 to be string, array given

Filename: models/catalog_model.php

Line Number: 39

A PHP Error was encountered

Severity: Warning

Message: Invalid argument supplied for foreach()

Filename: models/catalog_model.php

Line Number: 40

A PHP Error was encountered

Severity: Warning

Message: explode() expects parameter 2 to be string, array given

Filename: models/catalog_model.php

Line Number: 39

A PHP Error was encountered

Severity: Warning

Message: Invalid argument supplied for foreach()

Filename: models/catalog_model.php

Line Number: 40

A PHP Error was encountered

Severity: Warning

Message: explode() expects parameter 2 to be string, array given

Filename: models/catalog_model.php

Line Number: 39

A PHP Error was encountered

Severity: Warning

Message: Invalid argument supplied for foreach()

Filename: models/catalog_model.php

Line Number: 40

A PHP Error was encountered

Severity: Warning

Message: explode() expects parameter 2 to be string, array given

Filename: models/catalog_model.php

Line Number: 39

A PHP Error was encountered

Severity: Warning

Message: Invalid argument supplied for foreach()

Filename: models/catalog_model.php

Line Number: 40

A PHP Error was encountered

Severity: Warning

Message: explode() expects parameter 2 to be string, array given

Filename: models/catalog_model.php

Line Number: 39

A PHP Error was encountered

Severity: Warning

Message: Invalid argument supplied for foreach()

Filename: models/catalog_model.php

Line Number: 40

[eluser]kainadolf[/eluser]
That's nice explanation. I faced the same problem but from your stuff I have easily solve that problem. Another thing is that I can easily make another one coding for the parallel array. I am thankful to your valuable stuff.

[eluser]JayArias[/eluser]
I'm still stuck on parsing this output.

Code:

$this->db->select('tags');
        $this->db->where('aprooved', 'yes');
        $this->db->limit(50);
            $query = $this->db->get('catalog');
            $row = $query->result_array();
            
        print_r($row);

output

Code:

Array ( [0] => Array ( [tags] => business, masters, music, sound, grey ) [1] => Array ( [tags] => green, toro, bull, mens ) [2] => Array ( [tags] => ) [3] => Array ( [tags] => ) [4] => Array ( [tags] => ) [5] => Array ( [tags] => ) [6] => Array ( [tags] => ) [7] => Array ( [tags] => ) [8] => Array ( [tags] => exclimation, person, awesomeness, girl, white, black ) [9] => Array ( [tags] => fishie, grey, blue, tank, tank-top ) [10] => Array ( [tags] => flamingo, love, red, tank-top, tanktop, white, drip ) )