Sql results into php array

Question

I would like to create an array (in php) from sql results like this: We have the sql-table "Posts" which stores the Name and the Message.Example:

Name | Message

John | Hello

Nick | nice day

George | Good bye

John | where

What i want is to output the names of people who have posted a message but dont display the same names more than 1 time. So the output would be John,Nick,George. (From these records, we see that John has posted 2 messages, but at the final output, we see only one time his name).

Is this somehow possible? Thanks in advance.

are you using mysql_ functions, pdo, mysqli....?

Galen
– Galen

2009-11-28 16:28:32 +00:00
Commented Nov 28, 2009 at 16:28 — Galen
– Galen, Commented Nov 28, 2009 at 16:28

cletus · Accepted Answer · 2009-11-28 16:30:51Z

1

Try:

$sql = <<<END
SELECT DISTINCT Name FROM Posts
END;
$query = mysql_query($sql) or die($sql . ' - ' . mysql_error());
$names = array();
while ($row = mysql_fetch_array($query)) {
  $names[] = $row[0];
}
print_r($names);

answered Nov 28, 2009 at 16:30

cletus

627k169 gold badges922 silver badges945 bronze badges

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

Comments

PurplePilot · Accepted Answer · 2009-11-28 16:29:06Z

0

SELECT DISTINCT

answered Nov 28, 2009 at 16:29

PurplePilot

6,6227 gold badges38 silver badges42 bronze badges

Comments

Kaleb Brasee · Accepted Answer · 2009-11-28 16:29:25Z

0

You could run a SQL query to just select the distinct names, and nothing else:

SELECT DISTINCT Name FROM Posts;

This will give you a result set consisting of distinct Names values, with each unique value only being returned 1 time in the set.

answered Nov 28, 2009 at 16:29

Kaleb Brasee

52.1k9 gold badges113 silver badges114 bronze badges

4 Comments

Manolis Over a year ago

Thanks, In fact i already use a query to show the results, so i would like to use an array so to store the unique values (so dont to do a second array). ?

K Prime Over a year ago

You mean just extracting the unique values out of an existing array, eg array_unique (php.net/manual/en/function.array-unique.php)?

Kaleb Brasee Over a year ago

Yeah, if you only want to use the original query, you'll need to 1) create an array consisting of all the names in your original query (basically how Cletus demonstrated), then 2) use the array_unique function that K Prime posted to remove duplicates from that array.

Manolis Over a year ago

Yes,but could you explain it more? Look,the query is eg: $query = dquery('SELECT * FROM POSTS'); (the real table has more columns so thats why i write *) and then: foreach ($query as $res){ echo ''; etc.. } After this i want to display eg: echo 'People who posted:..'; how could i add them at the array,but only 1 time and to display directly the name? thanks!

Paul Creasey · Accepted Answer · 2009-11-28 16:33:16Z

0

to get the count you will need to aggregate using group by:

SELECT NAME , COUNT(*) as Posts FROM Posts GROUP BY NAME

answered Nov 28, 2009 at 16:33

Paul Creasey

28.9k10 gold badges59 silver badges91 bronze badges

Comments

rjha94 · Accepted Answer · 2012-02-11 15:25:14Z

0

Here is the SQL if you are not averse to group BY

select count(name) as N, name from posts group by name ;

People having more than 1 post

select count(name) as N, name from posts group by name having N > 1 ;

answered Feb 11, 2012 at 15:25

rjha94

4,3283 gold badges32 silver badges37 bronze badges

Collectives™ on Stack Overflow

Sql results into php array

5 Answers 5

Comments

Comments

4 Comments

Comments

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

5 Answers 5

Comments

Comments

4 Comments

Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Related