payts bei niwork na. yehey thanks. :P On 5/18/07, Arthur Gapusan <[EMAIL PROTECTED]> wrote:
try daw ni wahoho... SELECT GROUP_CONCAT(lastName SEPARATOR ' ') FROM tablename; On 5/18/07, Richard Badlisan < [EMAIL PROTECTED]> wrote: > > bale kung simple query lang is inani lugar ang result: > > +-----------+----------------+ > | client_id | client_name | > +-----------+----------------+ > | 1 | bill gates | > | 2 | linus torvalds | > +-----------+----------------+ > > tapos gusto dayon nimo i-in-ani ang result?: > > +--------------+----------------+ > | client_name1 | client_name2 | > +--------------+----------------+ > | bill gates |linus torvalds | > +--------------+----------------+ > > para sa akoa bai.. murag gamit jud ka ug PHP ana then isulod nimo sa > loop.. > > ambot lang anang concat sa sql, aside sa fields which is possible (e.gfield1 + field2), i dunno kung sa rows. diha na siguro jud ka mugamit ug > PHP... pero i dunno.. basin naa jud.. tsada ni nga pangutana.. > > 2007/5/18, Jason Yap <[EMAIL PROTECTED]>: > > > > uu inana pero ang gusto nako kay i concat nya ang mga result sa usa ka > > query. > > > > On 5/18/07, Arthur Gapusan <[EMAIL PROTECTED] > wrote: > > > > > > Yap..pwede man ka mag concat sa sql mismo.. > > > > > > SELECT concat(field1, field2, field3) FROM tablename; > > > > > > pwede jpn nimo sagulan ug lain string.. > > > > > > SELECT concat(familyName, " ", firstName) FROM tablename; > > > > > > ingon ana ba imo pasabot? > > > > > > On 5/18/07, Jason Yap < [EMAIL PROTECTED]> wrote: > > > > > > > > sa console ko sa mysql ga buhat. ang ako lang, gusto nako na tanan > > > > retreiving of data buhaton ra sa mysql. as much as possible, ang gusto lang > > > > nako buhaton sa php is i-present ra ang data. wala nay mga data > > > > manipulation(concatenation,etc...) mahitabo sa php. sa mysql ra sya tanan. > > > > pero kung dili jud ni possible, sa php jud ko padulong ani. hehe > > > > > > > > On 5/18/07, Richard Badlisan < [EMAIL PROTECTED]> wrote: > > > > > > > > > > dako jud na nga question mark para sa akoa pre.. > > > > > naa lang pud koy pangutana.. kung wala ka sa shell, unsaon nimo > > > > > pag execute sa query mismo? diba dependent man pud ang sql sa language na > > > > > imo gamiton like php, asp? aha diay nimo na siya ipadagan? kay kung sa > > > > > browser lang.. la ko idea kung puede na w/out using php... LAMP gud kunuhay > > > > > na sila.. IMO lang nuon. > > > > > > > > > > maghulat pud ko sa mga tubag sa uban about ani kay murag > > > > > interesado ko ani nga pangutana pud.. > > > > > > > > > > *ga-atang sa kilid* > > > > > > > > > > 2007/5/18, Jason Yap < [EMAIL PROTECTED]>: > > > > > > > > > > > > Hi guys. Naa ko pangutana about sql query > > > > > > > > > > > > ang gusto nako mahitabo kay unsaon pagbutang sa isa ka row ang > > > > > > multiple results sa usa ka query without using php. > > > > > > > > > > > > example: > > > > > > > > > > > > kung sa normal query, ang results would be: a,b,c,d,e where > > > > > > each result is a row. > > > > > > > > > > > > ang gusto nako mahitabo kay query gihapon, same result, > > > > > > a,b,c,d,e, but in one row nlang. > > > > > > > > > > > > > > > > > > Is this possible in mysql without using php? > > > > > > > > > > > > Any help will be appreciated. Thanks :) > > > > > > > > > > > > -- > > > > > > "Just being alive is such a lovely and wonderful thing." > > > > > > _________________________________________________ > > > > > > Kagay-Anon Linux Users' Group (KLUG) Mailing List > > > > > > [email protected] (http://cdo.linux.org.ph) > > > > > > Searchable Archives: http://archives.free.net.ph > > > > > > > > > > > > > > > > > > > > > > > > > > -- > > > > > » http://www.syntacticsinc.com/ > > > > > » http://g0ma.blogspot.com/ > > > > > » [EMAIL PROTECTED] > > > > > » 呵呵呵......不告訴你! ♥ + ♦ ⇒ ♫ > > > > > _________________________________________________ > > > > > Kagay-Anon Linux Users' Group (KLUG) Mailing List > > > > > [email protected] (http://cdo.linux.org.ph) > > > > > Searchable Archives: http://archives.free.net.ph > > > > > > > > > > > > > > > > > > > > > -- > > > > "Just being alive is such a lovely and wonderful thing." > > > > > > > > _________________________________________________ > > > > Kagay-Anon Linux Users' Group (KLUG) Mailing List > > > > [email protected] (http://cdo.linux.org.ph) > > > > Searchable Archives: http://archives.free.net.ph > > > > > > > > > > > > > _________________________________________________ > > > Kagay-Anon Linux Users' Group (KLUG) Mailing List > > > [email protected] (http://cdo.linux.org.ph) > > > Searchable Archives: http://archives.free.net.ph > > > > > > > > > > > -- > > "Just being alive is such a lovely and wonderful thing." > > > > _________________________________________________ > > Kagay-Anon Linux Users' Group (KLUG) Mailing List > > [email protected] (http://cdo.linux.org.ph) > > Searchable Archives: http://archives.free.net.ph > > > > > > -- > » http://www.syntacticsinc.com/ > » http://g0ma.blogspot.com/ > » [EMAIL PROTECTED] > » 呵呵呵......不告訴你! ♥ + ♦ ⇒ ♫ > > _________________________________________________ > Kagay-Anon Linux Users' Group (KLUG) Mailing List > [email protected] (http://cdo.linux.org.ph) > Searchable Archives: http://archives.free.net.ph > _________________________________________________ Kagay-Anon Linux Users' Group (KLUG) Mailing List [email protected] (http://cdo.linux.org.ph) Searchable Archives: http://archives.free.net.ph
-- "Just being alive is such a lovely and wonderful thing."
_________________________________________________ Kagay-Anon Linux Users' Group (KLUG) Mailing List [email protected] (http://cdo.linux.org.ph) Searchable Archives: http://archives.free.net.ph
