Re: PLS Advise, Highlighted Text from a Query

Yes please that is what i want.. if it possible to give em the code.. thanks in advance for you and for George Pitcher "Cristian Marin" <cristic@iakt.rdsnet.ro> wrote in message news:20030618075554.73634.qmail@pb1.pair.com... > Yes it is posible using the preg_replace substituing the text with </b>the > text</b> or to what ever you want. > > If you are not advanced in php you could do it with substr_replace() > function. > > The first solution is more dificult to be used but you have the advantage > you can search for each word used in the %search_words% and highlight them > even if they are not positioned in the same order in the text searched. (But > in this case you have to use the MySQL 'match against' with the full text > indexing in place of like). > > The result is something like this: > http://www.interakt.ro/search.php. Try > searching 'mysql adodb' > > If this is what you want I can help you with a code block > > > > -- > ------------------------------------------------- > Cristian MARIN - Developer > InterAKT Online (www.interakt.ro) > Tel: +4021 312.53.12 > Tel/Fax: +4021 312.51.91 > cristic@interakt.ro > "Nabil" <nabil.attar@aws-syria.com> wrote in message > news:20030618064522.21569.qmail@pb1.pair.com... > > Dear all, > > > > 1- I have a form with an input text : keyword > > 2- the field address is in my MySQL as TEXT field. > > 3- I select * from db where address like '%keyword%' > > 4- I want when echo the return $row["address"] to highlight the entered > > keyword (that the user has entered in the search form) in the output with > a > > different font backcolor or by just another color... to let the user see > > what he was searching for > > 5- and if it possible to echo how accurate (percentage) the return rows > has > > fit his search... > > > > Please Advise how to do it... > > > > > >