How to put result of MYSQL DISTINCT QUERY in a PHP VARIABLE? [duplicate]

Question

i've a problem trying to get multiple values and concatenate them inside a single php string variable.

The idea is to use a MYSQL DISTINCT STATEMENT on a single column of the table like this:

$sql = "select DISTINCT(COLUMN) from table where <multiple conditions>";
$result = mysqli_query($con, $sql);

while ($row = mysqli_fetch_array($result, MYSQLI_ASSOC)) {
$suppliers = $row['COLUMN'];
}

I'm sure there are 2 records in my database I want to obtain with two distinct values: 'PLENITUDE' and 'IREN' but i dont know how to concatenate them inside the variable like this:

'PLENITUDE-IREN'

And i'm not so expert .. it seems the query is OK but if I echo $suppliers the result is null.

I don't know what this has to do with concatenation. Do you want to concatenate the results? Something like GROUP_CONCAT()? — Dharman
– Dharman ♦, Commented Sep 23, 2023 at 9:47
Make sure you have PHP error reporting enabled on full. You should be getting a Warning due to the bug you have. If you do not see a warning, it means you have error reporting disabled. — Dharman
– Dharman ♦, Commented Sep 23, 2023 at 9:52
Hi, as I wrote I need to concatenate distinct values obtained in a single PHP variables. — Francesco Minniti
– Francesco Minniti, Commented Sep 23, 2023 at 9:54

Aysun Itai · Accepted Answer · 2023-09-23 09:58:16Z

1

$suppliers = '';
while ($row = mysqli_fetch_array($result, MYSQLI_ASSOC)) {
  if($suppliers !== '') $suppliers .= '-';
  $suppliers .= $row['COLUMN'];
}
echo $suppliers;

answered Sep 23, 2023 at 9:58

Aysun Itai

464 bronze badges

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

2 Comments

Francesco Minniti Over a year ago

Found the problem ! It works now. Great answer Aysun!

Aysun Itai Over a year ago

i am happy it worked

Collectives™ on Stack Overflow

How to put result of MYSQL DISTINCT QUERY in a PHP VARIABLE? [duplicate]

1 Answer 1

2 Comments

Linked

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

2 Comments

Linked

Related