Results 1 to 2 of 2

Thread: mysql query

  1. #1
    Join Date
    Aug 2012
    Posts
    1

    Unanswered: mysql query

    i had a following data in my table(tblreport)

    grpname testname

    LIPID PROFILE S.TRIGLYCERIDES
    LIPID PROFILE S.CHOLESTEROL

    S.PROTIENS S.ALBUMIN
    S.PROTIENS S.ALBUMIN

    here what i want is i have to display above data in the following format

    grpname testname

    LIPID PROFILE S.TRIGLYCERIDES
    S.CHOLESTEROL

    S.PROTIENS S.ALBUMIN
    S.ALBUMIN

    send query for that
    Last edited by esoftweb; 08-21-12 at 16:20.

  2. #2
    Join Date
    Apr 2002
    Location
    Toronto, Canada
    Posts
    20,002
    Quote Originally Posted by esoftweb View Post
    send query for that
    you forgot to say "please"

    the good news is, this type of cosmetic enhancement is ~not~ done with the mysql query, but rather, with your application program, which would be written in php, or perl, or whatever

    the bad news is, this type of cosmetic enhancement is done with your application program, which means you have to know how to write this type of program logic
    rudy.ca | @rudydotca
    Buy my SitePoint book: Simply SQL

Posting Permissions

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