mysql 存一个变量,将mysql数据库中的多行存储到一个变量中

this is really hard for me, i'm trying to store multiple rows from my table in mysql into a single variable

$mysql_statementJc = "SELECT * FROM `dog`.`cat` WHERE `name` = '$name'";

$mysql_commandJc = mysql_query($mysql_statementJc);

while($row = mysql_fetch_array($mysql_commandJc)){

$followI = $row['industry'];

$groupConcat = $followI . " OR ";

echo $groupConcat;

}

This is my appproach, so at the end of it all i can get "sam, john, bob" saved as $groupConcat which can then be used elsewhere.

Many thanks.

解决方案

Each time through the loop, add the desired value to an array. Then, after the loop, use the implode() function to create your desired output.

while($row = mysql_fetch_array($mysql_commandJc)){

$followI = $row['industry'];

$resultArray[] = $followI;

}

$groupConcat = implode(" OR ", $resultArray);

echo $groupConcat;

Note that you should really stop using the mysql library and instead use mysqli or PDO.