<div>
I just needed to change the GROUP BY to customer and it worked perfectly. &nbsp;Thanks
</div>


I just needed to change the GROUP BY to customer and it worked perfectly.  Thanks

<div>
Any MySQL book by Vikram Vaswani will give you a good foundation. &nbsp;I have an older one (MySQL 4) and it still covers almost everything I need to do!<br />
<a href="http://mysql-tcr.com/book/" rel="ugc">http://mysql-tcr.com/book/</a>
</div>


Any MySQL book by Vikram Vaswani will give you a good foundation.  I have an older one (MySQL 4) and it still covers almost everything I need to do!
http://mysql-tcr.com/book/ [http://mysql-tcr.com/book/]

<div>
<div class="content wysiwyg-content">
Hi All,<br />
<br />
I have the following MySQL table<br />
<br />

<pre><code id="code-10-28580394-1">ID    Customer     Contact
1     ABC Ltd         John Smith
2     ABC Ltd         Joe Bloggs
3     XYZ Ltd         Tom Jones
4     XYZ Ltd         Andy Murray</code></pre>
<br />
I need to get this into an new table as<br />
<br />

<pre><code id="code-10-28580394-2">ID    Customer     Contact
1     ABC Ltd         John Smith,Joe Bloggs
2     XYZ Ltd         Tom Jones,Andy Murray</code></pre>
<br />
<br />
Any suggestions?
</div>
</div>


Hi All,

I have the following MySQL table

(CODE)

I need to get this into an new table as

(CODE)


Any suggestions?

MySQL / PHP help

MySQL is an open source, relational database management system that runs as a server providing multi-user access to a number of databases. Acquired by Oracle in 2009, it is frequently used in combination with PHP installations, powering most of the WordPress installations.

MySQL Server

PHP is a widely-used server-side scripting language especially suited for web development, powering tens of millions of sites from Facebook to personal WordPress blogs. PHP is often paired with the MySQL relational database, but includes support for most other mainstream databases. By utilizing different Server APIs, PHP can work on many different web servers as a server-side scripting language.