 |
 |
 |
 |
|
|
Date: 07/24/02
- Next message: Martins Junkers: "[PHP-DB] Informix ifx_close"
- Previous message: Russ: "RE: [PHP-DB] problem with where clause"
- In reply to: JJ Harrison: "[PHP-DB] problem with where clause"
- Messages sorted by: [ date ] [ thread ] [ subject ] [ author ]
Thanks for the replies so far.
I see which method is best in 5-10 min.
My question is that if SQL/mySQL support some sort of function to see if a
database entry is in the supplied text?
-- JJ Harrison webmaster <email protected> www.tececo.com"Jj Harrison" <webmaster <email protected>> wrote in message news:20020724081409.85593.qmail <email protected> > Here is my query(It is part of a search script and is dynamicly generated): > > select 0 + article_keyword.weight * article_keyword.keyword like '%green%' > as score, article_keyword.aid, article_data.name, article_data.time, > article_data.description from article_keyword, article_data where score > 0 > and article_data.aid = article_keyword.aid group by article_data.aid order > by score desc > > when I do the query in PHP I get a message saying: Unknown column 'score' in > 'where clause'. > > How can I fix this? > > > -- > JJ Harrison > webmaster <email protected> > www.tececo.com > > >
-- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
- Next message: Martins Junkers: "[PHP-DB] Informix ifx_close"
- Previous message: Russ: "RE: [PHP-DB] problem with where clause"
- In reply to: JJ Harrison: "[PHP-DB] problem with where clause"
- Messages sorted by: [ date ] [ thread ] [ subject ] [ author ]