Results 1 to 3 of 3
  1. #1
    Join Date
    Feb 2014

    Unanswered: Concatenating data?

    I am using php/mysql.
    I have a table called ‘entries’ with fields entryid, dateadded, entrytext. There can be any number of entries for any one day.
    I want to produce a report where I get all of the ‘entrytext’ entries concatenated for each day in a table rather than the date being repeated a number of times with a single entrytext against each row of the table.

    What's a good way to go about doing this?

    Many thanks

  2. #2
    Join Date
    Sep 2009
    San Sebastian, Spain
    Have a look at Group_concat function in MySQL. Here is an example of how it works
    Ronan Cashell
    Certified Oracle DBA/Certified MySQL Expert (DBA & Cluster DBA)
    Follow me on Twitter

  3. #3
    Join Date
    Feb 2014
    That works perfectly - very many thanks.

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts