Webkpop-web.com      Main Menu · Home · Free Downloads · Computing FAQ · Contact Us · Free Software Downloads · Tech Forum · Technology News · Web Design Help · Web Links · Your Online Account · Your PM      Web Browser      Website Links White Papers IT Learn Korean Chinese Pop Music Advertise Kpop Korean Pop Site Map Web Design Pop Music Chinese Girls HK Pop Korean Music Lee Hyori Hyori Boa Park Ji Yoon Baby Vox YG Family Jeon Ji Hyun 1 Tym Ha Ji Won Shyne Rain Bi Shin Mina SM Town Fly to the Sky Korean Girls and Models Nicholas Tse 161 Clan 보아 Edison Chen Sung Hi Lee Shinhwa Andy Lau Jay Chou White Papers Case Study SES Kelly Chen Liu Yi Fei Sammi Cheng Jordan Chan Music Computer Jobs IT  Forum FAQ   Search   Usergroups   Profile   Log in  Selecting Data from MySql Db          Computer Help Forum and Programming Advice Forum Index -> Php View previous topic :: View next topic   Author Message mogoo Web Design Newbie Joined: Jan 24, 2006 Posts: 10 Posted: Sat Feb 11, 2006 9:56 pm    Post subject: Selecting Data from MySql Db Hi, I'm trying to make this script SELECT Title,Source FROM ng_main. Then preg_replace $row['Title']['Source']) Now, it only works with SELECT Title FROM ng_main. Then preg_replace $row['Title'] Code: Code: if($_GET[ftype] == 'web') {    $words = file("words.dat"); } else {    $words = array();        $res = mysql_query("SELECT Title FROM ng_main");    // i also need it to "SELECT Source FROM ng_main"    // $res = mysql_query("SELECT Title,Source FROM ng_main"); // didn't work       while ($row = mysql_fetch_array($res))    {           $words[] = preg_replace("/[\r\n]/s"," ",$row['Title']);       //$words[] = preg_replace("/[\r\n]/s"," ",$row['Title']['Source']); // this didn't work either!    }    mysql_free_result($res);    $words2 = array();    $words3 = array(); } Thank you for your help. Back to top ci5co Web Design Newbie Joined: Aug 18, 2004 Posts: 89 Posted: Sat Feb 11, 2006 9:57 pm    Post subject: $row['Title']['Source'] <-- This means that 'Title' would be an array, containing an entry with a 'Source'-key. What you need to do, is to replace both results separately, like this Code:  $res = mysql_query("SELECT Title,Source FROM ng_main"); ..... $words[] = preg_replace("/[\r\n]/s"," ",$row['Title']); $words[] = preg_replace("/[\r\n]/s"," ",$row['Source']);  _________________ White Papers Internet Marketing Boku Back to top Display posts from previous: All Posts1 Day7 Days2 Weeks1 Month3 Months6 Months1 Year Oldest FirstNewest First         Computer Help Forum and Programming Advice Forum Index -> Php All times are GMT + 10 Hours Page 1 of 1   Jump to: Select a forum Programming or Learning Help----------------HtmlPhpAspGraphic WorkshopSQL and DatabasesCCNA, MCSE, A Plus, CISSP HelpNetworking HelpGeneral ProgrammingInformation Security Computer Hardware and Software Help----------------FREE Share Computer SoftwareIntroduce YourselfAdware and spyware prevention tipsComputing in the NewsComputer General Help TopicHardware HelpWebhostsProduct Review Website and Computer Help----------------Site Suggestions  You cannot post new topics in this forum You cannot reply to topics in this forum You cannot edit your posts in this forum You cannot delete your posts in this forum You cannot vote in polls in this forum Forums © Learn Chinese | Learn cantonese | Learn Mandarin | Grace Park | Party Organisers | Kaila yu | Phone Card | Twins | Chinese Society | Loans UK | BokuMaro | CV Help Book | Chinese Wife | Korean Singles | British Born Chinese | Bae Yong Jun | Speak Korean | Chinese Models | Music | Information Security Management | Maritime Greenwich Campus | Covering Letters Help | Chinese Music | Jang Nara | SES | YG Family | Learn Korean | Firewall Definition | Server Definition | Wireless Network Definition | E-Commerce Definition | Sales Leads | Application Firewall | CCNA definitions | Research Papers | Webcast | CV Help Author KPop Music :- Jon Bock ( Chinese Pop Music Learn Korean ) Produced by Kpop-Web Design Associates, all rights not reserved. Internet Marketing and Search Engine Optimisation Software Defined Radio