ops. that is if you are dealing with more than one table...
On 5/18/07, Ryan Luyao <[EMAIL PROTECTED]> wrote:
I have long been a non-mysql user but if there are JOINS in mysql you can use it. naa ba? didnt bother to google it myself. On 5/18/07, Jason Yap <[EMAIL PROTECTED]> wrote: > > payts pud kung naa pang array derecho. hehe > > On 5/18/07, Richard Badlisan < [EMAIL PROTECTED]> wrote: > > > > mao ni ako gisulayan > > > > mysql> SELECT GROUP_CONCAT(client_name SEPARATOR '|') as myfield FROM > > clients; > > > > in-ani dayon iya result > > > > +-------------------------------+ > > | myfield | > > +-------------------------------+ > > | bill gates | linus torvalds | > > +-------------------------------+ > > > > naa jud diay.. i concat niya ang results as usa ka row tapos iyang > > separator kay any string > > power.. naa diay ana nga klase na concatenation... karon pa ko > > kabalo.. thanks arthur! > > pero iya return ani kay STRING lang.. so imong reference na lang dayon > > pagbulag is kanang character/string na gigamit nimo as SEPARATOR.. > > > > puede pud kaha na mu-return siya ug array() without using PHP? > > bale murag in-ani? > > > > myfield[0] -> "bill gates"; myfield[1] -> "linus torvalds"? > > > > > > 2007/5/18, Arthur Gapusan <[EMAIL PROTECTED]>: > > > > > > 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.g field1 + 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 > > > > > > > > > > > -- > > » 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 > -- Ryan Luyao Linux User #374225 http://counter.li.org -= Apache Inside =-
-- Ryan Luyao Linux User #374225 http://counter.li.org -= Apache Inside =-
_________________________________________________ Kagay-Anon Linux Users' Group (KLUG) Mailing List [email protected] (http://cdo.linux.org.ph) Searchable Archives: http://archives.free.net.ph
