Add values into array

Question

This code is reading from mysql db tables and should return few names. But each name is sent as separated string. I need it in one string. Here is code:

<?php
session_start();

function prList($REQUEST){

  include ('into_sql.php');
  mysql_select_db("db394771350", $conn);

  $usr = $REQUEST["usnm"];
  $fID = $REQUEST["friendID"];
  $sql = mysql_query("SELECT * FROM users WHERE username='$usr'");
  $a=mysql_fetch_array($sql);

  $uID = $a["id"];

  $res1 = mysql_query("SELECT * FROM friends WHERE friendID='$uID' AND accept='0'");
  while($b=mysql_fetch_array($res1)){
    $fuID = $b["userID"];

    $res2 = mysql_query("SELECT * FROM users WHERE id='$fuID'");

    while($c=mysql_fetch_array($res2)){

      $usrn = $c["username"];
      $array = array("$usrn");
      encode($array);
    }
  }
}
?>

This is output:

["rhys"]["alexroan"]["bobjosh"]["xc.j.gingex"]["tom"]

mgraph · Accepted Answer · 2012-02-01 12:23:32Z

2

$usrn = "";
while($c=mysql_fetch_array($res2)){

$usrn .= $c["username"];
}
echo $usrn;

answered Feb 1, 2012 at 12:23

mgraph

15.3k4 gold badges43 silver badges76 bronze badges

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

Comments

tim · Accepted Answer · 2012-02-01 12:24:21Z

0

How is the function encode defined? I would suggest replacing $array = array("$usrn"); by $array[] = $c["username"] and at the end just implode all entries into one string via `$string = implode($array)

answered Feb 1, 2012 at 12:24

tim

10.1k22 gold badges88 silver badges146 bronze badges

4 Comments

Jakub Zak Over a year ago

this is what it returns: "ArrayArrayArrayArrayArray"

Jakub Zak Over a year ago

any idea how to put space between each record?

tim Over a year ago

Yesh sure, simply use implode(' ', $array), nothing easier than that :) Why not upvoting my answer than? :)

Jakub Zak Over a year ago

would love to but my reputation is not above 15 so far so I can't. Sorry

Thierry Ybt · Accepted Answer · 2012-02-01 12:35:57Z

0

Why don't you just concatenate results ?

$result = "";
$i = false;
while ($c=mysql_fetch_array($res2)){
   if ($i)
      $result .= ' ';
   $result .= $c["username"];
   $i = true;
}

echo $result;

edited Feb 1, 2012 at 12:35

answered Feb 1, 2012 at 12:26

Thierry Ybt

1711 silver badge9 bronze badges

8 Comments

Jakub Zak Over a year ago

not working returning this: ["rhys"]["rhysalexroan"]["rhysalexroanbobjosh"]["rhysalexroanbobjoshxc.j.gingex"]["rhysalexroanbobjoshxc.j.gingextom"]

Thierry Ybt Over a year ago

The last string between brackets is the result you expect ? If it is, display the result at the exit of the loop not inside.

Jakub Zak Over a year ago

Thank you anyway solution from @Alexandrew solved my problem , but as I said thank you.

Thierry Ybt Over a year ago

no problem. For your spaces problem try this: implode(' ', $array) instead of implode($array)

Thierry Ybt Over a year ago

With a space between the quotes

|

Sam Arul Raj T · Accepted Answer · 2012-02-01 13:14:15Z

0

Check this out may be helpfule forl

FIND_IN_SET(str,strlist)

Returns a value in the range of 1 to N if the string str is in the string list strlist consisting of N substrings. A string list is a string composed of substrings separated by “,” characters. If the first argument is a constant string and the second is a column of type SET, the FIND_IN_SET() function is optimized to use bit arithmetic. Returns 0 if str is not in strlist or if strlist is the empty string. Returns NULL if either argument is NULL. This function does not work properly if the first argument contains a comma (“,”) character.

mysql> SELECT FIND_IN_SET('b','a,b,c,d'); -> 2

answered Feb 1, 2012 at 13:14

Sam Arul Raj T

1,77017 silver badges23 bronze badges

Collectives™ on Stack Overflow

Add values into array

4 Answers 4

Comments

4 Comments

8 Comments

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

4 Answers 4

Comments

4 Comments

8 Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Related