MySQL Fill an Array String using Select

Question

I want to populate a string via MySQL, the string will be an Array.

$con = mysql_connect("localhost","username","#######");
mysql_select_db("mydatabase", $con);
$result = mysql_query("");

while($row = mysql_fetch_array($result)){
  $saleArrayList = array("");

}

I want my Array like

  // $saleArrayList = array("data1seperatecomma,data2seperateacomma,etc,etc");

This is my new code:

$salesArrayList = array();

while($row = mysql_fetch_array($result)){
  array_push($salesArrayList, $row[0]);
}
$string = implode(',', $salesArrayList);
echo $string;

Works well!!!

Nathan Q · Accepted Answer · 2011-11-24 12:19:54Z

2

Do you just want to fill an array? Then use array_push() to add items to your array

$con = mysql_connect("localhost","username","#######");
mysql_select_db("mydatabase", $con);
$result = mysql_query("");

$salesArrayList = array();

while($row = mysql_fetch_array($result)){
  array_push($salesArrayList, $row[0]);
}

If you want a string with comma delimiter based on an array you can use implode():

$string = implode(',', $salesArrayList);

answered Nov 24, 2011 at 12:19

Nathan Q

1,90220 silver badges43 bronze badges

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

1 Comment

TheBlackBenzKid Over a year ago

Thanks man. I updated my thread question at the top with the new code.

Collectives™ on Stack Overflow

MySQL Fill an Array String using Select

1 Answer 1

1 Comment

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

1 Comment

Your Answer

Sign up or log in

Post as a guest

Related