details in one Row without any redundancy in the CATID

Posted by alkitbi on Stack Overflow See other posts from Stack Overflow or by alkitbi
Published on 2010-06-06T18:02:46Z Indexed on 2010/06/06 18:42 UTC
Read the original article Hit count: 266

Filed under:
|
|
|
$query1 = "select * 
             from linkat_link 
            where emailuser = '$email2' 
               or linkname ='$domain_name2' 
         ORDER BY date desc 
            LIMIT $From,$PageNO";

id   catid      discription            price
------------------------------------
1         1     domain name     100
2         1      book                  50
3        2      hosting               20
4        2      myservice           20

in this script i have one problem , if i have an ID for Each Cantegory , i have some duplicated CATID which has different content but shares the same CATID, i need to make any duplicated CATID to show in one , and all the discription will be in the same line (Cell) on the same row . So Each CatID will have all the details in one Row without any redundancy in the CATID

© Stack Overflow or respective owner

Related posts about php

Related posts about mysql