MySQL Row in one output

Question

Im pretty new to MySQl and PHP. I need some help with a small issue.

My statement is as follows:

while($row = $stmt->fetch()) {
  $return_arr[] =  $row['name'];
      $return_arr[] =  $row['value'];
}

It outputs as follows:

Mr James Jones
23

How can I bring it together into one line? Like this:

Mr James Jones 23

Thank you

@Fred-ii- Troll happens :) Edited: You have more votes on that comment than you could get on posting an answer :p — Rikesh
– Rikesh, Commented Jan 31, 2014 at 6:02
True, as do other things, but I won't write it on here. There may be youngsters watching. ;-) @Rikesh Edited: (Tip: It doesn't smell very good) — Funk Forty Niner
– Funk Forty Niner, Commented Jan 31, 2014 at 6:06
LOL, not bad eh? Yet, I never put in answers when I don't see more code. As I stated in Shankar's answer, the explanation is all in there. Questions like these usually tend to open up, what I call a "can of worms". @Rikesh I was going to put in the very same thing as Shankar, till he put in an answer, that's why I wrote that, at the very instant I was writing "Try" — Funk Forty Niner
– Funk Forty Niner, Commented Jan 31, 2014 at 6:07

vee · Accepted Answer · 2014-01-31 05:48:51Z

3

Use implode to join the array elements:

echo implode(' ', $return_arr);

answered Jan 31, 2014 at 5:48

vee

38.7k7 gold badges76 silver badges80 bronze badges

Sign up to request clarification or add additional context in comments.

Comments

Shankar Narayana Damodaran · Accepted Answer · 2014-01-31 06:02:08Z

3

Do like this

while($row = $stmt->fetch()) {
  $return_arr[] =  $row['name']." ".$row['value'];
}

//print_r($return_arr); // The results gets printed as you expected or you could make use of a foreach construct as shown below.

//Printing using a foreach construct
foreach($return_arr as $k=>$v)
{
 echo $v;echo "<br>";
}

edited Jan 31, 2014 at 6:02

answered Jan 31, 2014 at 5:48

Shankar Narayana Damodaran

68.6k43 gold badges102 silver badges129 bronze badges

11 Comments

Funk Forty Niner Over a year ago

I was going to put that in a comment actually hahahaha +1 ;-)

Shankar Narayana Damodaran Over a year ago

lol fred. Answers should not be given under comments box that is what the comments tip says :P

Funk Forty Niner Over a year ago

True, but I'm always afraid that it will open up a "can of worm" ;-) and many downvote because of duplicate answers. It's happened to me before :(

Funk Forty Niner Over a year ago

Editted comment above -^

Funk Forty Niner Over a year ago

More often than me then lol! Ok, will hop on there tomorrow evening then. Will tweet you. Take care and get yourself one of those fancy coffee cups with an anti-spill rim ;-) You'll thank me for it. ciao - Edit: Btw, I was "right".

|

vee · Accepted Answer · 2014-01-31 05:58:49Z

0

Just use like this,

while($row = $stmt->fetch()) {
  $return_arr[] =  $row['name']. ' '.$row['value'];
}

it will work. And if you want any other help let me know.

edited Jan 31, 2014 at 5:58

vee

38.7k7 gold badges76 silver badges80 bronze badges

answered Jan 31, 2014 at 5:51

Shivam

7303 gold badges10 silver badges25 bronze badges

Comments

Madcoe · Accepted Answer · 2014-01-31 06:01:49Z

0

An alternate way is handling it inside your mysql query:

SELECT CONCAT(name, ' ', value) as name_and_value FROM ....

Than you can use

$row['name_and_value']

in your php code.

answered Jan 31, 2014 at 6:01

Madcoe

2131 silver badge6 bronze badges

3 Comments

user2720970 Over a year ago

Thats great, working perfectly. Only question is how do I add and additional space or even text between the 2 outputs? Mr James Jones 23, to Mr James Jones "IS" 23

Madcoe Over a year ago

You can change blankspace between two fields to any character or string. Example SELECT CONCAT(name, 'add any string here', value) as name_and_value FROM ....

Madcoe Over a year ago

CONCAT means Concatenation. So php equvalent of this sql would be $name.' '.$value. You can also add any number of fields/strings inside concat like CONCAT(field1,' IS ',{$aphpvariable},' but ', field2, field3)

Collectives™ on Stack Overflow

MySQL Row in one output

4 Answers 4

Comments

11 Comments

Comments

3 Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

4 Answers 4

Comments

11 Comments

Comments

3 Comments

Your Answer

Sign up or log in

Post as a guest

Related