Store Looped MySQL Array as String Variable

Question

I have a collection of results from a MySQL query being fetched in a loop. I need to store them as a single variable with a space in between each result.

$result = mysql_query("SELECT Names FROM table");
while($row = mysql_fetch_array($result)){
    echo $row['Names'] . " ";
}

So later, I can call 'echo $Names;' and get the string of names with a space in between.

ex) Clinton Bush Huckabee Romney etc....

Thanks for your help!

user1558223 · Accepted Answer · 2012-08-21 00:15:57Z

1

$Names = '';
$result = mysql_query("SELECT Names FROM table");
while($row = mysql_fetch_array($result)){
    $Names.= $row['Names'] . " ";
}

answered Aug 21, 2012 at 0:15

user1558223

1971 silver badge9 bronze badges

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

Comments

eldblz · Accepted Answer · 2012-08-21 00:15:23Z

1

$result = mysql_query("SELECT Names FROM table");

$names = "";

while($row = mysql_fetch_array($result)){
    $names .= $row['Names'] . " ";
}

echo $names;

answered Aug 21, 2012 at 0:15

eldblz

8283 gold badges12 silver badges25 bronze badges

Comments

mintobit · Accepted Answer · 2012-08-21 00:25:15Z

1

First of all, please, stop using mysql extention. It's deprecated. Try mysqli or PDO.

$names = array();
$result = mysql_query("SELECT Names FROM table");
while($row = mysql_fetch_array($result)){
    $names[] = $row['Names'];
}
echo implode(' ', $names);

edited Aug 21, 2012 at 0:25

answered Aug 21, 2012 at 0:18

mintobit

2,3932 gold badges15 silver badges15 bronze badges

Comments

inhan · Accepted Answer · 2012-08-21 00:17:55Z

0

I would use an array and then implode it using a space:

$result = mysql_query("SELECT Names FROM table");
$arr = array();
while($row = mysql_fetch_array($result)) $arr[] = $row['Names'];
echo implode(' ', $arr);

answered Aug 21, 2012 at 0:17

inhan

7,5002 gold badges26 silver badges35 bronze badges

Collectives™ on Stack Overflow

Store Looped MySQL Array as String Variable

4 Answers 4

Comments

Comments

Comments

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

4 Answers 4

Comments

Comments

Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Related