-4

i have a query in mysql using concat :

query

ouput : output

i want the ouput is Lutron GL Ltd

what's wrong guys ?

Thanks

Wrikken
  • 69,272
  • 8
  • 97
  • 136
AFD
  • 1,341
  • 2
  • 9
  • 8
  • 1
    Bold formatting is part of the user interface (presentation), and has nothing to do with SQL. The user interface interprets that formatting, and we have no idea how you're presenting the data from your query. A `SELECT` returns the data; it's up to you to present it to the user. (So the answer is: Nothing is wrong with your query. You're asking the wrong question. It's like saying "I have words in my head. Why are they blue instead of red on the paper?" when we have no idea how they got from your brain to the page.) – Ken White Aug 01 '13 at 22:43
  • I would agree. i would use the database only to pull data and use a programming language like php or ruby to do all the formatting. – Luke101 Aug 01 '13 at 22:44
  • @all,thanks for your advice.in server side im using kohana helper select() for generated select form html ('supp_clsff_select')); ?> because the $clsf is array i cant modified to bold result company_name. – AFD Aug 01 '13 at 22:53
  • 2
    Your question is _"How can I style a ` – Wrikken Aug 01 '13 at 23:00

1 Answers1

0

you want style Lutron GL Ltd with mysql `?

remove tags from mysql and use them when you output the results like that

     echo "<option class='bold' value='....' >".$row['cn_clsf']."</option>" ;

Just use CSS to make it BOLD.

echo_Me
  • 37,078
  • 5
  • 58
  • 78