On Wed, 2002-02-27 at 23:54, arun kv wrote: > hello, after retriving a string from database using select command how to > display the part of string. for eg. after select command i get "computer > architecture algorithms" as output. if i search for string starting with > ar it will search the table will print whole of "com > ... algorithms" instead of > "architecture" how to print only a part of string like this. > thanx in advance > arun Hi Arun, The string and regular expression functions allow you to do things like this. See the PHP manual http://www.php.net/manual for more details. Functions that are likely to be most useful are explode, split and preg_match. Be warned - the preg functions are challenging for users not familiar with regular expressions. Here is an example: $data = pg_result ($result, 0, 0); $array = explode (' ', $data); // Print the second word in the array echo $array[1]; // Print the first and third words in the array echo $array[0] . " " . $array[1]; Good Luck! -- Zak Greant MySQL AB Advocate PHP Quality Assurance Team
